Query for installed machines report 'Adobe Flash Player '

Query for  installed machines report  'Adobe Flash Player ' :-



Select distinct sys.Netbios_Name0, fcm.SiteCode,  sys.User_Domain0, sys.User_Name0, arp.DisplayName0
 FROM v_R_System sys
 JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
 JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
  where arp.DisplayName0 LIKE 'Adobe Flash Player %'
 order by sys.Netbios_Name0