Just a quick widget to get the status of a site (other NPMs) from EOC.
'<a href="',Website,'">',s.name,'</>') as [Site]
--,s.Enabled as [Enabled]
,case when s.enabled=1 then '<img src="/Orion/images/StatusIcons/Small-Up.gif"></>Enabled'
else '<img src="/Orion/images/StatusIcons/Small-Down.gif"></>Not Enabled' end as [Enabled]
,s.StatusDescription as [Site Description]
--TOP 1000 EocSiteID, SiteID, Name, Host, Website, Status, StatusDescription, Enabled, DisplayName, Description, InstanceType, Uri, InstanceSiteId
FROM Orion.EOC.Sites s
join orion.StatusInfo si on si.StatusId=s.Status
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.