Verfügbare Anbieter
- General Call detail record (CDR): The general CDR encapsulates a telephony traffic event with the most important informations of telephony calls.
rem --------------------------------------------------------
rem Group1 aktualisieren, Stammzone
rem Group2 aktualisieren
rem PrefixName aktualisieren (verwendet im EVN !!!)
rem --------------------------------------------------------
cd ../trunk/Bin/Debug
Billing.JobHost.exe SqlCommand "UPDATE ResourceUsageRecord SET Group1 = (SELECT TOP (1) InhZone AS Expr1 FROM E164PrefixView AS T2 WHERE (SUBSTRING(ResourceUsageRecord.Destination, 1, { fn LENGTH(DialPrefixId) }) = DialPrefixId) ORDER BY DialPrefixId DESC) WHERE (Group1 IS NULL) AND (Destination IS NOT NULL) AND (Time > DATEADD(hour, - 48, { fn NOW() }))"
Billing.JobHost.exe SqlCommand "UPDATE ResourceUsageRecord SET Group2 = (SELECT TOP (1) InhType AS Expr1 FROM E164PrefixView AS T2 WHERE (SUBSTRING(ResourceUsageRecord.Destination, 1, { fn LENGTH(DialPrefixId) }) = DialPrefixId) ORDER BY DialPrefixId DESC) WHERE Group2 IS NULL AND ResourceUsageRecord.Destination IS NOT null and carrier IS NOT null AND (Time > DATEADD(hour, - 48, { fn NOW() }))"
Billing.JobHost.exe SqlCommand "UPDATE ResourceUsageRecord SET Zone = (SELECT TOP (1) LEFT(InhZone + ' ' + REPLACE(DialPrefixName, 'Germany ', ''), 50) AS Expr1 FROM E164PrefixView AS T2 WHERE (SUBSTRING(ResourceUsageRecord.Destination, 1, { fn LENGTH(DialPrefixId) }) = DialPrefixId) ORDER BY DialPrefixId DESC) WHERE (Zone IS NULL) AND (Destination IS NOT NULL) AND (Time > DATEADD(hour, - 48, { fn NOW() }))"
Wir arbeiten mit Software von http://www.campus21.de.
Verantwortlich für angezeigte Daten ist der Webdomain-Eigentümer laut Impressum.