I am trying to get an inventory of a chassis switch and all the modules in it. There is one but it is way too big. How do i cut out all the Ethernet ports? Here is the SWQL.
SELECT OrionNodes.Caption, OrionNodes.DetailsUrl, OrionNodes.Status, OrionNodes.ChildStatus,NcmEntityPhysical.EntityName, NcmEntityPhysical.EntityDescription, NcmEntityPhysical.EntityClass, NcmEntityPhysical.Position, NcmEntityPhysical.HardwareRevision, NcmEntityPhysical.FirmwareRevision, NcmEntityPhysical.SoftwareRevision,
NcmEntityPhysical.Serial AS SerialNumber, NcmEntityPhysical.Model,NcmCatalystCards.CardName AS CatCardName,NcmCatalystCards.ModuleModel AS CatCardModel, NcmCatalystCards.CardSerial AS CatCardSerial, NcmCatalystCards.HWVersion AS CatHWVersion, NcmCatalystCards.SWVersion AS CatSWVersion, NcmCatalystCards.FWVersion AS CatFWVersion, NcmCatalystCards.Slot AS CatSlot, NcmCiscoCards.CardName AS CardNameOld, NcmCiscoCards.CardDescr AS CardDescrOld, NcmCiscoCards.CardSerial AS CardSerialOld,NcmCiscoCards.HWVersion AS HWVersionOld, NcmCiscoCards.SWVersion AS SWVersionOld
FROM NCM.NodeProperties AS NcmNodeProperties
INNER JOIN Orion.Nodes AS OrionNodes ON NcmNodeProperties.CoreNodeID=OrionNodes.NodeID
LEFT JOIN NCM.EntityPhysical AS NcmEntityPhysical ON NcmNodeProperties.NodeID=NcmEntityPhysical.NodeID
LEFT JOIN Cirrus.CatalystCards AS NcmCatalystCards ON NcmNodeProperties.NodeID=NcmCatalystCards.NodeID
LEFT JOIN NCM.CiscoCards AS NcmCiscoCards ON NcmNodeProperties.NodeID=NcmCiscoCards.NodeID
WHERE (NcmEntityPhysical.NodeID IS NOT NULL OR NcmCatalystCards.NodeID IS NOT NULL OR NcmCiscoCards.NodeID IS NOT NULL) AND OrionNodes.SysObjectID LIKE '1.3.6.1.4.1.9%'