Simple ARP report

SELECT
ARP.DisplayName0,
ARP.ProdID0,
ARP.Publisher0,
ARP.Version0,
Count(ARP.ProdID0) AS ‘Count’
FROM
dbo.v_Add_Remove_Programs ARP
GROUP BY
ARP.DisplayName0,
ARP.ProdID0,
ARP.Publisher0,
ARP.Version0
ORDER BY
ARP.DisplayName0

Leave a Reply

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