What Tables and or Views can I use to create my own Application Metering Reports?

Products

• Inventory Solution
• IT Management Suite

Issue/Introduction

You want to create your own Application Metering / Application Usage type report but don't know what tables and views are best to use.  It would be recommended to use professional services to write the report for you, but if you just need table information, this article will help.

Environment

Release: 8.6

Resolution

Here is an example of some data that you may wish to have included in your report and where to find them.

Software Tables:

Publisher	Version	Assigned To	Last Scanned	Installed On	Product ID	Display Name	Install Date	Hidden
ABC Company	5.0.3	Fred	5/25/2002	1/5/2001	4659E52B-AAEF-47C4-8A36-374B9A356F1A	ABC Company Reporter	1/2/2001	0
Table:  Inv_AddRemoveProgram Column:  Publisher	Table:  Inv_AddRemoveProgram Column:  Display Version	View:  vComputer Column:  User	Table:  ResourceUpdateSummary Column:  DataLastChangedDate	Table:  Inv_AddRemoveProgram Column:  InstallDate	Table:  Inv_AddRemoveProgram Column:  ProductCode	Table:  Inv_AddRemoveProgram Column:  DisplayName	Table:  Inv_AddRemoveProgram Column:  InstallDate	Table:  Inv_AddRemoveProgram Column:  Hidden

Usage Tables:  vAMMonthlySummary goes to the file.  You will need to join ResourceAssociation to get from the file to the component and group the data or use a max etc depending on what you want to see.

Publisher	Product	Version	Last Used Time	Installed On	Assigned To	Usage Count	Product ID
ABC Company	ABC Company Reporter	5.0.3	5/25/2002	1/5/2001	Fred	14	4659E52B-AAEF-47C4-8A36-374B9A356F1A
Table:  Inv_AddRemoveProgram Column:  Publisher	View:  vAC_ComputerLicenseAndUsageByComponent Column:  Software Component Name	Table:  Inv_AddRemoveProgram Column:  Display Version	View:  vAC_ComputerLicenseAndUsageByComponent Column:	View:  vAC_ComputerLicenseAndUsageByComponent Column:  Install Date	View:  vAC_ComputerLicenseAndUsageByComponent Column:  User	View:  vAMMonthlySummary Column:  Total Run Time	Table:  Inv_AddRemoveProgram Column: Product Code