NCM UnUsed Interface Report

ceige

These reports cannot be modified or they will not work. Simply place them in your ncm reports directory.

Updated to include 90 day reports as well.

NCM Un Used Interfaces Reports.zip

Find more posts tagged with

ncm_report

Accepted answers

All comments

jspanitz

Nice listing of unused interfaces and total count reports for last 30 days. To bad NCM doesn't allow you to enter parameters at report runtime. Then the date could be flexible!

jirish

Would it be possible to select a specific device on the network to run this against?

ceige

you could always open the report file and edit the sql to include a specific device in the where clause

wjcmalana

IS there a way to filter to show just the ethernet interfaces?

ceige

@wjcmalana - yea if you just edit the where clause you could specify the interface type

mkomeara

I get an error trying to run these reports under NCM 6.1, with a message saying "Incorrect syntax near the keyword 'GROUP'". I believe the part indicated is here; "where DATEDIFF(day,Interfaces.LastChange,GETDATE()) > 30 and Interfaces.operstatus = 'Down' group by Nodes.SysName,Interfaces.InterfaceDescription". Any ideas?

ceige

So they arent meant to run from the win32 app which is what i assume is giving you the error. And today i was looking into them for someone else and it seems like something changed on the NCM report backend so these no longer work...

del13r

I am very aware of how old these reports are, however when I try to run them with NCM 7.3.2 all i ever get is the following error:

You cannot run inventory reports before running an inventory on your nodes.

Please perform full inventory.

danielk

Please advise how can I execute this Unused NCM port count? I keep getting below error even if I perform full inventory

You cannot run inventory reports before running an inventory on your nodes.

Please perform full inventory.