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

Commit Graph

  • 89f069ddcc import_plan_patching: skip lignes avec date future (cellules coloriees a l avance) main Admin MPCZ 2026-04-17 12:44:27 +0000
  • 2bf2fa5042 patch_history: tolere parametres vides dans les filtres (week=, source=, etc.) Admin MPCZ 2026-04-17 12:42:58 +0000
  • 402ed36407 import_ldap_group_users : ne reactive plus les users desactives manuellement Admin MPCZ 2026-04-17 12:32:46 +0000
  • 81227833c1 Add link_patch_history_intervenants : lie patch_history.intervenant_name -> users.id (FK) Admin MPCZ 2026-04-17 12:31:40 +0000
  • 7ec7c49c34 import_ldap_group_users : fallback UPN/sam@sanef.com si mail absent, inclut comptes admin sans mail Admin MPCZ 2026-04-17 12:26:12 +0000
  • 2a4c785535 Add import_ldap_group_users + FK users.contact_id + contacts.ldap_dn Admin MPCZ 2026-04-17 12:16:24 +0000
  • 2ab2ceabba Historique patching : filtres OS/zone/domaine/intervenant + colonnes table Admin MPCZ 2026-04-17 12:10:45 +0000
  • 14f809335e Add tool import_plan_patching_xlsx : historique 2025+2026 (vert = patche) Admin MPCZ 2026-04-17 11:56:32 +0000
  • cfb9cf865c Register patch_history router in main.py Admin MPCZ 2026-04-17 09:41:14 +0000
  • 4b1794d4d1 Add page Historique patching : vue unifiee import xlsx + campagnes + quickwin Admin MPCZ 2026-04-17 08:47:25 +0000
  • c9890a274f Add tools/import_planning_xlsx.py : import patch_planning depuis xlsx Ayoub Admin MPCZ 2026-04-17 08:32:56 +0000
  • e2fb34f115 Sync SANEF : audit_service + schema.sql + data deploy + gitignore sql-db-snapshot-20260417 db-snapshot-20260417 MOUTAOUAKIL-ext Khalid 2026-04-17 09:20:57 +0200
  • 1c661e2dc5 qualys_tags: respect qualys_bypass_proxy flag Admin MPCZ 2026-04-17 00:28:57 +0200
  • 617bf94e31 Qualys agents sync: optims perf majeures (~3-5x plus rapide) Admin MPCZ 2026-04-16 23:34:51 +0200
  • 55cd35eaf1 import_applications_ioda: gestion conflits nom_court (UNIQUE existant) Admin MPCZ 2026-04-16 14:21:37 +0200
  • 34c8025b56 import_applications_ioda: cast str() pour cellules non-string (int) Admin MPCZ 2026-04-16 14:19:29 +0200
  • b55e8d4e26 Import IODA applications + table qualys_missing_servers Admin MPCZ 2026-04-16 13:59:53 +0200
  • f1a1ca9c7b Qualys Tags V3: unescape entites XML dans ruleText/name Admin MPCZ 2026-04-15 15:40:04 +0200
  • 79a2cc896e Qualys diff: format ISO sans microsec YYYY-MM-DDTHH:MM:SSZ (compat API QPS) Admin MPCZ 2026-04-15 14:28:57 +0200
  • 7924e64616 Qualys diff: filtre 'updated' (searchable) au lieu de 'lastCheckedIn' (non recunu API) Admin MPCZ 2026-04-15 14:06:27 +0200
  • 8b212df7a1 Qualys 'sans agent': match via server_id (couvre alias hostname Qualys != iTop) Admin MPCZ 2026-04-15 13:54:07 +0200
  • 245777fd46 Qualys agents: exclut Win10/11/Workstation de la liste 'Sans agent' Admin MPCZ 2026-04-15 13:49:05 +0200
  • 4a5a1f6716 Qualys: bouton Sync complete vert (#22c55e) bien visible Admin MPCZ 2026-04-15 13:42:58 +0200
  • 6824fee081 Qualys deploy UI: ActivationId/CustomerId masques (type password) + toggle œil Admin MPCZ 2026-04-15 13:37:15 +0200
  • a3a1ec7e6d Qualys deploy: bouton 'Sauvegarder ces valeurs' (ActivationId/Customer/Uri persistes) Admin MPCZ 2026-04-15 13:34:24 +0200
  • 0ebf72d789 Qualys diff sync: sauve le timestamp DES LE DEBUT (resilient si annulation) Admin MPCZ 2026-04-15 13:29:36 +0200
  • 5b6e113792 Qualys deploy: filtre s.os_family=linux + retire dropdown OS du UI Admin MPCZ 2026-04-15 13:18:09 +0200
  • 206cc813f6 Qualys deploy: simplifie UI = ActivationId Linux uniquement (Windows hidden, persiste backend) Admin MPCZ 2026-04-15 13:14:23 +0200
  • 55d08921f9 Qualys deploy: persiste activation_ids/customer/uri en secrets + selection auto Linux/Windows Admin MPCZ 2026-04-15 13:12:15 +0200
  • f59c6dcbdb Qualys deploy: 2 dropdowns ActivationId Linux et Windows (separes) Admin MPCZ 2026-04-15 13:04:34 +0200
  • 0095f7914f Qualys deploy: POD SANEF = QG1 par defaut (pas QG2) Admin MPCZ 2026-04-15 13:00:45 +0200
  • 2972baca1f Qualys deploy: dropdown ActivationId depuis API + ServerUri auto-deduit URL Qualys Admin MPCZ 2026-04-15 12:53:18 +0200
  • 935c8003b4 Qualys sync: retry 3x avec backoff sur erreurs transitoires proxy/reseau Admin MPCZ 2026-04-15 12:44:49 +0200
  • 9e03fd84c0 Qualys tags page: bandeau sync en cours + bouton Resync API disable Admin MPCZ 2026-04-15 12:39:40 +0200
  • 48249d1c82 Qualys agents page: bandeau sync en cours + boutons sync desactives + bouton Annuler Admin MPCZ 2026-04-15 12:37:49 +0200
  • 1dc7560f44 Qualys tags resync: message clair si busy + erreur API detaillee Admin MPCZ 2026-04-15 12:35:34 +0200
  • a62f9a4146 Qualys sync dual mode: diff (rapide, lastCheckedIn) + full (complet) Admin MPCZ 2026-04-15 12:33:48 +0200
  • 55f81de986 Qualys sync: fallback matching par IP integrer si hostname ne match pas Admin MPCZ 2026-04-15 12:25:27 +0200
  • 36c638c8ce Add link_qualys_by_ip: lie qualys_assets a servers via IP quand hostname mismatch (cas node3->vdameasxt3) Admin MPCZ 2026-04-15 12:22:04 +0200
  • 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