Tom Lasswell

technology executive leadership

Engineering

SMS Site Status

By · · Updated · 1 min read

Originally published on TechColumnist.

This is a “dashboard” report that shows the current SMS site status.

SELECT TOP (100) PERCENT SiteCode, CASE Status WHEN 0 THEN 'OK' WHEN 1 THEN 'Warning' WHEN 2 THEN 'Critical' ELSE 'False' END AS [Level], Updated FROM dbo.v_SummarizerSiteStatus ORDER BY Status DESC, SiteCode

Keep reading

Engineering

WinZip count with version

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

Aug 6, 2007 · 1 min read