CUCM 7.1.5 - SQL Search - Media resources registration

[Jose Ignacio Leite Neto]

Hi All,

Is there a way to pull registration status for media resources from the CLI Sql query?

i the goal here is to pull a list of the unregistered media resources.

Let's say that a change will happen on the CUCM environment, by RMTM i can find the number of registered Xcode, MTP and CFB. However will give only the numbers, what i need is a list of the unregistered (or registered xcode, MTP and CFB) so i can compare before and after the change.

i think if there is a SQL query that can pull the name and the resource and its status will do it, any ideas?

Best regards,

[Gordon Ross]

Registration information isn't held in the SQL database, so can't be accessed via a SQL query.

Sorry,

GTG