This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

EOC - Site Status (swql)

Just a quick widget to get the status of a site (other NPMs)  from EOC.

cscoengineer_0-1583167053393.png

SELECT
concat('<img src="/orion/images/statusicons/Small-',si.StatusName,'.gif"></>',
'<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

Thank you
Amit

email: ashah@loop1.com

Loop1 Systems - SolarWinds Training and Professional Services