Skip to main content
drywall
New Member
Dec 13, 2018 7:41 PM UTC
Question

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_Datasets.htm

 

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

drywall
drywallAuthor
New Member
Jan 4, 2019 3:29 PM UTC

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
New Member
Jan 7, 2019 6:55 AM UTC

Hi drywall, 

 

I use this Fortimanager feature..  Export Device List

 

Export to CSV

 

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

 

 

 

 

drywall
drywallAuthor
New Member
Jan 7, 2019 3:21 PM UTC

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

Thought Leadership. Security Summit. Thursday, November 12th, PGA National Resort, Palm Beach Gardens, FL.
Security Operations Summit: Modernize SecOps. Operate AI-Native.AMER: November 4 | 9:00 AM PST. India and SAARC: November 5 | 10:00 AM IST. EMEA: November 5 | 10:30 AM CET. APAC: November 5 | 11:00 AM SGT