1 of 1 people found this helpful
For Cisco devices, first create a new Universal Device Poller and poll OID 18.104.22.168.22.214.171.124.126.96.36.199
Use the column entPhysicalDescr for the label.
For the actual report, here is what I use (this could use some cleaning up, but it works).
INNER JOIN [CustomPollerAssignment] ON
INNER JOIN [CustomPollers] ON
[CustomPollers].UniqueName LIKE '%entPhysicalSerialNum%')
INNER JOIN [CustomPollerLabels] ON
([CustomPollerStatus].RowID = CustomPollerLabels.RowID AND
[CustomPollerStatus].CustomPollerAssignmentID = CustomPollerLabels.CustomPollerAssignmentID)
INNER JOIN [Nodes] ON
(CustomPollerAssignment.NodeID = Nodes.NodeID)
WHERE CustomPollerStatus.Status IS NOT NULL AND
CustomPollerStatus.Status <> ''
How does on create this Universal Device Poller and where do I create the report? I am getting more and more acclimated to Solar Winds but I am not that proficient.
I followed your steps and I got a blank report. Help.
There is already a report built into Orion but only for the 3750s. Go to the reports and search for "Cisco3750 Stack - Physical Entity." I'm not sure about the Juniper devices, but I also have query set up to display all members of a node, their serial number, and IOS version on the Node summary page. If you are interested in that I can post the query that I have set up.
2 of 2 people found this helpful
Ive used this in a report which gives me the entity - the key being the class (3) for the serial numbers
This should give you the report.
SELECT OrionNodes.Caption, OrionNodes.DetailsUrl, OrionNodes.Status, OrionNodes.ChildStatus, NcmEntityPhysical.EntityName, OrionNodes.IP_Address, NcmEntityPhysical.EntityDescription, NcmEntityPhysical.Serial, NcmEntityPhysical.Manufacturer, NcmEntityPhysical.Model, NcmNodeProperties.NodeComments, OrionNodes.SysName, OrionNodes.NodeDescription, OrionNodes.Location, OrionNodes.Contact, OrionNodes.MachineType, OrionNodes.LastBoot, OrionNodes.IOSVersion
FROM NCM.NodeProperties AS NcmNodeProperties
INNER JOIN Orion.Nodes AS OrionNodes ON NcmNodeProperties.CoreNodeID=OrionNodes.NodeID
LEFT JOIN NCM.EntityPhysical AS NcmEntityPhysical ON NcmEntityPhysical.NodeID=NcmNodeProperties.NodeID AND NcmEntityPhysical.EntityClass=3
you can really use the same in a node as well if you wanted to
I followed the above steps and I received an error for invalid object name: "NCM.NodeProperties". I also tried the web report writer, I cannot find the field for "class".
Do you have NCM ?
Thats a bit odd as the SQL I used above doesnt have NCM.NodeProperties they have (NcmNodeProperties)
I am able to create a report for all our Cisco ASA devices via web report with Tech Support's help. Thank you, lynchnigel!!
Quick dummy question -- this logic seems to work well, but it only lists nodes "managed by NCM" and not nodes for which the same info (status, hardware etc.) that is derived from SNMP discovery exists but which are not configuration managed through NCM, Is that stored in a different table somewhere, or does it have to do with the entity class? I've had no luck finding documentation explaining the values or available fields.
If you have a look for the SDK for Orion - there are schema's and there's also SWQL studio which will help with creating and testing. They will be in another table I believe
You are very welcome