ELM licence usage data report is not populating

[PhanindraAtchi]

Hello Team,

I could not able to retrive the licence information report from the Reports tab. I see cluster details are also not showing on the report page. Please help to how to trouble shoot and get this data populated.

Regards,

Phani

[Shoaib_Dilawar]

Hey @PhanindraAtchi,

can you try to run the below command from WebUI node and see what you get?

..\irpqlcli "SELECT Vendor, Type, TopLevelName from AppStartIpTelephonyGenericRecordView" -r

This report is looking for clusters with Vendor as 'Ci' and Type as 'C5'. do you get any that match this crietaria? If you are not getting anything back, try restarting PrognosisSite from IIS.

[PhanindraAtchi]

Hi Shoib,

I got below output .

Regards,

Phani

[Shoaib_Dilawar]

Hey @PhanindraAtchi It confirms that you have atleast 1 cluster that should appear in the drop down.

The other thing I'd check is if it is due to RBS. Can you run the below query to see what Customer it belongs to.

..\irpqlcli "SELECT Customer, Vendor, Type, TopLevelName from AppStartIpTelephonyGenericRecordView" -r 

And then, for your Role, that you are logged in with, does it have specific CUSTOMERS associated? If so, you'll have to make sure it includes the customer returned in above query.

[PhanindraAtchi]

Hi Shoib,

I have executed below query and got the output as below:

And i have verified in admin page its looks like it was configured with Role Public. Please look into this and let me know if any changes should required.

Thanks,

Phani

[Shoaib_Dilawar]

@PhanindraAtchi, Is it possible that your username is also part of the 'Royal' RBS? Can you confirm what Customers 'Royal' has access to? And if it is using 'specific', the above mentioned customer is checked?

[PhanindraAtchi]

Hi Shoib,

The username which we are using for this customer is "prognosis" and we are not configured username as Royal for any customer and all the customers are in different subnets which we monitor individually. And i also wants to inform tha this issue persists only the Report Tab : ELM licence usage . Remaining all the are workking normally.

Thanks,

Phani

[Shoaib_Dilawar]

@PhanindraAtchi,

another thing I just noticed is that it specifies version 9 and greater. Can you confirm that for the below query what version you are getting?

..\irpqlcli "SELECT Customer, Vendor, Type, MajorSoftwareVersion, TopLevelName from AppStartIpTelephonyGenericRecordView" -r

The report description says "Cisco Enterprise License Manager (ELM) related user and unassigned device license usage (applicable to Cisco Unified CM version 9.0 and higher)"

[PhanindraAtchi]

Hi shoib ,

This call manager version is 8 . So , This ELM usage report will work only on version 9 or above?

 let me know still any report tabs will not work under this verison.I will check with my customer for upgrade.

Thanks,

Phani

[Shoaib_Dilawar · Accepted solution]

@PhanindraAtchi you are right, only 9 and above.