List PCs with particular ARP

Select
    CS.Name0,
    ARP.DisplayName0
From
    dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_Add_Remove_Programs ARP on CS.REsourceID = ARP.ResourceID
Where
    ARP.DisplayName0 in (‘Microsoft SQL Server 2005 Tools’, ‘Virtual Machine Additions’,’Windows Resource Kit Tools’)

Leave a Reply

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