SQL select query for total license count

[Jay Schulze]

Hello,

Does anyone happen to know a query which can be run on CUCM for license count total installed?

I was able to dig out one for license count in use btw in case anyone needs it. But need it for monitoring purposes can't use license report via gui.

admin:run sql SELECT name,value FROM TABLE (FUNCTION LicenseTotals()) (pkid,name,value,UserValue,DeviceValue)

[Leonardo Santana]

Hello Jay,

Does the CUCM Report does not fit to you?Only thourgh CLI?

Regards

Leonardo Santana

[Jay Schulze]

Hey Leo,

Well it would be good if I just had to do it one time. But this is for one of our polling tools. So have to find a way where I can do it via ssh(i.e. cli). It's really difficult to cut stuff up from http.

J

[bgardner]

Same problem here.

The ELM web interface can produce the info so there must be a way.  Anyone?

[Deepak Rawat]

Refer to below link in order to understand License Calculation in CUCM 9.x and above:

http://www.cisco.com/c/en/us/support/docs/unified-communications/unified-communications-manager-callmanager/117600-technote-cucm-00.html#anc6

Regards

Deepak