Overview

The customer says that one of the end subscribers receive a wrong usage notification SMS. This article provides ways to verify and check if there was any notification sent.

Solution

• First, verify the subscriber data from PCRF DB. Use the following SQL Select statement to identify the last notification that was sent:

select *from tblmnotificationhistory where subscriberidentity='<Subscriber ID shared on ticket>'

• • This will return an output such as this:

Dear User {Sub.SubscriberIdentity}, Your 80percent usage of ##### hi-speed data has been completed. To upgrade please give us a missed call @##########. Thanks, Team ########

• From the PCRF UI go to search Subscriber >Subscriptions > Click on the Base. This will show Usage data which can also be shared with customer. Example:

• Inform these to customers and ask them to validate.