Hi Amosu,
May be this might be some help to get your requirement
===========================================================================================
How to gather concurrent license usage statistics for CA Service Desk Manager
Prior to SDM 12.7, gathering usage statistics required use of pdm_webstat on multiple servers and then combining the results together. This was tedious and error-prone.
Starting with SDM 12.7, the product includes a predefined KPI that accurately captures the number of concurrent users at a set frequency which is defaulted to each hour.
To turn on the Concurrent User count KPI:
1.1. Login using a UserID with Administrator privileges
2.2. Select the Administrator Tab
3.3. Navigate to the Service Desk->KPIs list and find the KPI named “webConcurrentTotalLicenseCt”
4.4. Open the webConcurrentTotalLicenseCt KPI
5.5. Activate the KPI if it is not currently Activated – Note that the sample frequency may be adjusted – Minimum of once hourly is recommended
There is an OOTB report that can be used to get the results of a KPI named “Service Desk SQL and Stored Query KPI Values”.
The values from the report gives a good indication of the usage. My recommendation is to view it as a simple line chart with DTStamp and the KPI value that will show normal usage peaks and valleys. This result can be used to see typical usage level for the given period.
Note that the licensing for a given customer should be based on the normal usage level, occasional peaks above the normal level (during shift turnover) and valleys (weekends) are expected. For this reason, you cannot use an average of the KPI values to determine the typical usage.
===========================================================================================