Client Management Suite

 View Only
  • 1.  Adobe usage report

    Posted Jun 07, 2012 03:58 AM

    Hi,

    I've been asked to list all our Adobe software and the systems it's installed on. I'm trying to create a report for this, but currently without much luck. Can anyone provide me (dummy-proof ;o) instructions on how to accomplish this?

    thanks in advance

     

    Walter 



  • 2.  RE: Adobe usage report
    Best Answer

    Posted Jun 07, 2012 07:26 AM

    Ok what you need to do is go to reports. In here you can create an SQL report that will get you the list of adobe products and the machines they are installed on. From that you can narrow down your search and get more details. From the top level of reports i would recommend drilling down or creating a folder for you to start creating your reports in. Once thats done right click and create SQL Report.

    The basic report you're looking for will look like this:

    The InstallFlag is there stating that the software is currently installed on the machine based on the Inventory.

    SELECT
       vC.Guid,
       vC.[Name],
       addrem.DisplayName,
       addrem.DisplayVersion
       addrem.Publisher
    FROM
     [vComputer] vC
        INNER JOIN [Inv_AddRemoveProgram] AS [addrem] ON ([vC].[Guid] = [addrem].[_ResourceGuid])
    WHERE [addrem].Publisher like 'Adobe%'
    and addrem.InstallFlag=1

    Once you have the Data from that you can start being abit more picky and filtering off the rubbish you dont need.

    Heres an example of something for MS Office (this states that its looking for a display name that contains office and 2010 but doesnt include proof, service pack or components):

    SELECT
       vC.Guid,
       vC.[Name],
       addrem.DisplayName,
       addrem.DisplayVersion
       addrem.Publisher
    FROM
     [vComputer] vC
        INNER JOIN [Inv_AddRemoveProgram] AS [addrem] ON ([vC].[Guid] = [addrem].[_ResourceGuid])
    WHERE [addrem].DisplayName like 'Microsoft%'
    and [addrem].DisplayName like '%Office%'
    and [addrem].DisplayName like '%2010%'
    and [addrem].DisplayName NOT LIKE '%Proof%'
    and [addrem].DisplayName NOT LIKE '%Service Pack%'
    and [addrem].DisplayName NOT LIKE '%Components%'
    and addrem.InstallFlag=1

    For application metering there are reports under Software > Application Metering, but the agent must be installed the software you are looking to meter setup.

    Regards
    Jim

     



  • 3.  RE: Adobe usage report

    Posted Jun 08, 2012 02:41 AM

    Thanks. Exactly what I needed (and great to know these tables for the future!)



  • 4.  RE: Adobe usage report

    Posted Jun 08, 2012 03:12 AM

    No Problem, Glad i could help :)