Need SQL script to disable interface statistics collection

markgosling

Firstly let me declare I know zilch about SQL scripting. I've had a look through the forums at various examples but cannot make any progress. Looking for assistance from the community (surely I'm not the only person with this requirement)

I need a script that can be used to bulk disable the collection of switch port interface statistics. Yes I can use the List Resources & No Interface Statistics option but this is very time consumming and prone to error as I have over 650 switch stacks. I want to monitor the status of all ports so I can keep an eye on my edge port capacity and I also wish to map the attached end devices via UDT.

Any assitance/guidance greatly appreciated

LadaVarga

Hello,

Can be done via SQL script UPDATE against Pollers table.

What do you need:

Interface ID

Disable interface statistics poller where interfaceid=406.

UPDATE pollers SET Enabled=0 where netobject='I:406' and pollertype like '%statistics%'

Enable interface statistics poller where interfaceid=406.

UPDATE pollers SET Enabled=1 where netobject='I:406' and pollertype like '%statistics%'

Is that enough for you?

Lada