More discussions in Orion Network Configuration ManagerWhere is this place located?
1 Reply Latest reply: Feb 22, 2012 9:25 AM by rcahill RSS

network inventory report including serial numbers

Simmons4102
Simmons4102 Feb 21, 2012 9:28 AM
Currently Being Moderated

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. 

  • 185 Views
  • Re: network inventory report including serial numbers
    rcahill
    rcahill Feb 22, 2012 9:25 AM (in response to Simmons4102)
    Currently Being Moderated

    Re: NCM - Device Inventory - lack there of

     

     

    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>

     

Actions

More Like This

  • Retrieving data ...