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

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

book

Article ID: 243435

calendar_today

Updated On:

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