cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
1412
Views
15
Helpful
5
Replies
Highlighted
Beginner

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Cisco Employee

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.

View solution in original post

5 REPLIES 5
Highlighted
Cisco Employee

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.

View solution in original post

Highlighted

Hi Anthony,

It works like a charm.

Thanks and regards

Carlito

Highlighted

Wunderbar!

Anthony Holloway

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

Highlighted
Hall of Fame Community Legend

Hi Anthony,

Awesome support here my friend! +5 all day long

Cheers!

Rob

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

Highlighted

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.

Content for Community-Ad