Client Management Suite

 View Only
  • 1.  Software Usage Reports?

    Posted Aug 28, 2013 03:30 PM

    We are running Altiris 7.1.  We have an application that is installed on most of our corporate computers, but a lot of people do not need it and do not use it.  We are trying to gather a list of computers, where users actually have ran the software.   I thought those metrics might be available in the IT Analytics - Installed Software Cube, but is not working.  Can anyone point me to a process/method where I can obtain that kind of information in Altiris?  Also, this application is cutom built VB6 stuff and takes a 3 pages of directions to install it, so it is not packaged in the Altiris software library.  Hoping we could possibly query it by filename, like C:\ProgramFiles\Custom\CustomApp.exe or something like that.  Even the name of a table that might contain some of that info would be helpful.

    Thanks,

    Dan



  • 2.  RE: Software Usage Reports?

    Trusted Advisor
    Posted Aug 28, 2013 05:53 PM

    You need to enable Application Metering for that application and that requires it to be defined in the Software Catalog.

    Plain old .exe files are inventoried by default software inventory rules so at least you have data on where that app resides.  You can create a Software Catalog for just the .exe and then enable metering.

    However, the big gotcha is that you only get usage data from the point in time that you enable the metering policy. 

    Also, you'll have to understand for yourself what you mean by "not used".  Do you mean 30 days?  90 days?

    Finally, a difficult to install piece of software is a great candidate for Software Virtualization.  You realize that with CMS you own the necessary license to use that, right?



  • 3.  RE: Software Usage Reports?

    Posted Aug 28, 2013 06:58 PM

    Yes, HighTower is correct, you need to enable Application Metering. Currently, we use a wildcard and meter all applications so that we absolutley have the data because like HighTower said you can only pull data once you start metering it. Once you enable it, you can use this SQL querey I wrote to pull the data. Just replace "Photoshop" with the name of the exe you are looking to discover...

    --------

    SELECT
     
    vc.[Name] AS Computer_Name,
    vc.[User] AS Primary_User,
    eas.[Start Date] As Launched,
    eas.[FilePath] AS Program,
    est.[Total Run Time]
     
    FROM
     
    vComputer vc
    JOIN Evt_Application_Start eas ON eas._ResourceGuid = vc.Guid
    LEFT JOIN Evt_Application_Stop est ON eas._id = est._id
     
    WHERE
     
    -- START Date parameter below uses current time MINUS (X) days 
    eas.[Start Date] > CURRENT_TIMESTAMP-100
    AND
     
    -- Put the file EXE in the wild card parameter below
    eas.[FilePath] like '%Photoshop%'
     
    ORDER BY 
     
    eas.[Start Date] ASC


  • 4.  RE: Software Usage Reports?

    Posted Aug 28, 2013 07:01 PM

    If there is anything else you'd like added to that report let me know, happy to help. 



  • 5.  RE: Software Usage Reports?

    Trusted Advisor
    Posted Aug 28, 2013 09:36 PM

    Can you describe if you've had a notable impact on DB size running Metering against everything?  I'd consider that but not if my DB doubles in size :)



  • 6.  RE: Software Usage Reports?

    Posted Aug 29, 2013 01:23 AM

    I am interested too... We thought about that, but we are going to reach over 30K workstations and a big amount of servers too, so metering everything may need a database such big as 10 football stadiums....



  • 7.  RE: Software Usage Reports?

    Posted Aug 29, 2013 10:06 AM

    For metering with the wildcard on EXE? Yeah the tables are pretty substantial, however, we only have about 3000 endpoints so the database is still pretty manageable in size (100gb or so) 



  • 8.  RE: Software Usage Reports?

    Trusted Advisor
    Posted Aug 29, 2013 10:08 AM

    Ouch, I'm managing 7200 endpoints with a 56gb database.  I could envision this swelling to 120gb or more.
     

    Thanks, it's definitely something to keep in mind.