Query for webConcurrentTotalLicenseCt average license count

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

Looking for a database query for the webConcurrentTotalLicenseCt KPI average license count so I have idea on average how many licensed users log in and use CA SDM

Environment

Release : 17.3

Resolution

You can run this query on the CA SDM MDB database:

select AVG(kpi_value) As "Average License Count" from usp_kpi_data where kpi_id=8838

Note: Need to make sure that the 'kpi webConcurrentTotalLicenseCt' option is active in order to collect this data.

Administration-->Service Desk-->KPIs and make sure webConcurrentTotalLicenseCt is active - if not, activate it and restart the CA SDM service.