Export WAN1 and WAN2 IP addresses from all FortiGates to spreadsheet

8 replies
4846 views

Hi Fortinet Community,

My team and I are trying to find the most efficient way to export the wan1 and wan2 IP addresses and subnets from our FortiGates to a spreadsheet. All sites are attached to FortiManager and FortiAnalyzer.

Locally on the FortiGate we can find it by:

show system interface wan1 | grep "set ip"

show system interface wan2 | grep "set ip"

Thank you

Anthony_E

Staff

Hello Justin,

Thank you for using the Community Forum.

I will seek to get you an answer or help. We will reply to this thread with an update as soon as possible.

Regards,

Best Regards

gfleming

Staff

Are all of the wan1 and wan2 interface IP addresses set manually? No DHCP?

Mohamed_Gaber

Explorer III

Yes, if it is DHCP you have to use get system interface or either "get router info routing-table database" or "get router info routing-table all".

JJones_VillageMDAuthor

New Member

Great info.. how would we run this from FortiManager to print from all managed devices?

Mohamed_Gaber

Explorer III

Mohamed_Gaber

Explorer III

:)

I think the remote should send it. How FortiManager will get it if the remot IP is not known. If FortiGate register to FortiManager it is oK. I am sorry, I did not work on FortiMnager since a long time and have very littel experience with it. But I worked with FortiAnalyzer and it gets a message of Unknown device when it tries to register for the first time.

Sign up

Login with SSO

Login to the community

Login with SSO