Asset Management Suite

 View Only
  • 1.  query to find the info

    Posted Jan 08, 2015 01:56 AM

    Is there anyquery to find the client installation detail?

    I am searching the client list where msoffice is install or not and what version is installed there?



  • 2.  RE: query to find the info
    Best Answer

    Posted Jan 08, 2015 01:58 AM

    Check the thread

    https://www-secure.symantec.com/connect/forums/microsoft-office-installation-report-version

    ##edit##

    Report

    Reports > All Reports, then expand Reports > Discovery and Inventory > Inventory > Cross-platform > Software/Applications > Installed Software or Installed Software by Computer.  For example, using the Installed Software report, type '%office%' for the Company OR '%Microsoft%' for the Name

    Article

    https://www-secure.symantec.com/connect/articles/simple-sql-report-reporting-microsoft-office-installed-versions



  • 3.  RE: query to find the info
    Best Answer

    Posted Jan 08, 2015 02:00 AM

    https://www-secure.symantec.com/connect/forums/installed-software-query

    DouglasDunphy shared comment

    Reports>All Reports>Discovery and Inventory>Cross-Platform>Software/applications>Software.  In this folder are two reports:

    Installed Software

    Installed Software by Computer

    If you want raw SQL instead:

    Select arp.[DisplayName], arp.[DisplayVersion], Count(*)

    from Inv_AddRemoveProgram arp

    Where arp.[DisplayName] like '%Adobe%'

    Group by arp.[DisplayName], arp.[DisplayVersion]

    Replace "Adobe" in the query above with whatever product name you want.  You can include "or" statements to add products:

    Select arp.[DisplayName], arp.[DisplayVersion], Count(*)

    from Inv_AddRemoveProgram arp

    Where

    arp.[DisplayName] like '%Adobe%'

    or

    arp.[DisplayName] like '%Microsoft%Office%'

    or

    arp.[DisplayName] like '%Adobe%'

    Group by arp.[DisplayName], arp.[DisplayVersion]