I don't see the option to print out a inventory for all the cards installed in my cisco equipment across my enterprise. My Snmp inventory runs with no problems. trying to run the report now, but I get the below error when I select Cisco Inventory/ Card data in the "canned" reports/jobs.
SQL Error:
The text, ntext, or image data type cannot be selected as DISTINCT.
SELECT DISTINCT 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].[Model],[CATALYST_CARDS].[CardName],[CATALYST_CARDS].[ModuleModel],[CATALYST_CARDS].[CardSerial],[CATALYST_CARDS].[HWVersion],[CATALYST_CARDS].[SWVersion],[CATALYST_CARDS].[FWVersion],[CATALYST_CARDS].[Slot],[CISCO_CARDS].[CardName],[CISCO_CARDS].[CardDescr],[CISCO_CARDS].[CardSerial],[CISCO_CARDS].[HWVersion],[CISCO_CARDS].[SWVersion] from (select * from Nodes where SystemOID LIKE '1.3.6.1.4.1.9%') Nodes
left join Entity_Physical on Nodes.NodeId= Entity_Physical.NodeId
left join Catalyst_Cards on Nodes.NodeId= Catalyst_Cards.NodeId AND Catalyst_Cards.ModuleModel = Entity_Physical.Model
left join Cisco_Cards on Nodes.NodeId= Cisco_Cards.NodeId ORDER BY NodeCaption,ENTITY_PHYSICAL.Name,ENTITY_PHYSICAL.Description
