SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

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'

Comments

 

Finding all PCs with MS Access using ARP data | My CMS said:

Pingback from  Finding all PCs with MS Access using ARP data | My CMS

July 31, 2013 6:39 AM

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems