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.

Interface Count (nodes with no interface monitoring)

Hi All

I've seen some interface count reports on thwack, but I don't believe it's accurate, as they are using joins.  When doing this, it excludes nodes with no interfaces.

This is what I have been using (a very simple query) and it gets me the results for nodes with no interface monitoring.

select n.caption, n.IP_Address [IP_Address], n.vendor [Vendor],

(select count(*) from interfaces i where i.nodeid = n.nodeid) [iCount]

from nodes n

where n.vendor like 'Cisco%'

order by [iCount] asc

pastedImage_3.png

It can always be expended to show the poller, etc.

I use it to aid in interface clean up - such as all Cisco nodes needs to have at least 1 interface monitored.  Any device with more than 50 interfaces needs to be reviewed.

Thanks

Amit

Parents Reply Children
No Data