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 21:26:12 +00:00
09e92c8b70 Fix export CSV: colonne zone (alias dans SELECT = 'zone' pas 'zone_name')
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 20:56:40 +00:00
41f5e07e72 Add link_servers_applications: lie servers->applications depuis 2 Excel (ponderation 3/2/1)
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 20:49:13 +00:00
fe6b05353c Add fill_responsables_by_probability: agregation ponderee des 2 Excel + contacts + domain_env
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 20:35:33 +00:00
b2b1b05028 tag_obsolete_os: normalise 'eol' -> 'obsolete' (filtre unifie)
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 20:32:34 +00:00
47a4917d96 tag_obsolete_os: etend CHECK licence_support pour accepter 'obsolete'
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 20:25:39 +00:00
0be4849ef2 Fix filtres zone/licence perdus lors tri/pagination/export CSV
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 20:20:24 +00:00
5883ba5cc4 Add import_sanef_applications: import Solutions Applicatives iTop (nom/etat/responsable/admin)
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 20:16:50 +00:00
e2b984c2c4 Servers: filtre licence (active/obsolete/els/sans licence)
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 20:15:59 +00:00
2a11a27675 Add link_prod_nonprod: lie v[rtd]XXX <-> v[pi]XXX dans server_correspondance
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 19:54:18 +00:00
52cb7b4cfc Add enrich_servers_from_qualys: pousse fqdn/os_family/os_version/domain_ltd depuis Qualys
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 19:53:32 +00:00
8317dcd36b Add fill_ips_by_dns: fallback IP via DNS multi-suffix pour serveurs sans IP
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 19:47:23 +00:00
5e9625764a Dashboard: try/except autour KPIs DMZ/patch_history (resilient si table absente)
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 19:45:18 +00:00
6ec1c4575d Dashboard: KPIs DMZ + patching 2026 depuis patch_history
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 19:38:55 +00:00
ec82a7cd1e align_dmz: auto-detecte sheet (Histo-2025 prioritaire) + index DMZ via header
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 19:30:25 +00:00
38756fbfd6 Add import_patch_history_xlsx: lit sheets hebdo S02..S52, detecte lignes vertes
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 19:20:24 +00:00
90b03ec20b align_dmz: reconnait Exposition internet/Expo indirecte (SANEF)
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 19:17:39 +00:00
4300eb1210 Fix zone filter: subquery sur zone_id (count query n'a pas le JOIN zones)
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 19:15:32 +00:00
3211b81e60 Servers: filtre zone (liste zones + DMZ + Sans zone)
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 18:54:46 +00:00
197296b811 Add align_dmz_from_ayoub: tag servers.zone_id DMZ depuis colonne DMZ Excel
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 18:50:57 +00:00
55d1c2b43d Add cleanup_referentiel + --overwrite sur fill_emails