Problem Description
We have a CUCM 7.5 installed here and recently we have seen a couple of RTMT alerts related to Media list exhausted, based on a MOH audio source. However, RTMT doesnt show all the information. So, I am trying to run a report to show me all the phones settings for the User Hold, MOH Audio Source.
Does anyone know how to generate a report that will show, which device is using what Music On Hold (MOH) audio source?
Solution
Here's the solution to find which device is using Music On Hold (MOH) audio source using SQL Query in Cisco Unified Communications Manager
Report that can show the MOH audio source used by each device. You can use sql queries to find out which devices are using a particular MOH audio source :
Way to find out which devices (IP Phones, CTI ports, etc) use the 1-SampleAudioSource wav file
Solution:
==========================================================
1. Run the below SQL statement from the CLI:
admin: run sql select name, networkholdmohaudiosourceid, userholdmohaudiosourceid from device where networkholdmohaudiosourceid = 1 or userholdmohaudiosourceid = 1
2. If ONLY want a report for all the devices:
admin: run sql select name, networkholdmohaudiosourceid, userholdmohaudiosourceid from device
Sample output:
run sql select name,fkmediaresourcelist,networkholdmohaudiosourceid,userholdmohaudiosourceid from device
output:
===========================================================================================
SEP001DA2685A00 70d9ea77-5cc5-478c-915f-b282db0bad35 1 1
SEPACD016FCE3AA 9dcb9fc5-6d4e-4662-9dbc-32f8539a7481 NULL NULL
