cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
917
Views
1
Helpful
0
Replies

Gather License info from ELM on Unity Connecton using SQL Statement

jamhart1982
Level 4
Level 4

Hi,

I have a python script which checks CUCM/ELM and runs a SQL command "run sql select * from license server" this tells me if they system has gone into grace days and i can report on this

runsql.png

The problem I have is, if unity connection shares the same ELM (which is not standalone) and unity goes into License Violation this is not reported using all the SQL commands that are documented.

This shows License issue in ELM

elm-usage.png

This shows License issue in Unity Connection

unity-lic-usage.png

but when running SQL command this is not shown. Does anyone have any knowledge of where this info is stored in CUCM/ELM there must be a table that Unity looks at?

CUCM and Unity are both on version 11.5.1

i have looked at the following doc

License Calculation in CUCM release 9.x+ - Cisco

and the data dictionary on DevNet and cannot find anything.

Thanks

James

0 Replies 0