software not installed

Select Distinct
    sys.Netbios_Name0,
    sys.User_Domain0,
    sys.User_Name0
FROM
    v_R_System sys
    JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
WHERE
    sys.ResourceID not in (select sys.ResourceID
                            from
                                v_R_System sys
                                JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
                            where
                                DisplayName0 =  @displayname)

Leave a Reply

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