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
Solved! Go to 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.
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.
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.