Skip to main content

I created a Network Intent that exports diagnosis to CSV, which works great when used in an auto-intent on a map, but we want to run this on thousands of devices and need a way to run/export these results to one spreadsheet.  A “map intent” has a limit of 1k command execution (so, up to 1k devices running one command on each).
I created an ADT table with 2k devices, added the Network Intent, but when ran the intents in the ADT, I ended up with 2k spreadsheets of results from each device.
 

Is there a way to export the NI diagnostics for 2k devices into one spreadsheet?

Randall,

Please find detailed solution in attached docuemnt.

Thanks & Regards

Gopalakrishna


Hi Randall,

ADT Intents results exported to one CSV

 

Diagnosis Results CSV:

In ADT we have option to export Diagnosis Result to CSV as below:-

 

Step 1: Open ADT and click on intent column.

Step 2: Click on Export Diagnosis Result to CSV

Step 3 : if you want to view data before export there is option preview Data.

Step 4: 

Step 5: After preview we can click option export.

Note: We must execute intents at least once to get data in CSV file otherwise preview or CSV file, we will be blank.

 

Intent consolidated CSV Report.

If we already defined CSV in intent, we could generate consolidated CSV report from ADT below are the steps:

Step 1: Open ADT and click on intent column.

Step 2: Click on view summary CSV Report

Step 3 : click on Create Summary Report

Step 4 : Download Summary Report

please let me know if you have any questions

Thanks & Regards

Gopalakrishna


Reply