search cancel

Extract Licence & User sessions data

book

Article ID: 189772

calendar_today

Updated On:

Products

CA Application Test Service Virtualization

Issue/Introduction

Trying to extract the licence and user sessions data from ED, IAM and Server DB's, could not get the actual details.

Need help, to submit the report to leadership.

Environment

All supported DevTest releases.

Cause

N/A

Resolution

Please find below the query to retrieve all the license usage data

SELECT reg_name.display_name AS registry_name, comp_name.display_name AS component_name, metric_tm, metric_value, m.metric_class, m.comp_uuid
FROM metric m
LEFT JOIN component comp_name ON m.comp_uuid=comp_name.comp_uuid
LEFT JOIN component reg_name ON reg_name.reg_uuid=m.reg_uuid AND reg_name.comp_typ=3
WHERE m.metric_class IN ('com.itko.lisa.coordinator.VirtualServiceEnvironmentImpl.models.maxNumberOfDeployedModelsLastHour', 'com.itko.lisa.coordinator.VirtualServiceCoordinator.global.transactionsInLastHour') ORDER BY m.metric_tm ASC

Also, the other tables for user-specific information are :
In Registry db: ACL_AUDIT_LOG
In IAM db: USER_ENTITY