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.
Release: 8.6
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 |