cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2311
Views
15
Helpful
5
Replies

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

UC Support
Level 1
Level 1

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

Anthony Holloway
Cisco Employee
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

Anthony Holloway
Cisco Employee
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.

Hi Anthony,

It works like a charm.

Thanks and regards

Carlito

Wunderbar!

Anthony Holloway

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

Rob Huffman
Hall of Fame
Hall of Fame

Hi Anthony,

Awesome support here my friend! +5 all day long

Cheers!

Rob

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

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.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: