Service Tag for Dell Switches

Not sure about the warranty part, but we get our service tags from the hardware information:

• Create report based on NODES
• Add criteria if needed (my report hasn't got any criteria in this case)
• Add node columns as needed + Service Tag column from Overall Hardware Status as below

Thanks alexslv‌! That was quite helpful. I was able to get this.

Unfortunately, Dell switches have a serial number AND a service tag. When I select service tag as you demonstrated, it retrieves the serial number shown above, which from what we can tell cannot be used to get warranty info. We need the 7 character alphanumeric service tag which is stored elsewhere in the MIB.

ok, I have to confess - I don't have any UnDPs configured in my environment. The logic would be to create report based on SQL. SQL will need to join two tables - CustoPollerStatistic and Nodes and then it would output your UnDP Tag value along with node name. I think it is fairly easy - just give me table names and columns that store your data for Tags and I will help you with SQL

Thanks for the offer alexslv‌. Since we're confessing things, I should confess that I don't know SQL or DBs.

I would like your assistance, but I don't know how to get the info you require.

OK, you were saying above that you have managed to get this info via UnDP already. Where does this info sits? Are you displaying this as a resource on your node page? Can you send screenshot?

The problem is - since I don't have UnDP - I do not know which table those records belong to... Just send screenshot first how do you see this data over UnDP and we will work it out

Here we go!

The info for the UnDP sits on the node details page like this:

As you can see, the service tag info isn't displayed there because that is a table.

So to be able to see that I have to add this resource:

And because there is always something to throw everything outta whack we have this:

That is a few stacked switched we have so it returns the service tags of all the switches in the stack. They are only about 2 or 2 of these, but I wanted to show you in case.

What version of NPM this is?

Try this:

• Create web-based report > custom table
• Selection method: Advanced DataBase Query
• Query Type: SQL
• Paste below > preview result > ADD TO LAYOUT
• Then edit table and add all columns that you want
• NEXT > NEXT > NEXT ...

SELECT   cps.RowID,   cps.Status AS 'Service Tag',   n.MachineType,   n.Vendor,   n.Caption FROM SolarWinds.dbo.CustomPollerStatus cps JOIN SolarWinds.dbo.CustomPollerAssignment cpa ON cpa.CustomPollerAssignmentID = cps.CustomPollerAssignmentID JOIN SolarWinds.dbo.Nodes n ON n.NodeID = cpa.NodeID JOIN SolarWinds.dbo.CustomPollers cp ON cp.CustomPollerID = cpa.CustomPollerID WHERE   cp.UniqueName = 'productIdentificationServiceTag' AND --this is exact name of your custom poller as you have named it when created UnDP   cps.Status IS NOT NULL AND cps.Status <> '' --exclude rows with blank value for service tags

By the way, RowID is actually representing ID of the hardware component within the device itself, that's why it is a TABLE. For example those two records for single device simply means that you have two separate hardware components in there with different (or maybe the same) warranty tag. It would be cool to be able to translate RowID into actual element and this is possible with further UnDP queries and little bit SQLing - but I will eave it for you to try and learn if you wish

Sorry, forgot to mention, change 4 instances above of "SolarWinds.dbo" into "SolarWindsOrion.dbo" or whatever your database is called

Dude!!! You rock!! Thank you! I've got a beer or whatever you drink with your name on it!!

Our database is called NetPerfMon2. Don't know how, but that is the name. Replaced it as you said and BOOM!

I really need to learn some SQL!

Thank you sir!