截屏视频帮助

Report Showing Software Installation Detail Over Licence Purchase

创建时间: 27 4 月 2012 • Updated: 27 4 月 2012 | 2 条评论
SanjayDeo7x 的图片
+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

评论 条评论跳转至最新评论

toca 的图片

Thanks so much for this....

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

0
Login to vote
toca 的图片

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

0
Login to vote