CUCM 9 - 797x Phones Real Time Monitoring

[Taylor Scott]

Hi there, our campus is requiring an inventory of phones. possible to glance at what models, serial numbers and totals of phones in real time monitoring tool?

cheers,

matt 

[Deepak Mehta]

You should be able to get phone model and count from cisco unified reporting - cluster device summary report. 

I am not too sure if there is any way of exporting serial numbers. Thanks

[Deepak Rawat]

You can also try running below from CM CLI:

run sql select name,description,tkmodel from device where name like 'SEP%'

In order to match the phone model against the tkmodel which you get in the output of above command, simply run below command

run sql select name,tkmodel from TypeProduct

After you get the required outputs from above commands, simply put them in excel and get the total count. You can also change the query directly to get the count as well however Excel is pretty good to do all these kind of things in my opinion

run sql select count(name) from device where name like 'SEP%'

Regards

Deepak

[Jaime Valencia]

If you want SN of the devices, you need to look at 3rd party options to get that information