Client Automation - Where is Software Usage (Software Metering) data stored in the MDB?

book

Article ID: 16911

calendar_today

Updated On:

Products

CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation

Issue/Introduction



Where is software usage monitoring (software metering) data stored in the database?

Environment

Client Automation (ITCM) -- all versions.

Resolution

Software metering data is stored in two tables in the MDB:



select * from infohis -- Offline metering data
select * from audithis -- Auditing data



A definition for each column in these tables can be found here:



https://support.ca.com/phpdocs/0/common/impcd/r11/MDBMain/schema/viewer/index.htm



Choose the "alphabetical" tab at the top of the page, and browse for the infohis and audithis tables.

Additional Information

Attachments