Client Management Suite

 View Only
  • 1.  Adobe Flash Report

    Posted Aug 29, 2012 11:53 AM

    i've been asked to produce a report which show's machines which don't have Adobe flash of any variant installed.

     

    Does anyone have a SQL report which is designed to show this from CMS7.1?



  • 2.  RE: Adobe Flash Report

    Posted Aug 29, 2012 11:59 AM


  • 3.  RE: Adobe Flash Report

    Posted Sep 03, 2012 10:22 AM

    HI Hodgkinsons,

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

    have you check attach Script.

    SELECT vc.Guid, vc.Name AS ComputerName, arp.DisplayName, arp.DisplayVersion, vu.Name AS UserName, vu.Department

    FROM vComputer vc
    RIGHT JOIN (SELECT DISTINCT Name FROM vComputer) AS vc1
    ON vc1.Name = vc.Name
    INNER JOIN Inv_AddRemoveProgram arp ON vc.Guid = arp._ResourceGuid
    INNER JOIN vUser vu ON vc.[User] = vu.Name
    WHERE arp.DisplayName LIKE 'Adobe Flash Player 10%' AND arp.InstallFlag=1