{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Saisie des paramètres","Configurations","Config Elements","Service"],"not_rendered":{"macros":1,"defined_names":19},"read":"whole","date_system":"1900"}

{"sheet":"Saisie des paramètres","index":0,"n_rows":82,"n_cols":11,"rows_kept":82,"merged":[[0,0,0,2],[13,0,13,2],[22,0,22,2],[26,0,26,2],[30,0,30,2],[32,0,32,2]]}
["Generateur de configuration SWA",{"$nulls":8},"Historique"]
[{"$nulls":9},1,"premiere version"]
[null,null,"Version :  1.1"]
[]
["Utilisation"]
["1 - Activer les macros"]
["2 - Renseigner les cases en jaune"]
["3 - Ne pas modifier les cases en orange, elle sont automatiquement calculées"]
["4 - Appuyer sur le bouton \"Génération configuration\""]
["5 - Les configurations sont dans l'onglet \"Configurations\""]
[]
["Ne pas modifier les onglets \"Config Elements\" \"Service\" qui servent au fonctionnement du script "]
[null,"Variable utilisée dans la configuration","Paramètres"]
["Paramètres généraux"]
["Hostname (nom du routeur)","<device_name>","SDEOFF-SWA506"]
["Adresse IP d'administration","<management_ip_address>","10.100.129.20"]
["Passerelle par défaut","<management_default_gateway>",{"$f":"IPAdd(IpAnd(C16,\"255.255.255.0\"),1)","v":"10.100.129.1"}]
["Range de management","<local_management_range>",{"$f":"IpAnd(C16,\"255.255.255.0\")","v":"10.100.129.0"}]
["Nom du Site","<site_name>",{"$f":"MID($C$15,1,3)","v":"SDE"}]
["Switch Type",null,"WS-C2960S-F24TS-L"]
["RJ45 Interface type","<nbr_interface>",{"$f":"VLOOKUP($C$20,Service!G1:I6,2,FALSE)","v":24}]
["Nombre d'interface RJ45","<type>",{"$f":"VLOOKUP($C$20,Service!G2:I7,3,FALSE)","v":"Fast"}]
["Trunk 1"]
["Nom de l'interface","<Trunk_Interface_1>","GigabitEthernet1/0/9"]
["Nom de l'équipement distant","<Remote_device_1>","SDEMTR-SWC001"]
["Nom de l'interface distante","<Remote_interface_1>","Te1/0/3"]
["Trunk 2"]
["Nom de l'interface","<Trunk_Interface_2>","GigabitEthernet1/0/10"]
["Nom de l'équipement distant","<Remote_device_2>","SDEMTR-SWC002"]
["Nom de l'interface distante","<Remote_interface_2>","Te2/0/3"]
["VLAN"]
["Selection multiple des VLANS","<liste_vlan>","328, 206"]
["Interfaces",null,null,"Service"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",1)","v":"FastEhernet1/0/1"},{"$f":"IF($D34=\"CiscoAP\",\"<AP_name>\",IF($D34=\"RuckusAP\",\"<AP_name>\",\"\"))","v":""},"SDEOFF-WAP501","Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",2)","v":"FastEhernet1/0/2"},{"$f":"IF($D35=\"CiscoAP\",\"<AP_name>\",IF($D35=\"RuckusAP\",\"<AP_name>\",\"\"))","v":""},null,"Printer Org"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",3)","v":"FastEhernet1/0/3"},"",null,"Corporate"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",4)","v":"FastEhernet1/0/4"},"",null,"VoiceConf"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",5)","v":"FastEhernet1/0/5"},"",null,"Corporate"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",6)","v":"FastEhernet1/0/6"},"","SDEOFF-WAP502","Printer 3rd party"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",7)","v":"FastEhernet1/0/7"},"",null,"VideoConf"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",8)","v":"FastEhernet1/0/8"},"<AP_name>","SDEOFF-WAP505","RuckusAP"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",9)","v":"FastEhernet1/0/9"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",10)","v":"FastEhernet1/0/10"},"",null,"Dedicated Internet Wired Misc"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",11)","v":"FastEhernet1/0/11"},"<AP_name>","SDEOFF-WAP506","CiscoAP"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",12)","v":"FastEhernet1/0/12"},"",null,"Dedicated Internet Wired ACR"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",13)","v":"FastEhernet1/0/13"},"",null,"Dedicated Internet Wired Org"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",14)","v":"FastEhernet1/0/14"},"",null,{"$f":"INDEX(ChoiceInterface,1)","v":"Shutdown"}]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",15)","v":"FastEhernet1/0/15"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",16)","v":"FastEhernet1/0/16"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",17)","v":"FastEhernet1/0/17"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",18)","v":"FastEhernet1/0/18"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",19)","v":"FastEhernet1/0/19"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",20)","v":"FastEhernet1/0/20"},"",null,{"$f":"INDEX(ChoiceInterface,1)","v":"Shutdown"}]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",21)","v":"FastEhernet1/0/21"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",22)","v":"FastEhernet1/0/22"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",23)","v":"FastEhernet1/0/23"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",24)","v":"FastEhernet1/0/24"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",25)","v":"FastEhernet1/0/25"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",26)","v":"FastEhernet1/0/26"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",27)","v":"FastEhernet1/0/27"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",28)","v":"FastEhernet1/0/28"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",29)","v":"FastEhernet1/0/29"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",30)","v":"FastEhernet1/0/30"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",31)","v":"FastEhernet1/0/31"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",32)","v":"FastEhernet1/0/32"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",33)","v":"FastEhernet1/0/33"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",34)","v":"FastEhernet1/0/34"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",35)","v":"FastEhernet1/0/35"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",36)","v":"FastEhernet1/0/36"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",37)","v":"FastEhernet1/0/37"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",38)","v":"FastEhernet1/0/38"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",39)","v":"FastEhernet1/0/39"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",40)","v":"FastEhernet1/0/40"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",41)","v":"FastEhernet1/0/41"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",42)","v":"FastEhernet1/0/42"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",43)","v":"FastEhernet1/0/43"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",44)","v":"FastEhernet1/0/44"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",45)","v":"FastEhernet1/0/45"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",46)","v":"FastEhernet1/0/46"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",47)","v":"FastEhernet1/0/47"},"",null,"Shutdown"]
[{"$f":"CONCATENATE($C$22,\"Ehernet1/0/\",48)","v":"FastEhernet1/0/48"},"",null,"Shutdown"]
[null,"###findeliste###"]

