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

Document ID : KB000016911
Last Modified Date : 02/03/2018
Show Technical Document Details
Question:

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

Environment:
Client Automation (ITCM) -- all versions.
Answer:

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:

2017-12-19_12-03-26.png

2017-12-19_12-03-58.png