Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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