CRC Errors, duplex and speed mismatches - SQL

Version 1

    [As linked to] Cisco speed/duplex counters (For SQL report).

    This report uses custom universal device pollers for Duplex and CRC counters, both indicative of duplex and/or speed mismatches.  This requires the universal device poller linked above.

    Queries custom poller for dot3StatsDuplexStatus (Based on OID, so the name of the poller doesn't matter, just add it somewhere)

    Pulls the Node interface name, duplex status, speed, in/out errors, and the average bps for the last hour.  This query will only take on operationally up nodes.

     

    This is just a SQL report, but if you want to download the orion report feel free.