I'd love to be able to write custom SQL reports in NCM. I am trying to get a list of routers that have switchcards in them. When I run the built-in report for this, there are multiple lines per entry for each node and I can't filter on the specific type of card I am looking for::::
My SQL looks like this:
select
n.sysname
, n.MachineTypeselect
n.sysname
, n.MachineType
, cc.CardDescr
, cc.HWVersion
, cc.Slot
from Cisco_cards cc JOIN Nodes n on n.NodeID=cc.NodeID
where cc.carddescr like '%FE Swi%' OR
cc.carddescr like '%Ethernet%'
AND
(
cc.CardDescr NOT like '%Motherboard%' AND
cc.carddescr NOT like '%CEF720%' AND
cc.carddescr NOT like '%1000mb%'
)
ORDER BY n.MachineType
