Report Showing Software Installation Detail Over Licence Purchase
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]
where [DisplayName] LIKE '%Flash Player%') us
join vComputer AS VC
on us.[_ResourceGuid] = VC.[Guid]
WHERE Row >= 20