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

Report Showing Software Installation Detail Over Licence Purchase

Created: 27 Apr 2012 • Updated: 27 Apr 2012 | 2 comments
SanjayDeo7x's picture
+1 1 Vote
Login to vote

If you're facing problems in creating a report, where you are asked to display particular software [ e.g. adobe player] install above the count of license purchase.  

Please then try this SQL query to generate the report and it can also be use in automation policy.

SELECT us.DisplayName,vc.Name,vc.[IP Address]

FROM (SELECT ROW_NUMBER() OVER (ORDER BY [displayname]) AS Row , DisplayName ,[_ResourceGuid]

     FROM Inv_AddRemoveProgram

     where [DisplayName] LIKE '%Flash Player%') us

     join vComputer AS VC

on us.[_ResourceGuid] = VC.[Guid]

WHERE Row >= 20

Comments 2 CommentsJump to latest comment

toca's picture

Thanks so much for this....

It's exactly what i was looking for...

0
Login to vote
toca's picture

you have not by any chance figured out how to add the loaction of the machines into these reports hey?

0
Login to vote