{"sheet":"Configurations","index":1,"n_rows":268,"n_cols":1,"rows_kept":268}
[]
["!"]
["interface FastEthernet0"]
[" shutdown "]
["!"]
["interface range FastEthernet1/0/1-24"]
[" shutdown "]
["!"]
["crypto key generate rsa"]
[2048]
["!"]
["ip ssh time-out 60"]
["ip ssh authentication-retries 2"]
["ip ssh version 2"]
["!"]
["interface Vlan1"]
[" no ip address"]
[" shutdown"]
[]
["!"]
["hostname  SDEOFF-SWA506"]
["!"]
["no service pad"]
["service tcp-keepalives-in"]
["service tcp-keepalives-out"]
["service timestamps debug datetime msec localtime show-timezone"]
["service timestamps log datetime msec localtime show-timezone"]
["service password-encryption"]
["service sequence-numbers"]
["no ip source-route"]
["no ip gratuitous-arps"]
["no ip http server"]
["ip http authentication local"]
["no ip http secure-server"]
["!"]
["clock timezone CET 1 0"]
["clock summer-time CET recurring last Sun Mar 2:00 last Sun Oct 3:00"]
["!"]
["aaa new-model"]
["!"]
["username admin privilege 15 password $Euro2016SDE#"]
["username uefadmin privilege 15 password $Euro2016SDE#"]
["!"]
["enable secret U$f@20I6"]
["!"]
["aaa authentication password-prompt secured-password:"]
["aaa authentication username-prompt secured-username:"]
["aaa authentication login VTY group tacacs+ local"]
["aaa authentication login CONSOLE local"]
["aaa authorization config-commands"]
["aaa authorization exec default group tacacs+ local"]
["aaa authorization commands 15 default group tacacs+ none"]
["aaa accounting send stop-record authentication failure"]
["aaa accounting exec default start-stop group tacacs+"]
["aaa accounting commands 15 default start-stop group tacacs+"]
["aaa accounting connection default start-stop group tacacs+"]
["!"]
["aaa session-id common"]
["!"]
["ip tacacs source-interface Vlan395"]
["!"]
["tacacs server AAA"]
[" address ipv4 10.103.5.221"]
[" key 67X2t1IorCE1F4fS5JCN4ER8D1ou8uoS"]
["!"]
["line con 0"]
[" exec-timeout 15 0"]
[" logging synchronous"]
[" login authentication CONSOLE"]
[" stopbits 1"]
["!"]
["line vty 0 15"]
[" access-class 4 in"]
[" access-class 3 out"]
[" exec-timeout 15 0"]
[" logging synchronous"]
[" login authentication VTY"]
[" transport preferred ssh"]
[" transport input ssh"]
[" transport output ssh"]
["!"]
["!"]
["interface FastEthernet1/0/2"]
[" description --- Printer"]
[" switchport access vlan 391"]
[" switchport mode access"]
[" storm-control broadcast level 5.00"]
[" storm-control multicast level 50.00"]
[" spanning-tree portfast"]
[" spanning-tree bpduguard enable"]
[" no shutdown"]
["!"]
["interface FastEthernet1/0/3"]
[" description --- Users"]
[" switchport access vlan 328"]
[" switchport mode access"]
[" switchport voice vlan 360"]
[" switchport port-security maximum 4"]
[" switchport port-security"]
[" switchport port-security aging time 2"]
[" switchport port-security violation restrict"]
[" switchport port-security aging type inactivity"]
[" no logging event link-status"]
[" no snmp trap link-status"]
[" srr-queue bandwidth share 1 30 35 5"]
[" priority-queue out"]
[" no snmp trap link-status"]
[" mls qos trust device cisco-phone"]
[" mls qos trust cos"]
[" storm-control broadcast level 5.00"]
[" storm-control multicast level 50.00"]
[" spanning-tree portfast"]
[" spanning-tree bpduguard enable"]
[" no shutdown"]
["!"]
["interface FastEthernet1/0/4"]
[" description --- VoiceConf"]
[" switchport access vlan 360"]
[" switchport mode access"]
[" switchport port-security"]
[" switchport port-security violation restrict"]
[" switchport port-security mac-address sticky"]
[" srr-queue bandwidth share 10 10 60 20"]
[" queue-set 2"]
[" priority-queue out"]
[" mls qos trust device cisco-phone"]
[" mls qos trust cos"]
[" no logging event link-status"]
[" no snmp trap link-status"]
[" storm-control broadcast level 5.00"]
[" storm-control multicast level 50.00"]
[" spanning-tree portfast"]
[" spanning-tree bpduguard enable"]
[" no shutdown"]
["!"]
["interface FastEthernet1/0/5"]
[" description --- Users"]
[" switchport access vlan 328"]
[" switchport mode access"]
[" switchport voice vlan 360"]
[" switchport port-security maximum 4"]
[" switchport port-security"]
[" switchport port-security aging time 2"]
[" switchport port-security violation restrict"]
[" switchport port-security aging type inactivity"]
[" no logging event link-status"]
[" no snmp trap link-status"]
[" srr-queue bandwidth share 1 30 35 5"]
[" priority-queue out"]
[" no snmp trap link-status"]
[" mls qos trust device cisco-phone"]
[" mls qos trust cos"]
[" storm-control broadcast level 5.00"]
[" storm-control multicast level 50.00"]
[" spanning-tree portfast"]
[" spanning-tree bpduguard enable"]
[" no shutdown"]
["!"]
["interface FastEthernet1/0/6"]
["description To Printer_INT"]
["switchport mode access"]
["switchport access vlan 205"]
["mls qos cos 1"]
["storm-control broadcast level 5.00"]
["storm-control multicast level 50.00"]
["no cdp enable"]
["spanning-tree portfast"]
["spanning-tree bpduguard enable"]
["no logging event link-status"]
["authentication order webauth"]
["authentication priority webauth"]
["authentication port-control auto"]
["authentication fallback WEB-AUTH"]
["no snmp trap link-status"]
["no shutdown"]
["!"]
["interface FastEthernet1/0/7"]
[" description --- VideoConf"]
[" switchport access vlan 328"]
[" switchport mode access"]
[" switchport port-security"]
[" switchport port-security violation restrict"]
[" switchport port-security mac-address sticky"]
[" no logging event link-status"]
[" no snmp trap link-status"]
[" storm-control broadcast level 5.00"]
[" storm-control multicast level 50.00"]
[" spanning-tree portfast"]
[" spanning-tree bpduguard enable"]
[" no shutdown"]
["!"]
["interface FastEthernet1/0/8"]
[" description To SDEOFF-WAP505 - Gi0"]
[" switchport trunk native vlan 397"]
[" switchport trunk allowed vlan 397,251"]
[" switchport mode trunk"]
[" srr-queue bandwidth share 1 30 35 5"]
[" priority-queue out"]
[" mls qos trust dscp"]
[" spanning-tree portfast trunk"]
[" spanning-tree bpduguard enable"]
[" no shutdown"]
["!"]
["interface FastEthernet1/0/10"]
["description To Wired_Misc_INT"]
["switchport mode access"]
["switchport access vlan 206"]
["mls qos cos 1"]
["storm-control broadcast level 5.00"]
["storm-control multicast level 50.00"]
["no cdp enable"]
["spanning-tree portfast"]
["spanning-tree bpduguard enable"]
["no logging event link-status"]
["authentication order webauth"]
["authentication priority webauth"]
["authentication port-control auto"]
["authentication fallback WEB-AUTH"]
["no snmp trap link-status"]
["no shutdown"]
["!"]
["interface FastEthernet1/0/11"]
[" description To SDEOFF-WAP506 - Gi0"]
[" switchport trunk native vlan 396"]
[" switchport trunk allowed vlan 396,251"]
[" switchport mode trunk"]
[" srr-queue bandwidth share 1 30 35 5"]
[" priority-queue out"]
[" mls qos trust dscp"]
[" spanning-tree portfast trunk"]
[" spanning-tree bpduguard enable"]
[" no shutdown"]
["!"]
["interface FastEthernet1/0/12"]
["description To Wired_OrgOFF_INT"]
["switchport mode access"]
["switchport access vlan 201"]
["mls qos cos 1"]
["storm-control broadcast level 5.00"]
["storm-control multicast level 50.00"]
["no cdp enable"]
["spanning-tree portfast"]
["spanning-tree bpduguard enable"]
["no logging event link-status"]
["authentication order webauth"]
["authentication priority webauth"]
["authentication port-control auto"]
["authentication fallback WEB-AUTH"]
["no snmp trap link-status"]
["no shutdown"]
["!"]
["interface FastEthernet1/0/13"]
["description To Wired_OrgOFF_INT"]
["switchport mode access"]
["switchport access vlan 201"]
["mls qos cos 1"]
["storm-control broadcast level 5.00"]
["storm-control multicast level 50.00"]
["no cdp enable"]
["spanning-tree portfast"]
["spanning-tree bpduguard enable"]
["no logging event link-status"]
["authentication order webauth"]
["authentication priority webauth"]
["authentication port-control auto"]
["authentication fallback WEB-AUTH"]
["no snmp trap link-status"]
["no shutdown"]

{"sheet":"Config Elements","index":2,"n_rows":193,"n_cols":14,"rows_kept":193}
["! Basics","! Common configuration","! LAYER 2 common configuration","! LAYER 2 VLAN","! LAYER 3","! Interface Trunk","! Interface CorporateWired","! Interface Printer","! Interface CiscoAccessPoint","! Interface RuckusAccessPoint","! Interface VoiceConf","! Interface VideoConf","! Interface WiredInternet","! Interface WiredInternetNoDisc"]
["cfgBas","comCon","l2ComCon","layer2VLAN","layer3","intTrunk","intCorWired","intPrint","intCAP","intRAP","intVoiceConf","IntVideoConf","IntWiredInt","IntWiredIntNoD"]
["!","!","!","!","!","!","!","!","!","!","!","!","!","!"]
["interface FastEthernet0","hostname  <device_name>","ip dhcp bootp ignore","vlan <vlan_id>","interface Vlan395","interface <Trunk_Interface_1>","interface <type>Ethernet1/0/<j>","interface <type>Ethernet1/0/<j>","interface <type>Ethernet1/0/<j>","interface <type>Ethernet1/0/<j>","interface <type>Ethernet1/0/<j>","interface <type>Ethernet1/0/<j>","interface <type>Ethernet1/0/<j>","interface <type>Ethernet1/0/<j>"]
[" shutdown ","!","!","name <vlan_name>","description net-mgmt-CORP","description To <Remote_device_1> - <Remote_interface_1>"," description --- Users"," description --- Printer"," description To <AP_name> - Gi0"," description To <AP_name> - Gi0"," description --- VoiceConf"," description --- VideoConf","description To <vlan_name>","description To <Vlan Name>"]
["!","no service pad","ip dhcp snooping","###findeconfig###","ip address <management_ip_address> 255.255.255.0","switchport mode trunk"," switchport access vlan 328"," switchport access vlan 391"," switchport trunk native vlan 396"," switchport trunk native vlan 397"," switchport access vlan 360"," switchport access vlan 328","switchport mode access","switchport mode access"]
["interface range <type>Ethernet1/0/1-<nbr_interface>","service tcp-keepalives-in","ip dhcp snooping vlan <liste_vlan>",null,"no ip redirects","switchport nonegotiate"," switchport mode access"," switchport mode access"," switchport trunk allowed vlan 396,251"," switchport trunk allowed vlan 397,251"," switchport mode access"," switchport mode access","switchport access vlan <vlan>","switchport access vlan <vlan>"]
[" shutdown ","service tcp-keepalives-out","no ip dhcp snooping information option",null,"no ip unreachables","mls qos trust dscp"," switchport voice vlan 360"," storm-control broadcast level 5.00"," switchport mode trunk"," switchport mode trunk"," switchport port-security"," switchport port-security","mls qos cos 1","mls qos cos 1"]
["!","service timestamps debug datetime msec localtime show-timezone","!",null,"no ip proxy-arp","storm-control broadcast level 10.00"," switchport port-security maximum 4"," storm-control multicast level 50.00"," srr-queue bandwidth share 1 30 35 5"," srr-queue bandwidth share 1 30 35 5"," switchport port-security violation restrict"," switchport port-security violation restrict","storm-control broadcast level 5.00","storm-control broadcast level 5.00"]
["crypto key generate rsa","service timestamps log datetime msec localtime show-timezone","vtp mode off",null,"!","spanning-tree portfast disable"," switchport port-security"," spanning-tree portfast"," priority-queue out"," priority-queue out"," switchport port-security mac-address sticky"," switchport port-security mac-address sticky","storm-control multicast level 50.00","storm-control multicast level 50.00"]
[2048,"service password-encryption","vtp domain <site_name>",null,"ip default-gateway <management_default_gateway>","spanning-tree bpduguard disable"," switchport port-security aging time 2"," spanning-tree bpduguard enable"," mls qos trust dscp"," mls qos trust dscp"," srr-queue bandwidth share 10 10 60 20"," no logging event link-status","no cdp enable","no cdp enable"]
["!","service sequence-numbers","!",null,"###findeconfig###","ip dhcp snooping trust"," switchport port-security violation restrict"," no shutdown"," spanning-tree portfast trunk"," spanning-tree portfast trunk"," queue-set 2"," no snmp trap link-status","spanning-tree portfast","spanning-tree portfast"]
["ip ssh time-out 60","no ip source-route","spanning-tree mode rapid-pvst",null,null,"!"," switchport port-security aging type inactivity","###findeconfig###"," spanning-tree bpduguard enable"," spanning-tree bpduguard enable"," priority-queue out"," storm-control broadcast level 5.00","spanning-tree bpduguard enable","spanning-tree bpduguard enable"]
["ip ssh authentication-retries 2","no ip gratuitous-arps","spanning-tree logging",null,null,"interface <Trunk_Interface_2>"," no logging event link-status",null," no shutdown"," no shutdown"," mls qos trust device cisco-phone"," storm-control multicast level 50.00","no logging event link-status","no logging event link-status"]
["ip ssh version 2","no ip http server","spanning-tree extend system-id",null,null," description To <Remote_device_2> - <Remote_interface_2>"," no snmp trap link-status",null,"###findeconfig###","###findeconfig###"," mls qos trust cos"," spanning-tree portfast","authentication order webauth","no snmp trap link-status"]
["!","ip http authentication local","!",null,null," switchport mode trunk"," srr-queue bandwidth share 1 30 35 5",{"$nulls":3}," no logging event link-status"," spanning-tree bpduguard enable","authentication priority webauth","no shutdown"]
["interface Vlan1","no ip http secure-server","udld enable",null,null," switchport nonegotiate"," priority-queue out",{"$nulls":3}," no snmp trap link-status"," no shutdown","authentication port-control auto","###findeconfig###"]
[" no ip address","!","!",null,null," mls qos trust dscp"," no snmp trap link-status",{"$nulls":3}," storm-control broadcast level 5.00","###findeconfig###","authentication fallback WEB-AUTH"]
[" shutdown","clock timezone CET 1 0","errdisable recovery cause udld",null,null," storm-control broadcast level 10.00"," mls qos trust device cisco-phone",{"$nulls":3}," storm-control multicast level 50.00",null,"no snmp trap link-status"]
["###findeconfig###","clock summer-time CET recurring last Sun Mar 2:00 last Sun Oct 3:00","errdisable recovery cause bpduguard",null,null," spanning-tree portfast disable"," mls qos trust cos",{"$nulls":3}," spanning-tree portfast",null,"no shutdown"]
[null,"!","errdisable recovery cause security-violation",null,null," spanning-tree bpduguard disable"," storm-control broadcast level 5.00",{"$nulls":3}," spanning-tree bpduguard enable",null,"###findeconfig###"]
[null,"aaa new-model","errdisable recovery interval 60",null,null," ip dhcp snooping trust"," storm-control multicast level 50.00",{"$nulls":3}," no shutdown"]
[null,"!","!",null,null," no shutdown"," spanning-tree portfast",{"$nulls":3},"###findeconfig###"]
[null,"username admin privilege 15 password $Euro2016<site_name>#","vlan internal allocation policy ascending",null,null,"###findeconfig###"," spanning-tree bpduguard enable"]
[null,"username uefadmin privilege 15 password $Euro2016<site_name>#","###findeconfig###",{"$nulls":3}," no shutdown"]
[null,"!",{"$nulls":4},"###findeconfig###"]
[null,"enable secret U$f@20I6"]
[null,"!"]
[null,"aaa authentication password-prompt secured-password:"]
[null,"aaa authentication username-prompt secured-username:"]
[null,"aaa authentication login VTY group tacacs+ local"]
[null,"aaa authentication login CONSOLE local"]
[null,"aaa authorization config-commands"]
[null,"aaa authorization exec default group tacacs+ local"]
[null,"aaa authorization commands 15 default group tacacs+ none"]
[null,"aaa accounting send stop-record authentication failure"]
[null,"aaa accounting exec default start-stop group tacacs+"]
[null,"aaa accounting commands 15 default start-stop group tacacs+"]
[null,"aaa accounting connection default start-stop group tacacs+"]
[null,"!"]
[null,"aaa session-id common"]
[null,"!"]
[null,"ip tacacs source-interface Vlan395"]
[null,"!"]
[null,"tacacs server AAA"]
[null," address ipv4 10.103.5.221"]
[null," key 67X2t1IorCE1F4fS5JCN4ER8D1ou8uoS"]
[null,"!"]
[null,"line con 0"]
[null," exec-timeout 15 0"]
[null," logging synchronous"]
[null," login authentication CONSOLE"]
[null," stopbits 1"]
[null,"!"]
[null,"line vty 0 15"]
[null," access-class 4 in"]
[null," access-class 3 out"]
[null," exec-timeout 15 0"]
[null," logging synchronous"]
[null," login authentication VTY"]
[null," transport preferred ssh"]
[null," transport input ssh"]
[null," transport output ssh"]
[null,"!"]
[null,"login on-failure log"]
[null,"!"]
[null,"logging host 172.16.24.24"]
[null,"logging host 192.168.38.21"]
[null,"logging file flash:logging 50000 warnings"]
[null,"logging buffered 100000"]
[null,"logging console warnings"]
[null,"!"]
[null,"ip domain-name euro2016.fr"]
[null,"ip name-server 10.103.5.68 "]
[null,"ip name-server 10.103.5.69"]
[null,"!"]
[null,"access-list 3 remark --- ssh sortant ---"]
[null,"access-list 3 deny   any log"]
[null,"access-list 4 remark --- ssh entrant ---"]
[null,"access-list 4 permit 172.16.24.24"]
[null,"access-list 4 permit 172.16.3.0 0.0.0.255"]
[null,"access-list 4 permit 172.16.4.0 0.0.0.255"]
[null,"access-list 4 permit 172.16.41.0 0.0.0.255"]
[null,"access-list 4 permit 172.16.42.0 0.0.0.255"]
[null,"access-list 4 permit 172.16.81.0 0.0.0.255"]
[null,"access-list 4 permit 172.16.82.0 0.0.0.255"]
[null,"access-list 4 permit 193.105.90.0 0.0.0.255"]
[null,"access-list 4 permit 194.250.187.0 0.0.0.255"]
[null,"access-list 4 permit 195.6.0.0 0.0.0.25"]
[null,"access-list 4 permit 10.103.5.192 0.0.0.63"]
[null,"access-list 4 permit <local_management_range> 0.0.0.255"]
[null,"access-list 4 deny   any log"]
[null,"access-list 5 remark --- Polling SNMP NAGIOS ---"]
[null,"access-list 5 permit 10.103.4.16 0.0.0.15"]
[null,"access-list 5 deny   any log"]
[null,"access-list 6 remark ---Pooling SNMP RW---"]
[null,"access-list 6 permit 10.103.5.221"]
[null,"access-list 6 deny   any log"]
[null,"access-list 50 remark --- Polling SNMP UEFA ---"]
[null,"access-list 50 permit 172.16.24.24"]
[null,"access-list 50 permit 172.16.24.26"]
[null,"access-list 50 deny   any log"]
[null,"!"]
[null,"snmp-server community LFcomola RO 5"]
[null,"snmp-server community euro2016ro RO 50"]
[null,"snmp-server community iafiaRco$ RW 6"]
[null,"snmp-server contact Orange"]
[null,"snmp-server enable traps snmp authentication linkdown linkup coldstart warmstart"]
[null,"snmp-server enable traps transceiver all"]
[null,"snmp-server enable traps call-home message-send-fail server-fail"]
[null,"snmp-server enable traps tty"]
[null,"snmp-server enable traps license"]
[null,"snmp-server enable traps auth-framework sec-violation"]
[null,"snmp-server enable traps cluster"]
[null,"snmp-server enable traps config-copy"]
[null,"snmp-server enable traps config"]
[null,"snmp-server enable traps config-ctid"]
[null,"snmp-server enable traps dot1x auth-fail-vlan guest-vlan no-auth-fail-vlan no-guest-vlan"]
[null,"snmp-server enable traps energywise"]
[null,"snmp-server enable traps fru-ctrl"]
[null,"snmp-server enable traps entity"]
[null,"snmp-server enable traps event-manager"]
[null,"snmp-server enable traps ike policy add"]
[null,"snmp-server enable traps ike policy delete"]
[null,"snmp-server enable traps ike tunnel start"]
[null,"snmp-server enable traps ike tunnel stop"]
[null,"snmp-server enable traps ipsec cryptomap add"]
[null,"snmp-server enable traps ipsec cryptomap delete"]
[null,"snmp-server enable traps ipsec cryptomap attach"]
[null,"snmp-server enable traps ipsec cryptomap detach"]
[null,"snmp-server enable traps ipsec tunnel start"]
[null,"snmp-server enable traps ipsec tunnel stop"]
[null,"snmp-server enable traps ipsec too-many-sas"]
[null,"snmp-server enable traps power-ethernet police"]
[null,"snmp-server enable traps cpu threshold"]
[null,"snmp-server enable traps rep"]
[null,"snmp-server enable traps vstack"]
[null,"snmp-server enable traps bridge newroot topologychange"]
[null,"snmp-server enable traps stpx inconsistency root-inconsistency loop-inconsistency"]
[null,"snmp-server enable traps syslog"]
[null,"snmp-server enable traps vtp"]
[null,"snmp-server enable traps vlancreate"]
[null,"snmp-server enable traps vlandelete"]
[null,"snmp-server enable traps flash insertion removal"]
[null,"snmp-server enable traps port-security"]
[null,"snmp-server enable traps envmon fan shutdown supply temperature status"]
[null,"snmp-server enable traps stackwise"]
[null,"snmp-server enable traps errdisable"]
[null,"snmp-server enable traps mac-notification change move threshold"]
[null,"snmp-server enable traps vlan-membership"]
[null,"snmp-server host 10.103.4.20 LFcomola"]
[null,"!"]
[null,"aaa authentication login default group radius"]
[null,"aaa authorization auth-proxy default group radius "]
[null,"aaa accounting auth-proxy default start-stop group radius"]
[null,"!"]
[null,"ip device tracking"]
[null,"ip admission watch-list expiry-time 1"]
[null,"ip admission max-login-attempts 100"]
[null,"ip admission proxy http login expired page file flash:wired-failed.html"]
[null,"ip admission proxy http login page file flash:wired-login.html"]
[null,"ip admission proxy http success page file flash:wired-success.html"]
[null,"ip admission proxy http failure page file flash:wired-failed.html"]
[null,"ip admission name ADIPSYS proxy http"]
[]
[null,"fallback profile WEB-AUTH"]
[null,"ip access-group PRE_WEBAUTH_POLICY in"]
[null,"ip admission ADIPSYS"]
[null,"!"]
[null,"ip access-list extended PRE_WEBAUTH_POLICY"]
[null,"permit udp any any eq bootps"]
[null,"permit ip any host 194.2.0.20"]
[null,"permit ip any host 194.2.0.50"]
[null,"permit tcp any host 192.168.38.xx eq 8080"]
[null,"deny   ip any any"]
[null,"!"]
[null,"banner motd ^"]
[null,"Ce systeme et ses equipements sont la propriete de Orange SA."]
[null,"Toute tentative d acces sans autorisation de Orange expose"]
[null,"ses auteurs a des poursuites penales (code penal L.323-1 et suivants)"]
[]
[null,"           **********************************************************"]
[null,"           *                       !! Bonjour !!                    *"]
[null,"           *                  Bienvenue sur le reseau               *"]
[null,"           *                     EURO 2016 SAS                      *"]
[null,"           *                                                        *"]
[null,"           *                        |        |                      *"]
[null,"           *                       |||      |||                     *"]
[null,"           *                    .:|||||:..:|||||:.                  *"]
[null,"           *                    Cisco Sytems, Inc.                  *"]
[null,"           **********************************************************"]
[null,"^"]
[null,"###findeconfig###"]

