Forum Discussion
lttarvina
Cirrus
CirrusF5 Firewall Policy Import to Excel via browser extension
Is there any specific way or any web browser extension which will export the ACL of AFM in excel file?
- JRahm
Admin
You could use the iControl REST API to retrieve the rules from AFM and then format that data into a csv or excel sheet. The endpoints for AFM are under:
lttarvinaThank you for providing a quicker resolution. I appreciate your time and attention on this matter, and I'm grateful for your efforts. Could you tell me what this link, https://big-ip-hostname/mgmt/tm/security/firewall/, is for? Even access to it is impossible.
- JRahm
that is a REST interface for where you would choose which part of the AFM policy you would want to retrieve, where big-ip-hostname is your big-ip hostname or IP address.
- GlenWillms
Employee
I don't have the ability to test this, but you may be able to use Power Query in Excel (or Power BI) to pull the AFM rules straight into Excel for easy data refreshes.
Here is a link (https://community.powerbi.com/t5/Power-Query/Using-a-REST-API-as-a-data-source/td-p/50400) on how to get REST data in Power BI, but Power Query in Excel is virtually identical.
