SELECT ProductName0 AS Product, VersionMajor0 AS Version, COUNT(*) AS Count
FROM dbo.v_GS_INSTALLED_SOFTWARE
GROUP BY ProductName0, VersionMajor0
HAVING (ProductName0 = 'winzip')
TechColumnist
Directives from a Director
I’ll try to put this to good use immedeiatly.
July 2, 2011 at 2:37 am