Customized Report “computers with specific software registered in Add Remove Programs”

SELECT Distinct    
    sys.Netbios_Name0,
    fcm.SiteCode,
    sys.User_Domain0,
    sys.User_Name0,
    sys.Operating_System_Name_and0,
    arp.DisplayName0,
    u.department0
FROM
    dbo.v_R_System AS sys
    INNER JOIN dbo.v_Add_Remove_Programs AS arp ON sys.ResourceID = arp.ResourceID
    INNER JOIN dbo.v_FullCollectionMembership AS fcm ON sys.ResourceID = fcm.ResourceID
    Left Outer JOIN dbo.v_R_User U ON sys.User_Name0 = U.User_Name0
WHERE 
    arp.DisplayName0 like @displayname
    AND fcm.CollectionID = @CollID

Digg This

Leave a Reply

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