adminmpmcz/patchcenter
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases 2 Wiki Activity

Commit Graph

  • 0dc9b07edd audit _run: retry sans sudo accepte sortie vide (pas containers/failed = OK, pas erreur) Admin MPCZ 2026-04-15 12:18:35 +0200
  • 1a1af9e28a Qualys sync multi-pass: filtres SRV/server/SED/SEI/EMV pour couvrir tags heterogenes Admin MPCZ 2026-04-15 12:17:02 +0200
  • 2746188f1c audit _run: detection sudo refused plus robuste (accent-insensitive, sudo:, no tty) Admin MPCZ 2026-04-15 12:12:22 +0200
  • 2f880da275 Top bar: affiche display_name (Prenom NOM) + (AD) si LDAP + login en gris Admin MPCZ 2026-04-15 12:00:41 +0200
  • 67fa28a2af Fix LDAP auto-provision: colonne display_name (pas full_name) Admin MPCZ 2026-04-15 11:52:20 +0200
  • f013aaaab6 LDAP auto-provision: user cree DESACTIVE par defaut + role viewer (admin doit l'activer) Admin MPCZ 2026-04-15 11:46:22 +0200
  • 53d4f71607 LDAP: restriction groupe AD + auto-provisioning users (sans permissions) Admin MPCZ 2026-04-15 11:45:33 +0200
  • d72d4a711f Add test_ldap: diagnostic LDAP/AD step-by-step (bind admin + search user + bind user) Admin MPCZ 2026-04-15 11:21:50 +0200
  • bfc996e50e Add SANEF Qualys Tags V3 ref (docx + xlsx) dans deploy/docs/ Admin MPCZ 2026-04-15 10:57:46 +0200
  • adc8d40df3 Add gen_tags_v3_docx: genere un Word avec tableaux Tag V3/RuleType/Valeur/Couleur Admin MPCZ 2026-04-15 10:56:30 +0200
  • 52e859ba08 Sidebar: ajoute liens Tags V3 (vue / catalogue / gap) sous Qualys > Tags Admin MPCZ 2026-04-15 10:23:58 +0200
  • d508072969 Add /qualys/tagsv3/catalog: page de reference nom/type/QQL/couleur par categorie Admin MPCZ 2026-04-15 10:20:41 +0200
  • ec7712f0c9 Add module Qualys Tags V3: catalogue YAML + service + pages /qualys/tagsv3 et /gap Admin MPCZ 2026-04-15 10:14:10 +0200
  • 105a756008 Qualys hostname: retour a priorite name (sauf IP/localhost/vide), fqdn/netbios en fallback Admin MPCZ 2026-04-15 01:38:56 +0200
  • c7291d3e6d Qualys _parse_assets_full: hostname FQDN > NetBIOS > name (fix aussi cette fonction) Admin MPCZ 2026-04-15 01:20:28 +0200
  • 71260e20c3 Qualys sync: hostname depuis FQDN > NetBIOS > name (evite troncature display name) Admin MPCZ 2026-04-15 01:11:08 +0200
  • 7eb56bc9cd Qualys sync: filtre SRV au lieu de server (matche OS-WIN-SRV/OS-LIN-SRV DYN SANEF v3) Admin MPCZ 2026-04-15 01:00:37 +0200
  • 8e085564ac Fix audit.html: {% endif %} manquant pour le bloc active_jobs Admin MPCZ 2026-04-15 00:32:20 +0200
  • 7480bbf5ac audit _run: fallback sans sudo si sudoers refuse bash -c (commandes read-only OK sans root) Admin MPCZ 2026-04-15 00:26:42 +0200
  • 2a10ec55ab Page /audit: liste les audits en cours avec bouton Reprendre Admin MPCZ 2026-04-15 00:22:22 +0200
  • 3c4244597c Audit: ThreadPoolExecutor avec parallel borne (evite saturation DB/PSMP) Admin MPCZ 2026-04-15 00:20:12 +0200
  • 48efb07b49 Audit exclusion: match par nom ET code (form UI envoie l'un ou l'autre) Admin MPCZ 2026-04-15 00:14:39 +0200
  • 1cc8d42e4a Add fill_domaine_from_weekly: extrait servers.domaine depuis col D des sheets S02..S16 Admin MPCZ 2026-04-15 00:07:55 +0200
  • ca4f779e48 Fix audit exclusion: NULL domaine = exclu (evite audit de 690 serveurs non-tagges) Admin MPCZ 2026-04-15 00:05:16 +0200
  • 69cedff0fe Fix audit exclusion: match sur servers.domaine OR d.name OR d.code, NULL = non-exclu Admin MPCZ 2026-04-14 23:59:36 +0200
  • 596276441b audit realtime: route via PSMP CyberArk si ssh_method=ssh_psmp Admin MPCZ 2026-04-14 23:48:00 +0200
  • 8729b8470b test_psmp: derivation Fernet exacte identique a secrets_service Admin MPCZ 2026-04-14 23:46:23 +0200
  • cdf976a9e8 test_psmp: dechiffre Fernet via secrets_service (mot de passe stocke chiffre) Admin MPCZ 2026-04-14 23:45:05 +0200
  • 1fc24f4684 Add test_psmp: diagnostic connexion PSMP CyberArk step-by-step Admin MPCZ 2026-04-14 23:41:05 +0200
  • 9b3840bfa6 audit realtime: FQDN base = retour direct (plus de check port 22), boucle suffixes uniquement en fallback Admin MPCZ 2026-04-14 23:30:47 +0200
  • 09e92c8b70 Fix export CSV: colonne zone (alias dans SELECT = 'zone' pas 'zone_name') Admin MPCZ 2026-04-14 23:26:30 +0200
  • 41f5e07e72 Add link_servers_applications: lie servers->applications depuis 2 Excel (ponderation 3/2/1) Admin MPCZ 2026-04-14 22:56:57 +0200
  • fe6b05353c Add fill_responsables_by_probability: agregation ponderee des 2 Excel + contacts + domain_env Admin MPCZ 2026-04-14 22:49:29 +0200
  • b2b1b05028 tag_obsolete_os: normalise 'eol' -> 'obsolete' (filtre unifie) Admin MPCZ 2026-04-14 22:35:51 +0200
  • 47a4917d96 tag_obsolete_os: etend CHECK licence_support pour accepter 'obsolete' Admin MPCZ 2026-04-14 22:32:53 +0200
  • 0be4849ef2 Fix filtres zone/licence perdus lors tri/pagination/export CSV Admin MPCZ 2026-04-14 22:25:57 +0200
  • 5883ba5cc4 Add import_sanef_applications: import Solutions Applicatives iTop (nom/etat/responsable/admin) Admin MPCZ 2026-04-14 22:20:40 +0200
  • e2b984c2c4 Servers: filtre licence (active/obsolete/els/sans licence) Admin MPCZ 2026-04-14 22:17:09 +0200
  • 2a11a27675 Add link_prod_nonprod: lie v[rtd]XXX <-> v[pi]XXX dans server_correspondance Admin MPCZ 2026-04-14 22:16:17 +0200
  • 52cb7b4cfc Add enrich_servers_from_qualys: pousse fqdn/os_family/os_version/domain_ltd depuis Qualys Admin MPCZ 2026-04-14 21:54:36 +0200
  • 8317dcd36b Add fill_ips_by_dns: fallback IP via DNS multi-suffix pour serveurs sans IP Admin MPCZ 2026-04-14 21:53:50 +0200
  • 5e9625764a Dashboard: try/except autour KPIs DMZ/patch_history (resilient si table absente) Admin MPCZ 2026-04-14 21:47:41 +0200
  • 6ec1c4575d Dashboard: KPIs DMZ + patching 2026 depuis patch_history Admin MPCZ 2026-04-14 21:45:36 +0200
  • ec82a7cd1e align_dmz: auto-detecte sheet (Histo-2025 prioritaire) + index DMZ via header Admin MPCZ 2026-04-14 21:39:14 +0200
  • 38756fbfd6 Add import_patch_history_xlsx: lit sheets hebdo S02..S52, detecte lignes vertes Admin MPCZ 2026-04-14 21:30:43 +0200
  • 90b03ec20b align_dmz: reconnait Exposition internet/Expo indirecte (SANEF) Admin MPCZ 2026-04-14 21:20:42 +0200
  • 4300eb1210 Fix zone filter: subquery sur zone_id (count query n'a pas le JOIN zones) Admin MPCZ 2026-04-14 21:17:56 +0200
  • 3211b81e60 Servers: filtre zone (liste zones + DMZ + Sans zone) Admin MPCZ 2026-04-14 21:15:49 +0200
  • 197296b811 Add align_dmz_from_ayoub: tag servers.zone_id DMZ depuis colonne DMZ Excel Admin MPCZ 2026-04-14 20:55:04 +0200
  • 55d1c2b43d Add cleanup_referentiel + --overwrite sur fill_emails Admin MPCZ 2026-04-14 20:51:16 +0200
  • 1ce72a8757 fill_emails: fallback prenom.nom@sanef.com si pas de match contact Admin MPCZ 2026-04-14 20:46:42 +0200
  • 7f7b04e775 fill_ssh_method: etend CHECK pour accepter rdp_local/rdp_psmp/ssh_psmp + cleanup_domains standalone Admin MPCZ 2026-04-14 20:45:31 +0200
  • a39a4866f3 Add fill_ssh_method_by_default: modes connexion SANEF par OS+env Admin MPCZ 2026-04-14 20:43:51 +0200
  • 6c8e2a3339 Add fill_emails_from_contacts: complete domain_environments emails depuis contacts Admin MPCZ 2026-04-14 20:41:29 +0200
  • 9f4d7707ef DNS fill timeout via thread + tag_obsolete_os supporte els/obsolete separement Admin MPCZ 2026-04-14 20:37:46 +0200
  • 7f6ccc763b Add tag_obsolete_os: licence_support=obsolete pour OS EOL (RHEL 5/6/7, Win 2008/2012, Debian 8-10, etc.) Admin MPCZ 2026-04-14 20:36:19 +0200
  • 0cfdab7c61 Add fill_domain_ltd_by_dns: resolution DNS multi-suffix pour cas residuels Admin MPCZ 2026-04-14 20:31:41 +0200
  • b315cee98b Add fill_domain_ltd_by_prefix: convention SANEF vp/vi=sanef.groupe, vr/vt/vd=sanef-rec.fr Admin MPCZ 2026-04-14 20:21:29 +0200
  • de41b66a34 Add import_domain_ltd_from_qualys: extrait domain_ltd depuis Qualys FQDN Admin MPCZ 2026-04-14 20:18:06 +0200
  • 489524ac38 import_ips_from_qualys: enleve suffixe /32 inet Admin MPCZ 2026-04-14 20:15:52 +0200
  • 154faceaff Fix: qualys_assets.ip_address est inet pas text, cast en text Admin MPCZ 2026-04-14 20:15:05 +0200
  • e072adb717 Add import_ips_from_qualys: fallback IPs depuis Qualys pour serveurs sans IP iTop Admin MPCZ 2026-04-14 20:13:11 +0200
  • c8a5f73616 import_sanef_ips: csv.reader par indice (evite conflit Nom/Nom duplique) Admin MPCZ 2026-04-14 20:10:51 +0200
  • a66e0d853e Fix schema server_ips: ip_type au lieu de is_primary, VRF/GW/MASK dans description Admin MPCZ 2026-04-14 19:55:42 +0200
  • c905ab6db3 import_sanef_ips: CAST inet + hostname multi-source + skip doublons Admin MPCZ 2026-04-14 19:50:40 +0200
  • b66ef0a122 Fix SQLAlchemy: CAST(:ip AS inet) au lieu de :ip::inet (conflit avec bind marker) Admin MPCZ 2026-04-14 19:48:42 +0200
  • e2f61af818 Add import_ips_from_assets: lit colonne IP directe des CSV VM/physical Admin MPCZ 2026-04-14 19:47:37 +0200
  • 78ad32045e import_databases: lire Systeme->Nom en priorite (Serveur->Nom vide pour VM) Admin MPCZ 2026-04-14 19:39:35 +0200
  • 7c56725f6e Add import_sanef_databases: table server_databases + import CSV iTop Admin MPCZ 2026-04-14 19:36:11 +0200
  • 2379a2fdc0 align_from_ayoub: dedoublonne les domaines case/accent-insensitive Admin MPCZ 2026-04-14 19:32:28 +0200
  • 991f4dd6dc align_from_ayoub: dry-run affiche les domains/envs/paires a creer Admin MPCZ 2026-04-14 19:26:26 +0200
  • 331e6b2946 align_from_ayoub: normalise Environnement (production->Production, Test 1->Test) Admin MPCZ 2026-04-14 19:25:10 +0200
  • b6bb7e2edd align_from_ayoub: switch vers jointure (auto-cree domains/envs/de) Admin MPCZ 2026-04-14 19:20:36 +0200
  • c16a360cdd Add align_from_ayoub: alignement servers depuis Excel Planning Patching Admin MPCZ 2026-04-14 19:17:25 +0200
  • 9048a87397 Drop NOT NULL sur servers.etat pour accepter les physiques non-lifecycle Admin MPCZ 2026-04-14 19:06:05 +0200
  • a366427daf Fix: iTop exporte 2 colonnes Etat (lifecycle+condition), prendre la 1ere Admin MPCZ 2026-04-14 19:05:08 +0200
  • 3c6e10944e Servers list: SELECT s.environnement (colonne iTop) au lieu de e.name legacy Admin MPCZ 2026-04-14 18:58:24 +0200
  • 56fc1eaa7c Servers filters: option (Sans etat)/(Sans env) pour NULL Admin MPCZ 2026-04-14 18:53:51 +0200
  • ce2ac219db Fix: lire Etat en priorite (Status toujours Production, inutile) + condition -> NULL Admin MPCZ 2026-04-14 18:51:57 +0200
  • 56f91ca9a8 Add list_csv_etats: liste valeurs distinctes Etat/Status/Environnement Admin MPCZ 2026-04-14 18:49:29 +0200
  • 1c2d0b958e Etat/Environnement dropdowns alignes strict iTop SANEF Admin MPCZ 2026-04-14 18:48:30 +0200
  • 753d4076c9 Migre etat vers labels iTop verbatim (Production, Nouveau, etc.) Admin MPCZ 2026-04-14 18:40:56 +0200
  • 242641a085 Add import_environnement: colonne environnement + import CSV iTop verbatim Admin MPCZ 2026-04-14 18:33:40 +0200
  • 0f031b2150 fix_etat_extend: ajoute pret et tests au mapping iTop Admin MPCZ 2026-04-14 18:32:00 +0200
  • fd748ce3fd Add fix_etat_extend: extend etat CHECK + remap from iTop CSV Admin MPCZ 2026-04-14 18:15:25 +0200
  • 987e21377b Add move_esxi_extras + move_chassis scripts Admin MPCZ 2026-04-14 18:09:26 +0200
  • d3b7fc2e22 Add move_vcenters script + kind column on hypervisors Admin MPCZ 2026-04-14 17:48:46 +0200
  • 0a00c401d7 Add hypervisors table + move script (preserves VM->hypervisor link via vcenter_vm_name) Admin MPCZ 2026-04-14 17:40:24 +0200
  • 683a86346d Add SANEF physical/hypervisor import script Admin MPCZ 2026-04-14 17:34:33 +0200
  • 7b87074faa Qualys page size 100 Admin MPCZ 2026-04-14 16:58:03 +0200
  • d15db654d4 Qualys: activation keys lazy (no API on page load if cache empty) Admin MPCZ 2026-04-14 16:24:45 +0200
  • 49b1865d13 Qualys page size 250 (lower timeout risk) Admin MPCZ 2026-04-14 16:19:29 +0200
  • 67287b8256 Qualys: cancel button for ongoing refresh Admin MPCZ 2026-04-14 16:12:44 +0200
  • 69aeb0e77a Qualys agents page: sync route + drop LOWER (citext is case-insensitive) Admin MPCZ 2026-04-14 16:09:56 +0200
  • 1bfdb16bfb Qualys: actkeys cache 24h + refresh timeout 600s Admin MPCZ 2026-04-14 16:07:25 +0200
  • 07775a385f Qualys activation keys: short timeout (5s) Admin MPCZ 2026-04-14 16:07:03 +0200
  • 347ea53c27 Qualys skip threshold: 5 min -> 40 min Admin MPCZ 2026-04-14 15:56:41 +0200
  • ec90a4a9d1 Qualys: reduce refresh page size to 500 Admin MPCZ 2026-04-14 15:55:35 +0200
  • 6db58952ec Qualys refresh: early exit if no stale assets (< 5 min) Admin MPCZ 2026-04-14 15:48:41 +0200
  • f66d728d2d Qualys timeout 300s for bulk hostasset search Admin MPCZ 2026-04-14 15:37:50 +0200