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

extraction of the rules in an excel file

  • October 29, 2019
  • 1 reply
  • 4805 views

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

    1 reply

    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