Query for webConcurrentTotalLicenseCt average license count

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

I am 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 the app? 

Environment

Release : 17.3

Resolution

You can run this query

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

on Service Desk mdb database. It will return like

Average License Count

66

Note: you would need to make sure the kpi webConcurrentTotalLicenseCt is active in order to collect these data. you can check/activate web interface-->Administration-->Service Desk-->KPIs and make sure webConcurrentTotalLicenseCt is active; if not, activate it.