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.
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