How to export the NPM Node List grouped by Device Type and City

gcappuccio

Hi, My NPM list is pretty simple, let's say I have them grouped by device type and then by State, for example:

-Routers

     -LAX

          -Router1 1.1.1.1

          -Router2 1.1.1.2

     -NY

          -Router1 2.1.1.1

          -Router2 2.1.1.2

     -FL

          -Router1 192.168.1.1

          -Router2 192.168.1.2

Switches

     -LAX

          -Switch1 1.1.1.10

          -Swich2  1.1.1.11

     -NY

          -Switch1 2.1.1.10

          -Swich2 2.1.1.11

     -FL

          -Switch1 192.168.1.10

          -Swich2 192.168.1.11

How can I export this to a spreadsheet or PDF preserving the groups by device typpe and state, and showing  name and IP address of the nodes ?

Thank you!

d09h

Maybe just export the Nodes table of the database a spreadsheet and have Libre Office/ Excel/ whatever do the grouping for you.

https://help.libreoffice.org/Calc/Sort_Criteria​

You could query your Nodes tables with SELECT * from Nodes ORDER BY <your device type custom property>, < your state custom property> and then export the results of that query.  Alternatively SELECT * from Nodes GROUP BY <your device type custom property>, < your state custom property>