10-22-2003 04:26 PM - edited 03-13-2019 02:12 AM
UM 3.15, E2K
Looks like there is bug in the pager notification.
User inputs an invalid phone number for the pager. Unity constantly dials the number. Public network answers with an invalid number message. I locate the subscriber associated with this invalid phone number and disabled the notification.
After disabling the device, the web status monitor continues to show the number being dialed over and over.
Is there an easy way to find the subscriber that has the bad phone number in a device notification? I currently use a sql query.
Sabas Chois
10-22-2003 04:37 PM
What SQL query are you using? That's still the best mechanism to find a random notification dial string where you don't know the owner...
10-22-2003 04:44 PM
SELECT NotificationDevice.Alias, NotificationDevice.DlvdevicePhoneNumber, NotificationDevice.DlvdeviceType, NotificationDevice.ParentAlias
FROM UnityDb.dbo.NotificationDevice NotificationDevice
WHERE (NotificationDevice.DlvdevicePhoneNumber Like '%5210')
I am trying to put together an ASP to put on the Unity server so folks don't have use the sql query method. In our case, we have two groups handling Unity. Data folks handling anything on the server and voice telecom techs that only have access ti Unity via the web tools. Can you help with this?
I would like to have the web form ask for the last 4 digits, execute the query, present the information of the associated subscriber along with a link to the subscriber in the SA. Like you have on DBwalker.
Sabas
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide