topic Re: Prime 3.1 - Inventory CSV in Controllers https://community.cisco.com/t5/controllers/prime-3-1-inventory-csv/m-p/3538575#M1754 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>May I know how to export all scheduled report CSV file via CLI is there any step by step guide on it.</P><P></P><P>Thanks </P></BODY></HTML> Tue, 17 Apr 2018 07:43:20 GMT Kram 2018-04-17T07:43:20Z Prime 3.1 - Inventory CSV https://community.cisco.com/t5/controllers/prime-3-1-inventory-csv/m-p/3538574#M1753 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>in order to easily export a list of all devices/modules within a network containing the product ID and serial number we have the option to leverage the reports available within Prime Infrastructure. However sometimes it is easier to just go through the API and extract the relevant information.</P><P></P><P>Below you will find a short example doing exactly this. It will create a CSV containing device name, IP, product id, serial number of your inventory.</P><P></P><P>Requirements:</P><P>- python 2</P><P>- requests, jsonpath, logging (<SPAN style="font-family: courier new,courier;">pip2 install requests jsonpath logging</SPAN>)</P><P></P><P>Tested with Prime 3.1.4</P><P></P><P>Execute:</P><P><SPAN style="font-family: courier new,courier;">python GenericReportRunner.py -u root -p password mypiserverip</SPAN></P><P></P><P>Result will be a deviceInventory&lt;timestamp&gt;.csv file in the subfolder 'reports' with following content</P><P><SPAN style="font-family: courier new,courier;">deviceId,productFamily,deviceName,ipAddress,modelNr,udiSerialNr</SPAN></P><P><SPAN style="font-family: courier new,courier;">123123,"Switches and Hubs","lab6880-core","10.10.10.1","C6800IA-48FPD","FOC1234567"</SPAN></P><P><SPAN style="font-family: courier new,courier;">...<BR /></SPAN></P></BODY></HTML> Tue, 24 Jan 2017 16:48:28 GMT https://community.cisco.com/t5/controllers/prime-3-1-inventory-csv/m-p/3538574#M1753 Stefan Honeder 2017-01-24T16:48:28Z Re: Prime 3.1 - Inventory CSV https://community.cisco.com/t5/controllers/prime-3-1-inventory-csv/m-p/3538575#M1754 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>May I know how to export all scheduled report CSV file via CLI is there any step by step guide on it.</P><P></P><P>Thanks </P></BODY></HTML> Tue, 17 Apr 2018 07:43:20 GMT https://community.cisco.com/t5/controllers/prime-3-1-inventory-csv/m-p/3538575#M1754 Kram 2018-04-17T07:43:20Z