Skip to main content
DEMANOU
New Member
October 29, 2019
Question

extraction of the rules in an excel file

Hello, I am Jocelyn NIKOU, intern at this time at Axel IT and I have a small problem on a topic concerning fortigate 90D. I have an audit account and I would like to extract the rules of this firewall in an excel file. How could I achieve this please. Thank you. I'm waiting for your reaction please

    3 replies

    emnoc
    New Member
    October 29, 2019

    I would use the API and jq or jsawk to parse the json output.You can extact the dst|sraddr dst|srcintf etc..... for your aduit or any fields that you want

     

     

    Ken Felix

     

     

     

     

     

    Elthon_Abreu
    New Member
    October 29, 2019

    Hi Jocelyn,

     

    Check this out: https://forum.fortinet.com/tm.aspx?m=164167

    tioeudes
    New Member
    October 29, 2019

    If you have a FortiManager you can import the policy package from the fortigate to the fortimanager and then you can save the firewall policy list into a csv file. You can use a vm fortimanager and there is no license required to achieve this.

     

     

     

    Best regards,

    tioeudes

    Thought Leadership. Security Summit. Thursday, November 12th, PGA National Resort, Palm Beach Gardens, FL.
    Thought Leadership. Security Summit. Thursday, October 8th. Disney's Grand Californian Hotel & SPA, Anaheim, CA.
    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