{"id":1161,"date":"2026-07-23T16:42:42","date_gmt":"2026-07-23T14:42:42","guid":{"rendered":"https:\/\/communaute-omr.fr\/?p=1161"},"modified":"2026-07-23T16:42:42","modified_gmt":"2026-07-23T14:42:42","slug":"preambule","status":"publish","type":"post","link":"https:\/\/communaute-omr.fr\/?p=1161","title":{"rendered":"Pr\u00e9ambule"},"content":{"rendered":"\n

Dans cette suite d\u2019article nous allons regarder la structure des donn\u00e9es de centreon.<\/p>\n\n\n\n

<\/span>But des articles<\/span><\/h1>\n\n\n\n

Nous allons voir :<\/p>\n\n\n\n

    \n
  • Les diff\u00e9rentes relations \u00e0 l\u2019int\u00e9rieur des databases\u00a0\u00a0:<\/li>\n\n\n\n
  • Les tables de centreon (El\u00e9ments de configuration)<\/li>\n\n\n\n
  • Les tables centreon_storage (Historisation de la supervision)<\/li>\n\n\n\n
  • Entre les databases\u00a0:<\/li>\n\n\n\n
  • Relation entre les tables de centreon et centreon_storage<\/li>\n<\/ul>\n\n\n\n

    Nous ne rentrerons pas dans le d\u00e9tail de toutes les tables mais nous nous int\u00e9resserons aux tables principales pour comprendre le fonctionnement de base de l\u2019application.<\/p>\n\n\n\n

    <\/span>Convention de nommage<\/span><\/h1>\n\n\n\n

    Afin de faciliter la lecture des requ\u00eates et d\u2019\u00e9viter les ambigu\u00eft\u00e9s pour MySQL, pour les diff\u00e9rentes jointures, nous utiliserons un trigramme en alias de la table.<\/p>\n\n\n\n

    Quelques exemples :<\/p>\n\n\n\n

      \n
    • HTR\u00a0: Host Template Relation<\/li>\n\n\n\n
    • HST\u00a0: hosts<\/li>\n\n\n\n
    • HTPL\u00a0: Host Template<\/li>\n\n\n\n
    • HTR\u00a0: Host Template Relation<\/li>\n\n\n\n
    • SVC\u00a0: Service<\/li>\n\n\n\n
    • STR\u00a0: Service Template Relation<\/li>\n\n\n\n
    • STPL\u00a0: Service Templates<\/li>\n\n\n\n
    • \u2026<\/li>\n<\/ul>\n\n\n\n\n\n\n\n

      <\/span>Forces en pr\u00e9sence<\/span><\/h1>\n\n\n\n

      <\/span>Databases<\/span><\/h2>\n\n\n\n

      <\/span>Centreon<\/span><\/h3>\n\n\n\n

      La database centreon est la base de donn\u00e9es qui contient tous les \u00e9l\u00e9ments de configuration<\/p>\n\n\n\n

      Point Important : Toutes les tables sont au singulier<\/p>\n\n\n\n

      <\/span>Centreon_storage<\/span><\/h3>\n\n\n\n

      C\u2019est la database qui contient tout l\u2019historique de supervision.<\/p>\n\n\n\n

      Elle permet 2 choses :<\/p>\n\n\n\n

        \n
      • Afficher l\u2019\u00e9tat de la supervision dans la console depuis les menus<\/li>\n\n\n\n
      • Monitoring (Supervision)<\/li>\n\n\n\n
      • Custom Views (Vues personnalis\u00e9es)<\/li>\n\n\n\n
      • DashBoard (Tableaux de bord)<\/li>\n\n\n\n
      • MBI ( Si le module est install\u00e9)<\/li>\n<\/ul>\n\n\n\n

        Point important : toutes les tables sont au pluriel<\/p>\n\n\n\n

        <\/span>Bilan<\/span><\/h1>\n\n\n\n

        Toutes les tables au singulier sont des tables de configuration et toutes les tables au pluriel seront d\u00e9vou\u00e9es \u00e0 la r\u00e9tention des m\u00e9triques.<\/p>\n","protected":false},"excerpt":{"rendered":"

        Dans cette suite d\u2019article nous allons regarder la structure des donn\u00e9es de centreon. But des articles Nous allons voir : Nous ne rentrerons pas dans le d\u00e9tail de toutes les tables mais nous nous int\u00e9resserons aux tables principales pour comprendre le fonctionnement de base de l\u2019application. Convention de nommage Afin de faciliter la lecture des requ\u00eates et d\u2019\u00e9viter les ambigu\u00eft\u00e9s pour MySQL, pour les diff\u00e9rentes jointures, nous utiliserons un trigramme en alias de la table. Quelques exemples :<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[38,5,1],"tags":[],"class_list":["post-1161","post","type-post","status-publish","format-standard","hentry","category-bdd","category-centreon","category-non-classe"],"_links":{"self":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/1161","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1161"}],"version-history":[{"count":2,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/1161\/revisions"}],"predecessor-version":[{"id":1163,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/1161\/revisions\/1163"}],"wp:attachment":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1161"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}