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
This is a quick one, it's been forever since I've posted here. After moving back…
Simple command turned crazy. I ended up coming up with this due to the fact…
Phew, this one took a minute to figure out. ConnectWise has a form based documents…
I've found myself at a new job, recreating many of the processes that I spent…
Wow, it's been a while since I've done a real post on this site. I've…
When using AutoTask's API it's required to lookup a various amount of picklist values that…
