I am trying to figure out how to create a report that will summarize the interface status on my switches.
Ideally it would have the Node Name, IP Address and counts of interfaces UP, DOWN, SHUTDOWN and UNMANAGED. Also possibly any Custom Interface properties set.
I can sorta get some numbers but they don't seem to be correct when I look at the actual switch and don't include all the different status options, just UP and sometimes DOWN.
What I have tried so far is
Field: Source_Name sort * function *
Field: Source_IP_Address sort * function *
Field: IfName sort * funtion Count
Also tried a number of different fields instead of IfName without success.
I suspect I may need some custom SQL.
Anyone done this or have any ideas?