NPM Report writer on Cisco Stack switch count

pohjaton

Hi, I have rather large environment where I should be able to report the individual switch count. Since I have multiple stacks with random amount of switches on them, I would need to be able to report the actual hardware count. I have been searching the community for a solution but so far I have not been able to find the way to do that on NMP.

Is there a way to write a report to collect all devices including devices in stack with NPM only.

pohjaton

And I found a way to do this via Report Writer using custom SQL query

SELECT [dbo].[Nodes].NodeID,  [dbo].[Nodes].IP_Address, [dbo].[Nodes].Caption,  [dbo].[Nodes].MachineType, SwitchNumber, Model, SerialNumber FROM NPM_SwitchStackMember_V

FULL JOIN Nodes ON NPM_SwitchStackMember_V.NodeID = Nodes.NodeID

ORDER BY Nodes.NodeID ASC