SELECT ProductName0 AS Product, VersionMajor0 AS Version, COUNT(*) AS Count
FROM dbo.v_GS_INSTALLED_SOFTWARE
GROUP BY ProductName0, VersionMajor0
HAVING (ProductName0 = 'winzip')
7-mode autotask backup blog bookmark cacti camera cisco cli cluster ConfigMgr connectwise Datacenter dfm dfs fun gx home isy logicmonitor netapp network oncommand ontap opsmgr photos powershell reporting san SCOM script sme sms2003 snapshots soap srm ssd ssh tasks toy uptimedevices vmware vmx vol work
SELECT ProductName0 AS Product, VersionMajor0 AS Version, COUNT(*) AS Count
FROM dbo.v_GS_INSTALLED_SOFTWARE
GROUP BY ProductName0, VersionMajor0
HAVING (ProductName0 = 'winzip')
1 Comment
Aspen
14 years agoI’ll try to put this to good use immedeiatly.