{"sheet":"Service","index":3,"n_rows":14,"n_cols":12,"rows_kept":14}
["Nom du site",null,null,"VLAN","VLAN name",null,"Switch reference","Port","Type",null,null,"Interface Choice"]
["BOR",null,null,201,"Wired_OrgOFF_INT",null,"WS-C2960S-F48TS-L",48,"Fast",null,null,"Shutdown"]
["LEN",null,null,202,"Wired_ACR_INT",null,"WS-C2960S-F48FPS-L ",48,"Fast",null,null,"Corporate"]
["LIL",null,null,203,"Wired_TVC_INT",null,"WS-C3560CG-8PC-S",8,"Gigabit",null,null,"Printer Org"]
["LYO",null,null,204,"Wired_NoDisc_INT",null,"WS-C2960S-F24TS-L",24,"Fast",null,null,"CiscoAP"]
["MAR",null,null,205,"Printer_INT",null,"WS-C2960S-F24PS-L ",24,"Fast",null,null,"RuckusAP"]
["NIC",null,null,206,"Wired_Misc_INT",{"$nulls":6},"VoiceConf"]
["PAR",null,null,"251","Wireless_Org_INT",{"$nulls":6},"VideoConf"]
["SDE",null,null,"328","Wired_CORP",{"$nulls":6},"Printer 3rd party"]
["STE",null,null,"360","Voice_CORP",{"$nulls":6},"Dedicated Internet Wired Org"]
["TOU",null,null,"391","Printer_CORP",{"$nulls":6},"Dedicated Internet Wired ACR"]
["IBC",null,null,"395","Network_Mgmt_CORP",{"$nulls":6},"Dedicated Internet Wired TVC"]
[{"$nulls":3},"396","CiscoWAP_Mgmt_CORP",{"$nulls":6},"Dedicated Internet Wired NoDisclaimer"]
[{"$nulls":3},"397","RuckusWAP_Network_Mgmt_CORP",{"$nulls":6},"Dedicated Internet Wired Misc"]