...
To check quickly if you have a proper UDRMediated and UDRRated record you can run the SQL below where UdrUsageIdentifier is equal to whatever was added as the UdrUsageIdentifier into the service:
| Code Block | ||
|---|---|---|
| ||
SELECT M.ID, M.Date, M.UDRUsageIdentifier, M.Value, R.UDRMediatedID, R.ValueRounded, R.ChargePreBucketing, R.Charge
FROM UDRMediated M INNER JOIN UDRRated R
ON M.ID = R.UDRMediatedID
WHERE UDRUsageIdentifier like '%<UdrUsageIdentifier>%' ORDER BY ID DESC |
...