When using sites codes or addresses, it's nice to know which other nodes are at the site.
For example, looking at the site in New Haven, CT - which other nodes are there and what are their statuses?
select
caption AS [Nodes]
,DetailsUrl AS [_LinkFor_Nodes]
,'/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Nodes]
,machinetype as [Device Type]
from orion.nodes where nodes.customproperties.address='${address}'
order by caption
Thank you
Amit
email: ashah@loop1.com
Loop1 Systems - SolarWinds Training and Professional Services
