cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

Is there a way to uncheck Interface Error Statistics on a lot of interfaces quickly?

Jump to solution

chrisputer_0-1583865204165.png

Basically, any interface that has the x3 and x4 name, I need to uncheck the error statistics. But there are hundreds of them to do. They're all part of an ERPS ring and the blocking interface is discarding the traffic and generating high error numbers. According to our hardware vendor, there is no want to not have this be reported in the OID/MIB.

0 Kudos
1 Solution

An SQL query would probably be easiest.   Something like:

SELECT P.PollerID, P.PollerType, P.NetObjectID, I.InterfaceName, Enabled
FROM Pollers P
JOIN Interfaces I ON (P.NetObjectID = I.InterfaceID)
WHERE ((I.InterfaceName = 'x3') OR (I.InterfaceName = 'x4')) AND (P.PollerType = 'I.StatisticsErrors32.SNMP.IfTable')

Should find all the pollers, do this in the Database Manager on the server or SQL Studio.

Change this to an Update query and set 'Enabled' to 0, or you could potentially even delete these lines in the database.  An 'Update' is probably safer.

Alternatively, in the database manager, you could click on "Enable table editing" and check off all the "Enabled" boxes so they are no longer checked.   A bit more manual, but safer if your unsure about updating or deleting the table...

View solution in original post

3 Replies

An SQL query would probably be easiest.   Something like:

SELECT P.PollerID, P.PollerType, P.NetObjectID, I.InterfaceName, Enabled
FROM Pollers P
JOIN Interfaces I ON (P.NetObjectID = I.InterfaceID)
WHERE ((I.InterfaceName = 'x3') OR (I.InterfaceName = 'x4')) AND (P.PollerType = 'I.StatisticsErrors32.SNMP.IfTable')

Should find all the pollers, do this in the Database Manager on the server or SQL Studio.

Change this to an Update query and set 'Enabled' to 0, or you could potentially even delete these lines in the database.  An 'Update' is probably safer.

Alternatively, in the database manager, you could click on "Enable table editing" and check off all the "Enabled" boxes so they are no longer checked.   A bit more manual, but safer if your unsure about updating or deleting the table...

View solution in original post

While I started to become hesitant in deleting stuff directly from the database and rather utilize the SDK for such tasks, I agree with @cnorborg that removing Pollers directly from the DB is OK.
If you want to go down the rabbit hole: https://github.com/solarwinds/OrionSDK

0 Kudos

Wow, that was a fast reply. Thank you! Learning so much about NPM from you guys!

0 Kudos