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

Commit Graph

  • 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
  • d24afa37b2 Qualys refresh: skip assets updated within last 5 minutes Admin MPCZ 2026-04-14 15:32:01 +0200
  • d779426118 Bump Qualys page size back to 1000 Admin MPCZ 2026-04-14 15:21:04 +0200
  • 71f83d5d4f Qualys refresh: threading lock + 409 if already running Admin MPCZ 2026-04-14 15:20:17 +0200
  • e3bcf8fcc1 Qualys refresh: sync route so blocking requests run in threadpool Admin MPCZ 2026-04-14 15:18:16 +0200
  • 67f123e9f5 Qualys refresh: pagination + per-row savepoint to isolate errors Admin MPCZ 2026-04-14 15:13:48 +0200
  • a422894f83 Sync Qualys FQDN to servers + use fqdn first for DNS resolution Admin MPCZ 2026-04-14 15:00:40 +0200
  • 92175992f8 Qualys: tagName + CONTAINS (API field, not UI syntax) Admin MPCZ 2026-04-14 14:53:54 +0200
  • a19281a771 Qualys filter: CONTAINS instead of EQUALS for tag Admin MPCZ 2026-04-14 14:48:29 +0200
  • a331d16a12 Qualys filter: tags.name instead of tagName Admin MPCZ 2026-04-14 14:47:48 +0200
  • faa267c3ff Add SANEF contacts import script Admin MPCZ 2026-04-14 14:22:03 +0200
  • 612f3c7cea Add SANEF IPs import script (from Interface réseau export) Admin MPCZ 2026-04-14 13:57:27 +0200
  • b72f1244dd Use autocommit mode to persist inserts immediately Admin MPCZ 2026-04-14 13:43:25 +0200
  • c6113bc537 Drop ON CONFLICT (no unique constraint on hostname) Admin MPCZ 2026-04-14 13:39:11 +0200
  • 2215067987 Use savepoints per row to isolate failing inserts Admin MPCZ 2026-04-14 13:38:16 +0200
  • f0fe6eba81 Fix etat mapping: use only production/implementation/stock/obsolete/eol Admin MPCZ 2026-04-14 13:34:07 +0200
  • 42fb16d67e Fix import script: auto-detect FK tables before truncate Admin MPCZ 2026-04-14 13:31:00 +0200
  • 338c0ecc0f Add SANEF asset CSV import script Admin MPCZ 2026-04-14 13:24:42 +0200
  • 053c9a3b59 Add Voir detail button and results route for realtime audit Admin MPCZ 2026-04-14 13:10:23 +0200
  • 747e883d22 Smart DNS suffix order based on hostname convention (r=rec, p/i=prod) Admin MPCZ 2026-04-14 13:02:24 +0200
  • 53545585f0 Configurable DNS suffixes + 2s socket timeout for faster resolve Admin MPCZ 2026-04-14 12:58:54 +0200
  • da1042fef4 Fix SSH key: read PEM content from settings + ssh_key_default_user Admin MPCZ 2026-04-14 12:56:09 +0200
  • 8dba0706b0 Filter Qualys agent refresh on tag name=server Admin MPCZ 2026-04-14 12:18:43 +0200
  • 3d61293172 Add demo DB dump for deployment Admin MPCZ 2026-04-14 11:43:50 +0200
  • 5db5feebe1 Add requirements.txt for deployment Admin MPCZ 2026-04-14 11:38:58 +0200
  • 677f621c81 Admin applications + correspondance cleanup + tools presentation DSI Admin MPCZ 2026-04-13 21:11:58 +0200
  • caa2be71a4 Misc: servers page (application + equivalent), campagne tweaks Admin MPCZ 2026-04-12 18:51:36 +0200
  • a706e240ca Patching: exclusions + correspondance prod<->hors-prod + validations Admin MPCZ 2026-04-12 18:51:30 +0200
  • ba0bff0f6e Remove: safe-patching (remplace par QuickWin) + audit-full Admin MPCZ 2026-04-12 18:51:17 +0200
  • 3f47fea8e6 Audit: jobs background paralleles + progression live Admin MPCZ 2026-04-12 18:51:05 +0200
  • 5ea4100f4c Qualys: deploy agent background jobs + upgrade/downgrade + AJAX overlays Admin MPCZ 2026-04-12 18:50:56 +0200
  • 8479d7280e Users/Contacts: workflow profils + LDAP + sync iTop + etat aligne Admin MPCZ 2026-04-12 18:50:43 +0200
  • 4fa5f67c32 Qualys agents: bouton Rafraichir + cron 6h Admin MPCZ 2026-04-11 21:56:59 +0200
  • 6411774004 Fix deploy page: NoneType sort + version extraite du nom fichier dans dropdown Admin MPCZ 2026-04-11 21:39:59 +0200
  • 3d053019e6 Deploiement Agent Qualys complet Admin MPCZ 2026-04-11 21:26:45 +0200
  • b7b0965722 Fix: qualys/agents - convert rows to dicts pour compatibilite Jinja2 map/attribute Admin MPCZ 2026-04-11 21:07:44 +0200
  • 3964dd2c89 Fix: page qualys/agents - try/except sur get_activation_keys et get_agents_summary Admin MPCZ 2026-04-11 21:04:47 +0200
  • 1f0c00c1dc Suppression menu Specifiques de la navigation Admin MPCZ 2026-04-11 21:01:32 +0200
  • 32d602975b Sync contacts: role depuis Teams iTop (SecOps→referent_technique, iPOP→responsable_applicatif) Admin MPCZ 2026-04-11 14:33:12 +0200
  • 3707308063 Sync iTop: responsables domaine par fréquence + emails Admin MPCZ 2026-04-11 14:22:29 +0200
  • 73cec814b6 Fix: typologies iTop sans org_id (DomaineApplicatif, Environnement, Zone, DomainLdap) Admin MPCZ 2026-04-11 14:01:20 +0200
  • df4cd3be6f Sync iTop: import emails responsable serveur/domaine dans servers + domain_environments Admin MPCZ 2026-04-11 13:55:25 +0200
  • 29e5a28a27 Fix: KeyError 'updated' → 'servers_updated' dans sync_to route Admin MPCZ 2026-04-11 13:36:23 +0200
  • 6683813743 Export iTop: sync responsable serveur et responsable domaine Admin MPCZ 2026-04-11 13:26:51 +0200
  • d8a526368e Refonte synchro iTop bidirectionnelle complète Admin MPCZ 2026-04-11 13:19:10 +0200
  • 1ff6b3fd4d Sync to iTop: export referentiel (environnements, domaines, zones) + serveurs Admin MPCZ 2026-04-11 04:17:22 +0200
  • 66eeff99e8 Sync iTop: import IPs dans server_ips + traceback sur erreur sync Admin MPCZ 2026-04-11 03:54:45 +0200
  • 322fa71324 Fix sync iTop: champs corrects (patch_window, contacts.role, ssh_method constraint, rollback) Admin MPCZ 2026-04-11 03:20:04 +0200
  • be6c5158b8 Sync iTop: tous les champs custom (tier, connexion, ssh_user, patch_freq, pref_jour/heure, domain_ldap, excludes) Admin MPCZ 2026-04-11 02:28:39 +0200
  • 3b5f0992b3 Refonte sync iTop: import complet contacts/domaines/envs/zones/serveurs Admin MPCZ 2026-04-11 01:58:31 +0200
  • ba48e75b68 Fix matching iTop: compare aussi par hostname court (sans .mpcz.fr) Admin MPCZ 2026-04-11 00:23:33 +0200
  • db74111d58 Sync iTop enrichie: responsable_serveur + responsable_domaine + creation VMs Admin MPCZ 2026-04-11 00:14:09 +0200
  • 53e59e7305 Sync iTop: ajout responsable serveur (contacts_list) + commentaire/description Admin MPCZ 2026-04-10 23:23:48 +0200
  • f73ea25d5d Referentiel: boutons sync iTop (import/export) + messages status Admin MPCZ 2026-04-10 23:17:58 +0200
  • acf20c5890 Service iTop REST: synchro bidirectionnelle serveurs + contacts Admin MPCZ 2026-04-10 23:11:32 +0200
  • 33dd3a779e Fix: GET /audit/realtime redirige vers dashboard au lieu de crash int_parsing Admin MPCZ 2026-04-10 22:49:05 +0200
  • 4801d805b1 Fix: ip_type='primary' au lieu de 'ipv4' dans server_ips Admin MPCZ 2026-04-10 20:57:14 +0200
  • b190c04147 Fix: hosts manquants + no-cache sur resultats audit (evite re-POST) Admin MPCZ 2026-04-10 20:38:44 +0200
  • 1be5e867dc Fix: server_ips colonne ip_address au lieu de ip Admin MPCZ 2026-04-10 20:18:59 +0200
  • 369ca7e5a3 Audit: mise a jour table servers avec IP, OS, FQDN depuis resultats audit Admin MPCZ 2026-04-10 20:10:27 +0200
  • 16315ab3b5 Fix SSH audit: lire settings DB au lieu de hardcoder user/key/suffixes Admin MPCZ 2026-04-10 20:01:15 +0200
  • c2f3d669eb Mode Demo/Reel au login + base patchcenter_demo Admin MPCZ 2026-04-10 19:39:35 +0200