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?
Release : 17.3
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
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.