moving nodes to new polling engine

andrewh

I need to move all the nodes from one polling engine to a new polling engine.

Moving the nodes can easily be done through manage nodes however there is no check to see if the new polling engine is receiving any response from the nodes.

Some nodes will probably need configuration changes to respond to the new polling engine.

Is there a report that can be run to display all nodes that are not responding to polling?

Or is there another way to move a large number of nodes that will report on any that fail to respond to the new polling engine?

mesverrum

This is the custom query I use for that scenario, shows devices that are pinging as up but snmp/wmi/agent have stopped working for at least 20 minutes.

select  

n.caption as [Node] 

,n.detailsurl as [_linkfor_Node] 

,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node] 

,n.ip_address as [IP Address] 

,n.detailsurl as [_linkfor_IP Address] 

,n.statusdescription as [Status Description] 

,n.objectsubtype as [Collection Type] 

,e.servername 

,n.statcollection as [Interval] 

,case when n.objectsubtype !='SNMP' then 'Not Used' 

when n.community='' then 'Not Used' 

else n.community 

end as [SNMPv2 Community] 

,case when c.Name is null then 'Not Used' 

else c.Name  

end AS [WMI/SNMPv3 Credential] 

,tolocal(n.lastsystemuptimepollutc) as [Last Stat Collection] 

,tolocal(n.lastsync) as [Last Ping] 

,daydiff(lastsystemuptimepollUTC,getutcdate()) as [Days Since Polled] 

,'Edit' AS [Edit] 

, '/Orion/Nodes/NodeProperties.aspx?Nodes=' + ToString(n.NodeID) AS [_LinkFor_Edit] 

,'/Orion/images/nodemgmt_art/icons/icon_edit.gif' as [_IconFor_Edit]   

 

from orion.nodes n 

left JOIN Orion.NodeSettings ns ON n.NodeID = ns.NodeID and SettingName like '%Credential%'     

left JOIN Orion.Credential c ON ns.SettingValue = c.ID     

join Orion.Engines e on e.engineid=n.engineid 

where status<>'2' 

and status<>'9' 

and objectsubtype!='ICMP' 

and minutediff(lastsystemuptimepollUTC,getutcdate())>20 

--and ([Node] like '%${SEARCH_STRING}%' or [IP Address] like '%${SEARCH_STRING}%') 

 

Order by Lastsystemuptimepollutc