How to identify whether any node is polling with SNMP or ICMP and how to get the list of devices which are snmp connection lost only.

Shanmuga,

You've received some awesome advice and all you need to do now is cherry pick the items that work best for you.  If I may, I would like to add one more option for you, make a modern dashboard of what works best for you.  Here's a SWQL script I have for a simple modern dashboard view that shows me if nodes are ICMP managed, or SNMP managed.  The detailsurl takes me to the node details page or for a more direct link I added an edit button.  

We're currently in the process of creating a PowerShell script that'll change node availability from agent based > ICMP based centered around the node naming standard and by a custom properties value.  Then we have PowerShell script that'll change SNMP availability > ICMP availability based on the same criteria. I can share this PowerShell script once it's ready to be shared.

.

SELECT n.Caption 
,n.ObjectSubType
, n.detailsurl 
, n.ip_address 
, n.Community 
, 'Edit' as [Edit]
, '/Orion/Nodes/NodeProperties.aspx?Nodes=' + ToString(n.NodeID) as [NodeProperties]
, '/Orion/images/nodemgmt_art/icons/icon_edit.gif' as [Icon]

FROM Orion.Nodes n

WHERE n.objectsubtype IN ('ICMP', 'SNMP')

Shanmuga,

You've received some awesome advice and all you need to do now is cherry pick the items that work best for you.  If I may, I would like to add one more option for you, make a modern dashboard of what works best for you.  Here's a SWQL script I have for a simple modern dashboard view that shows me if nodes are ICMP managed, or SNMP managed.  The detailsurl takes me to the node details page or for a more direct link I added an edit button.  

We're currently in the process of creating a PowerShell script that'll change node availability from agent based > ICMP based centered around the node naming standard and by a custom properties value.  Then we have PowerShell script that'll change SNMP availability > ICMP availability based on the same criteria. I can share this PowerShell script once it's ready to be shared.

.

SELECT n.Caption 
,n.ObjectSubType
, n.detailsurl 
, n.ip_address 
, n.Community 
, 'Edit' as [Edit]
, '/Orion/Nodes/NodeProperties.aspx?Nodes=' + ToString(n.NodeID) as [NodeProperties]
, '/Orion/images/nodemgmt_art/icons/icon_edit.gif' as [Icon]

FROM Orion.Nodes n

WHERE n.objectsubtype IN ('ICMP', 'SNMP')