Hello,
I was wondering if there is a way to create a custom report that will tell me what nodes are not in the worldwide map? Would it be possible if this could be done without having to do an Advanced Database Query?
Unfortunately the Web based report builder UI doesn't seem to have been updated very well to reflect the data on the worldmap tables.
I wrote up a SWQL query that does find what you wanted though, the key is to left join it to the worldmap.point table and look for null entries
select n.caption as [Node]
,n.detailsurl as [_linkfor_Node]
,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node], IP_Address, Vendor, MachineType
FROM Orion.Nodes n
left join Orion.WorldMap.Point wm on wm.InstanceID=n.nodeid and wm.instance='Orion.Nodes'
Where wm.latitude is null
-Marc Netterfield
Loop1 Systems: SolarWinds Training and Professional Services
Thank you for the SWQL query, this query worked for me. Appreciate the help.
