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%’

Leave a Reply

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