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

Serial Number Lookup

Serial Number Lookup

The ability to type in a serial number and have it return the node that it belongs to.

Very helpful to management when they do audits and maintenance contracts.

Tags (1)
25 Comments

I've had to create custom query for this but would prefer a better search resource like the one ipam uses.

Level 16

Would you feel comfortable uploading the query?  I am pathetic at SQL and I'm sure many more are that use Orion so it would help us tremendously!

Level 20

Isn't this dependent on whether serials can be read with snmp.  I know even with Cisco devices this isn't 100% consistent... I suppose that's no reason not to try.  I have reports that list them for Dell Servers and Cisco devices but I don't get them for all.  Also some of my Cisco devices have 40 serial numbers if you consider all the modules.  I assume you guys are saying the chassis serial number... which for some Cisco devices is almost debatable.

Level 16

My thought was the chassis serial number.  My management has a nightmare of a time every year when maintenance contracts come due.  Finding what was replaced and what changed is hard but if he can lookup a sn# and know its online, that would help tremendously.

And thats just the main reason... 

I'm really glad you asked - just looked and found out it was written on our 10.7 beta site which literally *just* got blown away. I would have forgotten completely. Let's see if it's still fresh enough to remember and rewrite...

I would remove the columns (from both) that you don't need or plan for this to be a full page width audit. One limitation of Custom SQL resource is no export so let me know if you need the SQL for a report version so you can add &dataformat=xls for your end of year node audits?


Custom SWQL Query:

SELECT n.caption as Node, '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(n.nodeid) AS [_LinkFor_Node], '/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Node], h.ServiceTag, n.customproperties.assettag, n.vendor, n.machinetype, h.manufacturer, h.model, n.location, n.contact

FROM Orion.HardwareHealth.HardwareInfo h

left join orion.nodes n on h.nodeid=n.nodeid

Search SWQL Query:

SELECT n.caption as Node, '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(n.nodeid) AS [_LinkFor_Node], '/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Node], ServiceTag, n.customproperties.assettag, n.vendor, n.machinetype, h.manufacturer, h.model, n.location, n.contact

FROM Orion.HardwareHealth.HardwareInfo h

left join orion.nodes n on h.nodeid=n.nodeid

where n.caption like '%${SEARCH_STRING}%' or

h.ServiceTag like '%${SEARCH_STRING}%' or

n.customproperties.assettag like '%${SEARCH_STRING}%' or

n.vendor like '%${SEARCH_STRING}%' or

n.machinetype like '%${SEARCH_STRING}%' or

h.manufacturer like '%${SEARCH_STRING}%' or

n.location like '%${SEARCH_STRING}%' or

n.contact like '%${SEARCH_STRING}%'

;

This is based on the Hardware Health being polled - I have some Cisco 4948's which don't report due to an IOS error - in that case add a node custom property for serial number and add that to the above script (like my assettag) then you can manually enter them all for tracking...

Level 20

Exactly some just don't give up their real serial that on the actual device and do give something else even.

Check that the SysObjectID listed is correct for that node and then report to SW as a possible bug or request.

Level 16

SWEET!!!  thanks!