{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Instructions","Request","Ticket Status","Devices","Rules","Policy Analysis","NAT Rules","Network Objects","Services","Cisco ACL Stats","Check Point Policy Stats","Zone Based Firewall Stats","Debug","Settings"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Request","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Field","Value"]
["Priority","Normal"]
["Subject","I need access"]
[]
[]
[]
[]
[]
[]
["Source","Destination","Port","IPP"]
["1.2.3.0/24","2.0.0.0/8",53,"UDP"]
["192.168.1.1","172.16.1.8",80,"TCP"]

{"sheet":"Ticket Status","index":2,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["First Ticket to retrieve:",80]
["Number of tickets to retrieve:",1]
["Verifier step name:","Technical Design and Implementation"]
[]
[]
[]
[]
[]
["field_names:",null,"id","subject","requester","priority","status","workflow/name","current_step/name",{"$f":"\"steps/step[name='\"&B3&\"']/tasks/task/fields/field/access_request/*[name()='order' or name()='verifier_result']\"","v":"steps/step[name='Technical Design and Implementation']/tasks/task/fields/field/access_request/*[name()='order' or name()='verifier_result']"},"domain_name","application_details/display_name"]
[null,null,"Ticket ID","Subject","Requester","Priority","Status","Workflow","Current Step","Verification","Domain","Application (SecureApp)"]

{"sheet":"Devices","index":3,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Add Cleanup Stats (slower):","yes/no"]
[]
[]
[]
[]
["ID","Model","Vendor","Name","Disabled rules","Unattached network objects","Duplicate network objects","Duplicate Services","Empty Groups","Fully shadowed and redundant rules","Unused Objects"]

{"sheet":"Rules","index":4,"n_rows":7,"n_cols":37,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Device IDs (one per col):",20]
[]
[]
[]
[]
["field_names:",null,"id","cp_uid","uid","order","rule_number","name","binding/policy/name","binding/acl/interfaces/name | binding/interface/name","binding/acl/interfaces/direction | binding/interface/direction","binding/acl/interfaces/acl_name","binding/from_zone/name","binding/to_zone/name","src_network/display_name","src_networks_negated","src_services_negated","dst_network/display_name","dest_networks_negated","dst_service/display_name","dest_services_negated","action","track/level","disabled","external","comment","install/display_name","time/display_name","vpn/display_name","documentation/record_set/businessOwnerEmail","documentation/record_set/businessOwnerName","documentation/record_set/ticketCr","documentation/record_set/expireDate","documentation/tech_owner","documentation/secure_app_application/app_name","documentation/secure_app_application/app_owner","documentation/comment"]
["Firewall Name","Firewall ID","Rule ID","Vendor UID","Tufin UID","Order #","Number","Name","Check Point Policy","Cisco Interface","Cisco Direction","Cisco ACL","From Zone","To Zone","Source","Source Negated","Source Services Negated","Destination","Destination Negated","Service","Service Negated","Action","Log","Disabled","Global","Comment","Install On","Time","VPN","Business Owner email","Business Owner Name","SecureChange Ticket","Expiration Date","Technical Owner","Application","Application Owner","Description"]

{"sheet":"Policy Analysis","index":5,"n_rows":11,"n_cols":37,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Device IDs (one per col):",8,20]
[]
[null,"Exclude Any","Value 1","Value 2","Value 3","…"]
["Source",false,"Any"]
["Destination",false,"192.168.1.0/24"]
["Service",false,"tcp:80","tcp:23"]
["Action",null,"Accept"]
[]
[]
["field_names:",null,"id","cp_uid","uid","order","rule_number","name","binding/policy/name","binding/acl/interfaces/name | binding/interface/name","binding/acl/interfaces/direction | binding/interface/direction","binding/acl/interfaces/acl_name","binding/from_zone/name","binding/to_zone/name","src_network/display_name","src_networks_negated","src_services_negated","dst_network/display_name","dest_networks_negated","dst_service/display_name","dest_services_negated","action","track/level","disabled","external","comment","install/display_name","time/display_name","vpn/display_name","documentation/record_set/businessOwnerEmail","documentation/record_set/businessOwnerName","documentation/record_set/ticketCr","documentation/record_set/expireDate","documentation/tech_owner","documentation/secure_app_application/app_name","documentation/secure_app_application/app_owner","documentation/comment"]
["Firewall Name","Firewall ID","Rule ID","Vendor UID","Tufin UID","Order #","Number","Name","Check Point Policy","Cisco Interface","Cisco Direction","Cisco ACL","From Zone","To Zone","Source","Source Negated","Source Services Negated","Destination","Destination Negated","Service","Service Negated","Action","Log","Disabled","Global","Comment","Install On","Time","VPN","Business Owner email","Business Owner Name","SecureChange Ticket","Expiration Date","Technical Owner","Application","Application Owner","Description"]

{"sheet":"NAT Rules","index":6,"n_rows":8,"n_cols":36,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Device IDs (one per col):",21]
[]
[]
[null,"`"]
[]
[]
["field_names:",null,"id","cp_uid","uid","order","rule_number","name","binding/policy/name","binding/acl/interfaces/name | binding/interface/name","binding/acl/interfaces/direction | binding/interface/direction","binding/acl/interfaces/acl_name","binding/from_zone/name","binding/to_zone/name","orig_src_network/display_name","src_networks_negated","src_services_negated","dst_network/display_name","dest_networks_negated","dst_service/display_name","dest_services_negated","action","track/level","disabled","external","comment","install/display_name","time/display_name","vpn/display_name","documentation/record_set/businessOwnerEmail","documentation/record_set/businessOwnerName","documentation/record_set/ticketCr","documentation/record_set/expireDate","documentation/tech_owner","documentation/secure_app_application/app_name","documentation/secure_app_application/app_owner"]
["Firewall Name","Firewall ID","Rule ID","Vendor UID","Tufin UID","Order #","Number","Name","Check Point Policy","Cisco Interface","Cisco Direction","Cisco ACL","From Zone","To Zone","Original Source","Source Negated","Source Services Negated","Destination","Destination Negated","Service","Service Negated","Action","Log","Disabled","Global","Comment","Install On","Time","VPN","Business Owner email","Business Owner Name","SecureChange Ticket","Expiration Date","Technical Owner","Application","Application Owner"]

{"sheet":"Network Objects","index":7,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Device IDs (one per col):",20]
[]
[]
[]
[]
["field_names:",null,"id","display_name","ip","first_ip","last_ip","netmask","member/display_name","type","Global","comment"]
["Device Name","Device ID","Object ID","Object Name","IP","First IP","Last IP","Network Mask","Members","Type","Global","Comment"]

{"sheet":"Services","index":8,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Device IDs (one per col):",20]
[]
[]
[]
[]
["field_names:",null,"id","display_name","min","max","negate","protocol","timeout","member/display_name","type","Global","comment"]
["Device Name","Device ID","Object ID","Service Name","First Port","Last Port","Negated","Protocol","Timeout","Members","Type","Global","Comment"]

{"sheet":"Cisco ACL Stats","index":9,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Device IDs (one per col):",20]
[]
[]
[]
[]
["field_names:",null,"acl/name","acl/interfaces/name | interface/name","acl/interfaces/direction | interface/direction","acl/interfaces/interface_ips/interface_ip/ip | interface/interface_ips/interface_ip/ip","security_rule_count"]
["Firewall Name","Firewall ID","ACL","Interface","Direction","Interface IP","# of ACEs"]

{"sheet":"Check Point Policy Stats","index":10,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Device IDs (one per col):",20,5]
[]
[]
[]
[]
["field_names:",null,"policy/name","security_rule_count","policy/itg"]
["Management Name","Management ID","Policy","# of security rules","Installation Targets"]

{"sheet":"Zone Based Firewall Stats","index":11,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Device IDs (one per col):",5]
[]
[]
[]
[]
["field_names:",null,"from_zone/name","to_zone/name","security_rule_count"]
["Firewall Name","Firewall ID","From Zone","To Zone","# of security rules"]

{"sheet":"Debug","index":12,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Debug Enabled",false]
["Query"]
["Request XML"]
["Response XML"]

{"sheet":"Settings","index":13,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["SecureChange (required for the Request sheet only)"]
["Field","Value","Explanation"]
["Server","192.168.1.2","This is the SecureChange server IP"]
["Requestor","user","Username must be allowed to submit the ticket in the workflow"]
["Password","password","After you set the password, you can hide the cell and lock the spreadsheet"]
["Domain","Default","Leave as \"Default\" unless you are using a multi-domain deployment"]
["Workflow","<enter the workflow name>","Must be a valid workflow name (only needed for submitting tickets in SecureChange)"]
[]
["SecureTrack (required for all sheets except Request)"]
["Field","Value","Explanation"]
["Server","192.168.1.2","This is the SecureTrack server IP"]
["Username","user","A SecureTrack user"]
["Password","password","After you set the password, you can hide the cell and lock the spreadsheet"]