Adobe Flash Report

Created: 29 Aug 2012 | 2 comments

Hodgkinsons

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?

Discussion Filed Under:

Comments 2 Comments • Jump to latest comment

Ashish-Sharma

Check this thread

Zac H Comments

Thanks In Advance

Ashish Sharma

Ashish-Sharma

HI Hodgkinsons,

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