Asset list / inventory report - Hostnames and Serial Numbers

Forum|Forum|7 years ago
December 13, 2018
3 replies
8290 views

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!

Dataset

drywallAuthor

New Member

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

Hi drywall,

I use this Fortimanager feature.. Export Device List

Export to CSV

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

drywallAuthor

New Member

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

Sign up

Login with SSO

Login to the community

Login with SSO