SMSUG.ca

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

Garth Jones

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')

Published Jan 21 2009, 09:09 AM by Garth
Filed under: , , ,

Comments

No Comments

This Blog

Syndication

News

Training

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