Software by OU

SELECT 
    ARP.DisplayName0, 
    Count(*) AS 'Count', 
    ARP.Publisher0, 
    ARP.Version0
FROM 
    dbo.v_Add_Remove_Programs ARP
    join dbo.v_RA_System_SystemOUName OU on OU.ResourceID = ARP.ResourceID
WHERE 
    OU.System_OU_Name0 = @OU
GROUP BY 
    ARP.DisplayName0, 
    ARP.Publisher0, 
    ARP.Version0 
ORDER BY 
    ARP.Publisher0, 
    ARP.Version0

Leave a Reply

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