Solarwinds orion cisco serial number report

Professional Premier Premier Enterprise. Choose what best fits your environment and budget to get the most out of your software. Get priority call queuing and escalation to an advanced team of support specialist. Premier Support Premier Enterprise Support. Database Management. Orange Matter. View Orange Matter. LogicalRead Blog. Read the Blog. Articles, code, and a community of database experts. Documentation for Network Configuration Manager. Choose what best fits your environment and budget to get the most out of your software.

Get priority call queuing and escalation to an advanced team of support specialist. Premier Support Premier Enterprise Support. Database Management.

Your SolarWinds products come with a secret weapon. Orange Matter. View Orange Matter. LogicalRead Blog. Read the Blog. Articles, code, and a community of database experts. Toggle SideBar. Success Center. Select your Preferred Language from the below list.

Publishing Information First Published Date. Last Published Date. Information Title. Article details how to generate a report containing the serial numbers of devices managed by NCM. Environment Select the products and versions this article pertains too. This table should have all identified nodes, and all serial number, one line per each SN, along with other information in other columns.

This will be the table that we use to compare again the Cisco Table. Fewer columns than OrionImport. Delete the [OrionNodesSN] table if it already exists.

If this is your first time running this, skip this line. Create table if not created yet. Some of these fields are fields that will receive data from the Cisco tables, or are custom properties that I have created in my Orion for storing vendor support contract information. There are several points below where you would have to delete or add fields.

If [OrionNodesSN] is empty, it will copy all rows. If [OrionNodesSN] has data in it, it will copy only new nodes. Truncate the table data if you want to start with fresh data.

You may have noticed several types of populating data into tables. Here is a summary of the types:. Convert all node names to uppercase to avoid possible case matching issues between Cisco and Orion.