SMSUG.ca

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

Garth Jones

List ARP by PCs with name like

SELECT
ARP.ProdID0,
ARP.DisplayName0,
ARP.Version0,
CS.Name0
FROM
dbo.v_Add_Remove_Programs ARP,
dbo.v_GS_COMPUTER_SYSTEM CS
WHERE
ARP.ResourceID = CS.ResourceID
AND CS.Name0 Like 'AB%'

Published Oct 09 2008, 07:55 AM by Garth
Filed under: , , ,

Comments

No Comments

This Blog

Syndication

News

Training

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