Pierre & Lumière adminmpmcz
0 Followers · 0 Following
Repositories
4
 Projects Packages Public Activity Starred Repositories
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 18:14:47 +00:00
154faceaff Fix: qualys_assets.ip_address est inet pas text, cast en text
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 18:12:52 +00:00
e072adb717 Add import_ips_from_qualys: fallback IPs depuis Qualys pour serveurs sans IP iTop
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 18:10:33 +00:00
c8a5f73616 import_sanef_ips: csv.reader par indice (evite conflit Nom/Nom duplique)
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 17:55:24 +00:00
a66e0d853e Fix schema server_ips: ip_type au lieu de is_primary, VRF/GW/MASK dans description
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 17:50:22 +00:00
c905ab6db3 import_sanef_ips: CAST inet + hostname multi-source + skip doublons
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 17:48:23 +00:00
b66ef0a122 Fix SQLAlchemy: CAST(:ip AS inet) au lieu de :ip::inet (conflit avec bind marker)
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 17:47:18 +00:00
e2f61af818 Add import_ips_from_assets: lit colonne IP directe des CSV VM/physical
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 17:39:17 +00:00
78ad32045e import_databases: lire Systeme->Nom en priorite (Serveur->Nom vide pour VM)
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 17:35:53 +00:00
7c56725f6e Add import_sanef_databases: table server_databases + import CSV iTop
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 17:32:10 +00:00
2379a2fdc0 align_from_ayoub: dedoublonne les domaines case/accent-insensitive
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 17:26:07 +00:00
991f4dd6dc align_from_ayoub: dry-run affiche les domains/envs/paires a creer
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 17:24:52 +00:00
331e6b2946 align_from_ayoub: normalise Environnement (production->Production, Test 1->Test)
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 17:20:19 +00:00
b6bb7e2edd align_from_ayoub: switch vers jointure (auto-cree domains/envs/de)
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 17:17:07 +00:00
c16a360cdd Add align_from_ayoub: alignement servers depuis Excel Planning Patching
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 17:05:46 +00:00
9048a87397 Drop NOT NULL sur servers.etat pour accepter les physiques non-lifecycle
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 17:04:51 +00:00
a366427daf Fix: iTop exporte 2 colonnes Etat (lifecycle+condition), prendre la 1ere
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 16:58:07 +00:00
3c6e10944e Servers list: SELECT s.environnement (colonne iTop) au lieu de e.name legacy
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 16:53:34 +00:00
56fc1eaa7c Servers filters: option (Sans etat)/(Sans env) pour NULL
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 16:51:39 +00:00
ce2ac219db Fix: lire Etat en priorite (Status toujours Production, inutile) + condition -> NULL
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 16:49:10 +00:00
56f91ca9a8 Add list_csv_etats: liste valeurs distinctes Etat/Status/Environnement