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)
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)
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.
