MOH audio source - how to find which device use it.?

[UC Support]

Hi

I'm running a cluster of CUCM 8.6. I'm looking for a report that can show the MOH audio source used by each device. (It will be nice to see the Dependency Records in the MOH Audio Sources web page, but there is no such page)

The reason for this is because by company policy every device must use the customized MOH audio (audio source 3) or use the default audio source 2. I have almost 2000 devices most of them they use this customized file but not all of them. I suspect that some devices are still using the 1-SampleAudioSource

So can someone tell me if there is a way to let's say, find out which devices (IP Phones, CTI ports, etc) use the 1-SampleAudioSource wav file.

By the way, we are not using the Common Device Configuration and in the Clusterwide Parameters (MOH Audio Source) we have changed from default 1 to 2 (in order to use the SilenceAudioSource). The rest is configured at the Device level.

Thanks in advance

Carlito

[Anthony Holloway · Accepted solution]

Here you go:

select name, networkholdmohaudiosourceid, userholdmohaudiosourceid from device where networkholdmohaudiosourceid = 1 or userholdmohaudiosourceid = 1

Run that SQL statement from the CLI of the publisher with this command:

admin:run sql 

If you simply want a report for all devices:

select name, networkholdmohaudiosourceid, userholdmohaudiosourceid from device

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.

[UC Support]

Hi Anthony,

It works like a charm.

Thanks and regards

Carlito

[Anthony Holloway]

Wunderbar!

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.

[Rob Huffman]

Hi Anthony,

Awesome support here my friend! +5 all day long

Cheers!

Rob

"And if I should fall behind
Wait for me" - Springsteen

[Anthony Holloway]

Thank you for the support...of my support...of the support forums? 

What I'm trying to say is: thank you.

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.