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 Thursday, October 09, 2008 7:55 AM by Garth
Filed under: , , ,

Comments

No Comments