ITMS Administrator Group

 View Only
Back to discussions
Expand all | Collapse all

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

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

    Posted May 14, 2013 03:21 PM

    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



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

    Posted May 15, 2013 03:14 AM

    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