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 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
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 18:46:24 +00:00
1ce72a8757 fill_emails: fallback prenom.nom@sanef.com si pas de match contact
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 18:45:12 +00:00
7f7b04e775 fill_ssh_method: etend CHECK pour accepter rdp_local/rdp_psmp/ssh_psmp + cleanup_domains standalone
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 18:43:33 +00:00
a39a4866f3 Add fill_ssh_method_by_default: modes connexion SANEF par OS+env
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 18:41:12 +00:00
6c8e2a3339 Add fill_emails_from_contacts: complete domain_environments emails depuis contacts
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 18:37:27 +00:00
9f4d7707ef DNS fill timeout via thread + tag_obsolete_os supporte els/obsolete separement
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 18:36:02 +00:00
7f6ccc763b Add tag_obsolete_os: licence_support=obsolete pour OS EOL (RHEL 5/6/7, Win 2008/2012, Debian 8-10, etc.)
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 18:31:22 +00:00
0cfdab7c61 Add fill_domain_ltd_by_dns: resolution DNS multi-suffix pour cas residuels
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 18:21:15 +00:00
b315cee98b Add fill_domain_ltd_by_prefix: convention SANEF vp/vi=sanef.groupe, vr/vt/vd=sanef-rec.fr
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 18:17:48 +00:00
de41b66a34 Add import_domain_ltd_from_qualys: extrait domain_ltd depuis Qualys FQDN
adminmpmcz pushed to main at adminmpmcz/patchcenter 2026-04-14 18:15:35 +00:00
489524ac38 import_ips_from_qualys: enleve suffixe /32 inet