Populating interface speeds from custom poller.

Hi Tom,

If you need to populate this only once, (or run by hand)..

Just backup your database before trying :-)

1) Set interface's CustomBandwidth to '1' (can be done in 'Edit Interface' page). If you don't do this, the Bandwidth will be overwritten with every poll.

2)

UPDATE Interfaces set

InBandwidth = cps.Status

from CustomPollerStatus cps

INNER JOIN CustomPollerAssignment cpa ON cpa.CustomPollerAssignmentID = cps.CustomPollerAssignmentID

INNER JOIN CustomPollers cp ON cp.CustomPollerID = cpa.CustomPollerID

WHERE UniqueName='ADSLReceiveRate' AND cpa.InterfaceID = Interfaces.InterfaceID AND Interfaces.CustomBandwidth = 1

should set ADSLReceiveRate -> InBandwidth.

Great,

  I feel that i am getting close. but it seems that there is no interfaceID in the CustompollerAssignment. they are all listed as 0. Have i set up my customer poller incorrectly?

Regards

Tom

update interfaces set

InBandwidth = cps.status

from CustomPollerStatus cps

INNER JOIN CustomPollerAssignment cpa ON cpa.CustomPollerAssignmentID = cps.CustomPollerAssignmentID

inner JOIN CustomPollers cp ON cp.CustomPollerID = cpa.CustomPollerID

inner join Nodes on cpa.NodeID = nodes.NodeID

inner join Interfaces on interfaces.NodeID = nodes.nodeid and interfaces.InterfaceType = 94

WHERE UniqueName='ADSLReceiveRate' and interfaces.InterfaceID=174

I have been using the above to test, i am not going to push it out yet.

Hi All,

Did you find a way to automate this?  I have 500+ adsl routers to modify :-(

Mark