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

Hardware Service Tags.OrionReport

This basic report will give you all hardware service tags (serial numbers) associated with nodes.

Ideal to verify your inventory.

New version adds Cisco PID, required to order Licences (ver 15.0 & up)

Labels (1)
Attachments
Comments


hello!  I just imported this and it does not snag the SN nor the Juniper device.  Is this just for Cisco?

It worked on Cisco as this is polled directly in Solarwinds. That being said, I found here on thwack () the receipe to poll Juniper SN. You will have to create a UnDP to populate the data, and then, create a report based on that information.

Since I don't have any Juniper gear anymore, I can't really do that and test it here in my lab.


Hope this helps!

It's a great report. But it wont show 1700 series Router nor Firewall.

Have you tried on a 1700 with the latest (or at least recent) ios?

Yes and still not showing. Unless you try with any specific IOS Version. If so please let me know.

thanks

The report shows Cisco Switches and Routers. It does not show Cisco ASAs and WAPs. It would be because the SQL is joining 2 tables and one is missing all the Cisco ASAs and WAPs.

--Report that builds default “Current – Hardware Status”

-- (346 row(s) affected)

SELECT Nodes.Caption AS NodeName,

       Nodes.IP_Address AS IP_Address,

       Nodes.MachineType AS Machine_Type,

       Nodes.Vendor AS Vendor,

       APM_HardwareAlertData.ServiceTag AS Hardware_Service_Tag,

       APM_HardwareAlertData.Model AS Hardware_Model

FROM Nodes

INNER JOIN APM_HardwareAlertData

ON (Nodes.NodeID = APM_HardwareAlertData.NodeId)

ORDER BY 1 ASC, 2 ASC, 3 ASC, 4 ASC, 5 ASC, 6 ASC --" TopX="All" TopXCount="10" TopXPercent="10" Orientation="Landscape" CookedData="TRUE" Web="TRUE" GroupByDays="TRUE"

--This pulls all my devices in NPM including Cisco ASAs and WAPs

-- (488 row(s) affected)

SELECT Nodes.Caption AS NodeName,

Nodes.IP_Address AS IP_Address,

Nodes.MachineType AS Machine_Type,

Nodes.Vendor AS Vendor

FROM NODES

WHERE VENDOR = 'Cisco'

ORDER BY 1 ASC

--The APM_HardwareAlertData table does not have Cisco ASAs or WAPs

--(330 row(s) affected)

SELECT * FROM APM_HardwareAlertData

WHERE Manufacturer = 'Cisco'

I like your reply - but can you tell me how would you create a report that will show you the serialnumbers for both routers and firewall (and other device for that matter)

How can this be done and what approches must be made

I do not have an option to attach the poller and reports I ran. The advanced editor is not available to reply to this post.

Version history
Revision #:
1 of 1
Last update:
‎03-13-2013 02:41 PM
Updated by: