Cisco SG350 Switches and Custom Pollers

tporritt

We have several of these switches in our environment and the default poller does not pull back the serial number (though it gets most of the other values).

I am assuming a custom poller is in order to be able to query the other values (such as Serial Number).

I have been able to find the correct OID (1.3.6.1.4.1.9.6.1.101.53) using SNMPwalk

I can find the serial number down at OID 1.3.6.1.4.1.9.6.1.101.53.14.1.5

I go through the process (Manage Pollers, New Poller)

When I get to the Specify Data Source I end up getting a table of values with only the first row filled.

In the case of Vendor, I navigate to the OID and select it

 

 

It tells me there are multiple rows and that I need a condition:

Tried to do SubString

SubString([rlPhdUnitGenParamTable.rlPhdUnitGenParamManufacturer],0,5)

 

Tried to do IndexOf

IndexOf([rlPhdUnitGenParamTable.rlPhdUnitGenParamManufacturer],0)

 

It doesn’t seem to accept either option, Substring seems to get the closest but thinks it still has 5 rows.

I went through the Custom Poller on-demand class and this result wasn't covered, every one of their custom poller examples worked without effort.

Martin_A

We had the same problem, and for OID:s that has tabular data I think you have to create a Universal Device Poller (UnDP).
How to Create a Universal Device Poller (UnDP) in NPM (solarwinds.com)

In SWQL I then have extracted the serial numbers and NodeID's like this:

SELECT ParentObjectID AS NodeID, ServiceTag AS status
FROM Orion.HardwareHealth.HardwareInfoBase
UNION
(SELECT  DISTINCT nodeid, status
FROM Orion.NPM.CustomPollerStatusOnNode
WHERE status <> '')

The first Select is extracting serial numbers for brands like Cisco, Dell, HP and so on (that is SW read them by default).
The second Select extracts the serial number collected via the Universal Device Poller we created to collect serial numbers from our "small brand" switches.

Here is an example using the above to get some basic node data like Caption, Location, Serial number, MachineType and Vendor:

SELECT N.NodeID, N.Caption, N.Location, Table2.Status, N.MachineType, N.Vendor
FROM Orion.Nodes N

LEFT JOIN
(
SELECT ParentObjectID AS NodeID, ServiceTag AS status
FROM Orion.HardwareHealth.HardwareInfoBase
UNION
(SELECT  DISTINCT nodeid, status
FROM Orion.NPM.CustomPollerStatusOnNode
WHERE status <> '')
) AS Table2
ON N.NodeID = Table2.NodeID

To check if your Universal Device Poller is active on a specific node, you can (in Node Details) click on Pollers and check if your poller is selected:

In our dashboard, I have created a view that shows switches that does not have the poller set, using the following SWQL as data source:

SELECT N.Caption, N.NodeID, N.vendor, N.DetailsUrl AS [_LinkFor_Cation], N.ChildStatus, N.Status
FROM Orion.Nodes N
WHERE (N.Vendor LIKE '%YOUR_VENDOR_HERE%') AND N.NodeID NOT IN
(SELECT DISTINCT nodeid
FROM Orion.NPM.CustomPollerStatusOnNode
WHERE status <> '')

Btw, we use OID 1.3.6.1.2.1.47.1.1.1.1.11 to collect the serial numbers of our switches.
You can read about it here:
OID 1.3.6.1.2.1.47.1.1.1.1.11 entPhysicalSerialNum reference info (oidref.com)

Hope it helps,

Kind regards,
//Martin