Hi,
I am trying to utilize a custom chart which will plot the count of connected interfaces on a few Cisco Nodes. So far I have:
1. Created a custom job which updates both the Interfaces and Entity MIB for the nodes I am interested in, which updates Monday-Fri hourly between 9AM-4PM
2. Created this custom SWQL which seems to accurately reflect the port counts:
select
n.NodeName,
COUNT (CASE i.OperStatus WHEN 'Up' THEN 1 else NULL end) as [Interfaces Up],
COUNT (CASE i.OperStatus WHEN 'Down' then 2 else NULL end) as [Interfaces Down],
tolocal(n.LastSync) as [Last Sync]
from orion.nodes n
LEFT JOIN ncm.interfaces i on i.Node.CoreNodeID = n.NodeID
where n.nodename like '%NODE_NAME_TO_SELECT%'
and i.InterfaceName not like 'Stack%'
and i.interfacename not like 'Nu0'
and i.interfacename not like 'Vl%'
and i.interfacename not like 'Gi0/0'
and i.interfacename not like 'Lo%'
GROUP BY n.nodename, n.LastSync
3. Created a custom chart using the above SWQL which has a sample interval of 30 minutes and a report scheduler for Monday-Fri hourly between 9:30AM-4:30PM
I see that that an initial dot is graphed, but it doesn't seem to update after that.
Would anyone have any advice, or suggestions?
Thanks!
