Reporting on USER MOH audio source

[don.click1]

We have a UCM 7.5 install here.  Recently we have seen a couple of RTMT alerts related to Media list

exhausted, based on a MOH audio source. However, RTMT is lacking ALOT of info when it comes to troubleshooting.

So, I am tring to run a report through the Bulk Admin -> Phones -> Generate Phone Reports to show me all the phones settings for the User Hold MOH Audio Source - but its not in the list.

I can report on the NETWORK MOH Audio source, but not the USER.

Does anyone  have a way to generate a report that will show me the device name and USER MOH Settings?  (Not on the line, but the device).

TIA!

[srsivara]

Hi,

You can use sql queries to find out which devices are using a particular MOH audio source :

Order of preference (descending) :
Line
Device
Common Device Config
Service Parameter

Let's say you want to find out where MOH audiosourceid is used in the system :

Line :  

run sql select dnorpattern from numplan where userholdmohaudiosourceid = '2'
run sql select dnorpattern from numplan where networkholdmohaudiosourceid = '2'  

Device :  

run sql select name from device where userholdmohaudiosourceid = '2'
run sql select name from device where networkholdmohaudiosourceid = '2'

Common Device Config :  

run sql select pkid from commondeviceconfig where holdpartyuserholdmohaudiosourceid = '2'
run sql select pkid from commondeviceconfig where holdpartynetworkholdmohaudiosourceid = '2' 

Service Parameters 

- Default User Hold MOH Audio source
- Default Network Hold MOH Audio source

-----

In your case, if you are looking for only devices using MOH audiosourceid 'x' on the device config page, you would run :

run sql select name from device where userholdmohaudiosourceid = 'x'

- Sriram

Please rate helpful posts !

[Craig Dyer]

Sriram,

     You beat me there. 5*

Have a good day,

Craig

[don.click1]

thanks for the sql tips. Ill try to modify those to my needs -  the problem isnt what phones are assigned to a particular MOH Source, but rather, which one

s are assigned to one that does NOT exist?.

[srsivara · Accepted solution]

You can do the following :

Line :  

run sql select dnorpattern, userholdmohaudiosourceid, networkholdmohaudiosourceid  from numplan

Device :  

run sql select name, userholdmohaudiosourceid, networkholdmohaudiosourceid   from device

Common Device Config :  

run sql select pkid, holdpartyuserholdmohaudiosourceid, holdpartynetworkholdmohaudiosourceid  from commondeviceconfig

---

Copy these ouptuts into a text file, rename it to .csv, and then sort based on 'userholdmohaudiosourceid' and 'networkholdmohaudiosourceid' columns separately. From the CCM admin page, you can see the list of MOH audiosourceid's available of your system. Looking at the csv files, you should be able to confirm which entities on the system are referencing a MOH audiosourceid which doesn't exist in the system.

- Sriram

Please rate helpful posts !

[Craig Dyer · Accepted solution]

Don,

     To get details of just the phones you could to an Bulk>Export>Phones>All Details

     Other than that it is possible to do an SQL query, run this on the CLI of your CUCM and it will list all devices, the GUID of the MGRL and the audio file numbers.

     run sql select name,fkmediaresourcelist,networkholdmohaudiosourceid,userholdmohaudiosourceid from device

     Give you an output like:-

SEP001DA2674A00                                70d9ea77-5cc5-478c-915f-b282db0bad35      1                           1                            
SEPACA016FCE3AA                                9dcb9fc5-6d4e-4662-9dbc-32f8539a7481      NULL                        NULL       

As I guess your only looking for missing items I haven't cross referenced the tables to get meaningful names.

Craig

PLEASE RATE HELPFUL POSTS