Exporting a policy configuration from a Juniper device to a CSV and XSL readable for Chief
PROBLEM OR GOAL: How can I export a policy configuration from a SRX device to a XML-compliant spreadsheet?
SOLUTION: junos-device# show security policies | display xml | no-more
We can save the result to file and open in MS Exel or other application. But this format inconvenient for edit.
### example 1 : if your configuration file contains
### set applications application TCP_1433 protocol tcp
### set applications application TCP_1433 destination-port 1433
### set applications application TCP_1433 inactivity-timeout 43200
###
### add to _application variable "TCP_1433": "tcp/143 inactivity-timeout 43200"
###
### exaple 2: if your configuration file contains
### set security zones security-zone untrust address-book address NTP_1 8.8.8.8/32
###
### add to _address variable "NTP_1": "8.8.8.8/32"
BUT WE HAVE ONE PROBLEM: The name of source, destination and application must not contain symbol "-"