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

Asset list / inventory report - Hostnames and Serial Numbers



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.


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.


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.


Hi drywall, 


I use this Fortimanager feature..  Export Device List


Export to CSV


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






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.




Select Forum Responses to become Knowledge Articles!

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

Top Kudoed Authors