Video Screencast Help

Application Metering - What are the table names where application metering stores the data it collects on applications in ITMS 7.1?

Created: 14 May 2013 | 1 comment

We are trying to put together a application usage report on applications that have application metering policies. We are having problems trying to figure out where the data is stored and was hoping someone out there would know.

Also, in the Altiris 7.1 Console there is a report entitled "Executable Usage". That report has a drill down report named "Drill Down to Executable Usage" where can I find this drill down report or the SQL query it uses?

Thanks
Derik

Operating Systems:

Comments 1 CommentJump to latest comment

SK's picture

The majority of our drilldown reports are hidden, as their data depends upon data returned by the main report they are associated with.

If you open the LogViewer on the SMP and then run a report, you will be able to find the reports definition in an information entry.

 

That report uses the folloiwng database objects:

vAMMonthlySummary
Inv_Software_Execution
Inv_Windows_File
RM_ResourceFile
ResourceAssociation
Inv_InstalledSoftware
Inv_AeX_AC_Identification
ScopeMembership
GetTrusteeScopeCollections
Inv_AeX_AC_Client_Agent
fnGetTrusteeScopeCollections

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.