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

Published Thursday, September 25, 2008 11:06 AM by Garth
Filed under: , , ,

Comments

No Comments