1 Reply Latest reply on May 31, 2017 9:39 AM by pohjaton

    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.

        • Re: NPM Report writer on Cisco Stack switch count
          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

          1 of 1 people found this helpful