Support Forum
The Forums are a place to find answers on a range of Fortinet products from peers and product experts.
drywall
New Contributor

Asset list / inventory report - Hostnames and Serial Numbers

Hello!

 

How do I create a report for providing a list of the fortiwifi devices in the fortimanager's VDOMs?  We have over 500.  I mostly just need the hostname, IP, and serial number, that can be listed in a csv or spreadsheet.

 

I opened a ticket with support, though since the report didn't exist they can't help--Nothing was technically broken.  I don't know SQL either, so that doesn't help with trying to figure out how to spit out the data.

 

This page shows some info about creating the data set, though I don't know where to start with the query.  http://help.fortinet.com/fa/faz50hlp/56/5-6-1/FMG-FAZ/2300_Reports/1400_Datasets/0200_Create_Dataset...

 

Any suggestions on how to proceed, or has anyone else come across this?  Searches in the forum and google didn't provide anything useful for this situation.

Thanks!

3 REPLIES 3
drywall
New Contributor

We ended up having someone write a script to pull the relevant data out of the exported device list (extract the .dat file w/ 7zip and rename to a .txt).  The script then wrote the needed data to a .csv.

 

Somewhat amazing there was no built in inventory/asset list, in my opinion.

mamuning2017

Hi drywall, 

 

I use this Fortimanager feature..  Export Device List

 

Export to CSV

 

It is right under the Device Manager's More option. 

 

 

 

 

drywall

Hi Mamuning2017,

 

What version of fortimanager do you have?  We're using v5.6.3.  We're only able to export the device list as a .dat file.  From there we extract it and parse the data.

 

Thanks

Announcements

Select Forum Responses to become Knowledge Articles!

Select the “Nominate to Knowledge Base” button to recommend a forum post to become a knowledge article.

Labels
Top Kudoed Authors