Finding all PCs with MS Access using ARP data

Use this query to find all PCs with MS Access installed using ARP data.

 

Select Distinct 
    sys.Netbios_Name0, 
    AD_Site_Name0,  
    sys.User_Domain0, 
    sys.User_Name0, 
    sys.Operating_System_Name_and0, 
    arp.DisplayName0, 
    arp64.DisplayName0, 
    arp.Version0,
    arp64.Version0 
FROM 
    v_R_System sys
    JOIN v_GS_ADD_REMOVE_PROGRAMS arp ON sys.ResourceID = arp.ResourceID 
    left outer JOIN v_GS_ADD_REMOVE_PROGRAMS_64 arp64 ON sys.ResourceID = arp64.ResourceID 
    JOIN v_FullCollectionMembership fcm on sys.ResourceID = fcm.ResourceID
WHERE 
    (arp.DisplayName0 like '%Microsoft Office Access MUI%' 
    or arp64.DisplayName0 like '%Microsoft Office Access MUI%')
    and fcm.CollectionID = 'SMS00001'

Leave a Reply

Your email address will not be published. Required fields are marked *