I am trying to generate a csv report with very Basic Information for finding all inactive Ports on a Network Switch

Idea: - Devices: Several Network Switches; select all Ports - Run Report for 1 week - Show all Ports where Traffic (in/out) is zero - Save as csv

Can somebody at least guide me a little bit how to do this in PRTG? I tried and checked in manual - found maybe this is too "Basic"? :-)

For help thanks in advance!

Article Comments

Hi MMax,

Actually, it's possible to export the complete information (all interfaces) in a csv format, filtering for unused interfaces needs to be done outside of PRTG. You can either use the Historic Data tab of the device, or the Setup > API > Historic Data page to export the information.

If you want to perform the export on a regular base, you can use reports and choose the option Include CSV files only (available for templates with data tables) option.

Best regards, Felix


Nov, 2017 - Permalink

Hello Felix,

thanks for help but I stuck selecting the sensors for the Report. Let me explain what I am trying to accomplish with the Report: The device is a modular Switch with around 120 Ports. That particular Switch will be exchanged in near future. Over the years, some ports have a cable attached where on the other end is no device connected. So filtering all ports with no traffic would help finding the orphaned ports and could be cleaned up.

I was able to retrieve data with a URL creating a csv with historic data like this: http://<host>/api/historicdata.csv?id=2040&avg=0&sdate=2017-11-18-14-00-00&edate=2017-11-18-15-00-00 That would be fine, but it is always just for one port.

Is there another way to to gather data from all ports? The filtering could be done in Excel afterwards, that would be sufficient enough.

Thanks, Markus


Nov, 2017 - Permalink

Hello MMax,

Exporting the historic data indeed only works on sensor level and it's just possible to export the data for one sensor at a time within the current version of PRTG Network Monitor. This could be done with a script which performs the API request for each sensor ID of every traffic sensor in PRTG.

The easiest way might be to open the device in PRTG and to take a look at the small graphs of each sensor. If there is no traffic displayed, it's much likely that the port is not in use.

Best regards, Felix


Nov, 2017 - Permalink

Hello Felix,

ok - well, I have a different managemnt solution for that Task available (HPE IMC) where I found a prebuild Report which delivers a almost perfect dump of unused Ports - got it! Thanks for help and sorry for confusion.

Markus


Nov, 2017 - Permalink