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

Products

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

Issue/Introduction

How to find out where software metering data stored in the database?

Environment

Client Automation (ITCM) - All supported 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://ftpdocs.broadcom.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