WinZip count with version

17 years ago

SELECT ProductName0 AS Product, VersionMajor0 AS Version, COUNT(*) AS Count FROM dbo.v_GS_INSTALLED_SOFTWARE GROUP BY ProductName0, VersionMajor0 HAVING (ProductName0 = 'winzip')

VMware / MS VM / Real / Total Count

17 years ago

Garth writes some very useful SMS web reports so I copy them here sometimes: http://smsug.ca/blogs/garth_jones/archive/2007/08/01/528.aspx (more…)

SMS Site Status

17 years ago

This is a "dashboard" report that shows the current SMS site status. (more…)

# of updates per month

17 years ago

This report shows you the number of updates that were released each month for each product. (more…)

Site

17 years ago

Well, I lost everything on the site, so here we go with creating a new one. Hopefully I can start…