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.

Help to create the Community string failed report?

er.vansh17091 over 5 years ago

Hi, As I checked, community string test being failed for few nodes but Node's Icon is in green state (UP state). Help to create the Community string failed report.

Top Replies

mesverrum over 5 years ago +3

So there isn't a metric that diectly says "community failed" anywhere, which is why people have built lots of reports of the years on indirect indicators that the polling isn't working. The way I do it…

0 mesverrum over 5 years ago

So there isn't a metric that diectly says "community failed" anywhere, which is why people have built lots of reports of the years on indirect indicators that the polling isn't working.
The way I do it these days is this SWQL report

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 hourdiff(lastsystemuptimepollUTC,getutcdate())>1
--and ([Node] like '%${SEARCH_STRING}%' or [IP Address] like '%${SEARCH_STRING}%')
Order by Lastsystemuptimepollutc
Cancel
Vote Up +3 Vote Down

Cancel
0 er.vansh17091 over 5 years ago in reply to mesverrum

Hi Mesverrum,
Great, exactly I was looking the the same. Thanks a lot!
Can we add vendor name as well in this report?
Cancel
Vote Up 0 Vote Down

Cancel
0 mesverrum over 5 years ago in reply to er.vansh17091

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.Vendor
,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 hourdiff(lastsystemuptimepollUTC,getutcdate())>1
--and ([Node] like '%${SEARCH_STRING}%' or [IP Address] like '%${SEARCH_STRING}%')
Order by Lastsystemuptimepollutc
Cancel
Vote Up 0 Vote Down

Cancel