Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

network inventory report including serial numbers

I need to create a report of all of the devices in NCM that includes the serial number. We have a mixture of Cisco, Juniper, Riverbed, and BlueCoat Packeteers in our environment.

I've tried the Physical Entity report and the only serial numbers from Cisco access points are being returned.

We are running NCM v6.1.

Thanks in Advance for your help.

Find more posts tagged with

Accepted answers

All comments

rcahill

However,

You maybe able to get more information with a report I cludged together a while ago

<Report Version="2.0" ReportType="" Schema="D:\Program Files\SolarWinds\Configuration\Schemas\Node_Details.Schema" Category="Inventory" Title="Physical Entities with Class 3 only - REC modification" SubTitle="" Description="Display information about Physical Entities within each device" Footer="" Grouping="" FieldList="NODES.NodeCaption,ENTITY_PHYSICAL.Name,NODES.AgentIP,ENTITY_PHYSICAL.Description,ENTITY_PHYSICAL.Class,ENTITY_PHYSICAL.Position,ENTITY_PHYSICAL.HardwareRevision,ENTITY_PHYSICAL.FirmwareRevision,ENTITY_PHYSICAL.SoftwareRevision,ENTITY_PHYSICAL.Serial,ENTITY_PHYSICAL.Manufacturer,ENTITY_PHYSICAL.Model,ENTITY_PHYSICAL.Alias,ENTITY_PHYSICAL.AssetID" DisplayStatus="FALSE" IncludeConfigs="FALSE" IncludeUnManaged="FALSE" MergeLikeRows="FALSE" Lines="Horizontal" SQL="SELECT Nodes.*,[ENTITY_PHYSICAL].[Name],[ENTITY_PHYSICAL].[Description],[ENTITY_PHYSICAL].[Class],[ENTITY_PHYSICAL].[Position],[ENTITY_PHYSICAL].[HardwareRevision],[ENTITY_PHYSICAL].[FirmwareRevision],[ENTITY_PHYSICAL].[SoftwareRevision],[ENTITY_PHYSICAL].[Serial],[ENTITY_PHYSICAL].[Manufacturer],[ENTITY_PHYSICAL].[Model],[ENTITY_PHYSICAL].[Alias],[ENTITY_PHYSICAL].[AssetID]

FROM Entity_Physical RIGHT JOIN Nodes ON Entity_Physical.NodeID = Nodes.NodeID and [ENTITY_PHYSICAL].[Class]=3

ORDER BY [NODES].[NodeCaption],[ENTITY_PHYSICAL].[Name],[NODES].[AgentIP]" SelectClause="SELECT Nodes.*,[ENTITY_PHYSICAL].[Name],[ENTITY_PHYSICAL].[Description],[ENTITY_PHYSICAL].[Class],[ENTITY_PHYSICAL].[Position],[ENTITY_PHYSICAL].[HardwareRevision],[ENTITY_PHYSICAL].[FirmwareRevision],[ENTITY_PHYSICAL].[SoftwareRevision],[ENTITY_PHYSICAL].[Serial],[ENTITY_PHYSICAL].[Manufacturer],[ENTITY_PHYSICAL].[Model],[ENTITY_PHYSICAL].[Alias],[ENTITY_PHYSICAL].[AssetID]" FromClause="FROM Entity_Physical RIGHT JOIN Nodes ON Entity_Physical.NodeID = Nodes.NodeID and [ENTITY_PHYSICAL].[Class]=3" WhereClause="" OrderByClause="ORDER BY [NODES].[NodeCaption],[ENTITY_PHYSICAL].[Name],[NODES].[AgentIP]" TopX="All" TopXCount="10" TopXPercent="10" Orientation="Landscape"><FieldSelection></FieldSelection><CriteriaSelection><QUERY><KIND>1</KIND><COMPLEX><TAG></TAG><CONNECTIVE>1</CONNECTIVE><CHECKED>1</CHECKED></COMPLEX></QUERY>

</CriteriaSelection></Report>