1 of 1 people found this helpful
I don't know of a way to search on the console. Someone else may know. But you could run a quick report using report writer. If you are looking for one SN, then you can filter for that Service Tag.
Or you could also run a query like this.
SELECT HardwareName, ServiceTag from APM_HardwareAlertData
WHERE ServiceTag = 'SerialNumber'
Hope this helps.
I was able to do query from the database server, and be able to find the machine type, manufacture and nodeid. From nodeid, I can find the actuall sysname which tells me the location of the equipment from another table. I am not a query expert, and what will be the best way to look up other fields in multiple tables? Thank you for the help.
If this is something you would use frequently, you could have a script that would copy the SN to an unused field (ie: Comments, City or Department). Then search this field using NPM web interface.
I would love to know how to do that. Because we can have other fields, such as property number or asset number added which we use to track our equipments.
If you already have asset numbers & an inventory system (that has the Serial Number attached to the Asset Number), here's what I would do:
Create a custom property field in NPM (Settings | Manage custom properties (in the Node & Group Management section).
Populate each node with the corresponding Asset Number (either while creating the the field, using the wizard, or by manually editing each node).
Once this is done, from NPM main page, you will be able to search for a node based on the Asset Number you have.
When I query my db, the Hardware service tag is provided only for the Cisco Gear, but not the rest. If you cant update manually, there a possibility to poll data from SNMP, and then put it in a record... It depends on your knowledge and the size of your environment.
I uploaded In a few minutes, I will upload in content exchange a basic report that will give you a view of all service tags seen by NPM.
If you consider this question closed, please mark it as answered. If not, do not hesitate to elaborate so we can help you better