Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Adobe Flash Report

Created: 29 Aug 2012 | 2 comments

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?

Comments 2 CommentsJump to latest comment

Ashish-Sharma's picture

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

Thanks In Advance

Ashish Sharma