Announcement

Collapse
No announcement yet.

NDO Tools Module

Collapse
This is a sticky topic.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    Hello,

    I think no but perhaps that SQL request should be :

    Service :

    SELECT `nagios_hosts`.`alias`,`nagios_hosts`.`display_nam e`, `nagios_servicestatus`.`check_command`,`nagios_ser vicestatus`.`execution_time`
    FROM `nagios_servicestatus`,`nagios_services`,`nagios_h osts`
    WHERE `nagios_servicestatus`.`service_object_id`=`nagios _services`.`service_object_id` AND `nagios_services`.`host_object_id`=`nagios_hosts`. `host_object_id`
    ORDER BY `nagios_servicestatus`.`execution_time` DESC

    Host :

    SELECT `nagios_hosts`.`alias`,`nagios_hosts`.`display_nam e`,`nagios_hoststatus`.`output`,`nagios_hoststatus `.`execution_time`
    FROM `nagios_hoststatus`,`nagios_hosts`
    WHERE `nagios_hoststatus`.`host_object_id`=`nagios_hosts `.`host_object_id`
    ORDER BY `nagios_hoststatus`.`execution_time` DESC
    Ubuntu Server 10.04.4 x64 - Centreon 2.1.13 - Nagios 3.2.0
    Modules : ImportCSV 0.99rc5 - OCS2Cent 1.2.1 - Centreon-Gmap 1.2 - ndotools 0.2 - Centreon-NagVis 2.2b with NagVis 1.5.10

    Comment


    • #17
      Thank you very much for this module.

      Here is a suggestion:
      On the "tables" page, transform each table name toa link in order to browse the given table with field order and also cleaning (for example for ghost host or services).
      Sysadmin
      OS: Ubuntu / Debian / RHEL
      Nagios env: 1 centreon 2.2.1, 5 Nagios on remote sites, NDOutil v1.4.9
      Own development: status map based on NDO, service status by categories, misc reports on nagios conf, mediawiki linked to centreon and vis-versa

      Comment


      • #18
        Hello wistof,

        Une suggestion d'amélioration pour le module :

        Avoir un check latency moyen par nom de service.

        Exemple, j'ai développé mon_check_perso.sh, je le mets sur 40 hosts, j'aimerais avoir le délai moyen du check.

        Ca permettrait de différencier un host qui réponds lentement à une requête d'un plugin qui est lent à tourner.

        Thanks

        Comment


        • #19
          Bonne idée +1
          Si tu as besoin tntteam en attendant j'ai posté deux roquettes SQL sur le forum qui te permette de voir tes check avec leur délai d’exécution
          Si ça t’intéresse et que tu ne les retrouve pas je peux te les reposter :rolleyes:
          Ubuntu Server 10.04.4 x64 - Centreon 2.1.13 - Nagios 3.2.0
          Modules : ImportCSV 0.99rc5 - OCS2Cent 1.2.1 - Centreon-Gmap 1.2 - ndotools 0.2 - Centreon-NagVis 2.2b with NagVis 1.5.10

          Comment


          • #20
            Hello,

            J'avais un peu de temps a perdre

            Delai moyen, min, max et quantité par check_* :
            Code:
            SELECT REPLACE(LEFT(`nagios_servicestatus`.`check_command`, LOCATE('!', CONCAT(`nagios_servicestatus`.`check_command`,'!'))),'!','') AS 'Check', AVG(`nagios_servicestatus`.`execution_time`) AS 'AVG', MIN(`nagios_servicestatus`.`execution_time`) AS 'MIN', MAX(`nagios_servicestatus`.`execution_time`) AS 'MAX', COUNT(`nagios_servicestatus`.`execution_time`) AS 'COUNT'
            FROM `nagios_servicestatus`,`nagios_services`
            WHERE `nagios_servicestatus`.`service_object_id`=`nagios_services`.`service_object_id`
            GROUP BY REPLACE(LEFT(`nagios_servicestatus`.`check_command`, LOCATE('!', CONCAT(`nagios_servicestatus`.`check_command`,'!'))),'!','')
            ORDER BY AVG(`nagios_servicestatus`.`execution_time`) DESC
            Je suis presque sur que les puristes du SQL vont hurlé a cause des manipulations sur `nagios_servicestatus`.`check_command` :twisted: mais j'ai pas trouvé mieux

            A toi de jouer maintenant Wistof
            Raphael
            --
            Bi Intel(R) Xeon(TM) CPU 3.06GHz - 3Gb ram
            Debian
            Nagios® Core™ Version 3.2.1 - Nagios Plugins 1.4.14 - NDO 1.4b9 patché
            Centreon 2.3.4 - Syslog Module 1.3.2 - StatusMap Module 2.5 - NDO Tools Module 0.4 SVN - Nagvis
            Beta tester : centreon-engine - centreon-broker

            Comment


            • #21
              Wistof,

              Pourrait-tu rajouter un sous-menu Latency, afin de faire apparaitre les valeurs de check latency ;-)

              J'ai repris la requête de tosage (;-) merci au passage) qui ne se faisait que sur execution_time.

              Code:
              SELECT `nagios_hosts`.`alias`,`nagios_hosts`.`display_name`, `nagios_servicestatus`.`check_command`,`nagios_servicestatus`.`latency`
              FROM `nagios_servicestatus`,`nagios_services`,`nagios_hosts`
              WHERE `nagios_servicestatus`.`service_object_id`=`nagios_services`.`service_object_id` AND `nagios_services`.`host_object_id`=`nagios_hosts`. `host_object_id`
              ORDER BY `nagios_servicestatus`.`latency` DESC
              Un grand merci en tout cas pour cet outil.
              Ubuntu server 10.04 LTS 64 Bits - Haute dispo 4 serveurs centraux (réplication MySQL + VIP + Rsync)
              Nagios 3.3.1 | Centreon 2.3.9 | Centreon-Broker 2.1.1 | 2000 hôtes - 5000 services | 6 Remote Pollers

              Dev : CES 2.2 - Centengine - Centreon 2.4.1

              Comment


              • #22
                I'm Having duplicated issue

                which table should I purge?

                what data will I lost if purge the table? after I purge, what should I do next?

                Comment


                • #23
                  Hi,

                  As said on ICR,

                  Purge all data and then restart nagios via GUI (Configuration -> Nagios -> checkbox : Restart Nagios)
                  ndo is just a temp database between Nagios and Centreon. Centreon use it to do tactical view but it's not a real storage base.

                  A new version of NDO is available on svn (http://svn.modules.centreon.com/ndo-tools/) with Check command latency and notion of poller.
                  Raphael
                  --
                  Bi Intel(R) Xeon(TM) CPU 3.06GHz - 3Gb ram
                  Debian
                  Nagios® Core™ Version 3.2.1 - Nagios Plugins 1.4.14 - NDO 1.4b9 patché
                  Centreon 2.3.4 - Syslog Module 1.3.2 - StatusMap Module 2.5 - NDO Tools Module 0.4 SVN - Nagvis
                  Beta tester : centreon-engine - centreon-broker

                  Comment


                  • #24
                    Cool! Chouette! Will try this one and give you feedback if I run into something interesting.
                    Roderick
                    Centos 6.2 - Nagios 3.4.1 - Centreon 2.3.8 - NDO 1.5.2 - Centreon Syslog 1.4.1 - nagios status map - www.r71.nl www.360viewpoint.nl
                    StatusMap Module - NDO Tools Module - ImportCSV Module - SNMP-UI Module

                    Comment


                    • #25
                      Just wanted to mention that the 0.4 package seems to be missing the time.png icon.
                      Thanks for this awesome module.

                      Comment


                      • #26
                        Hi,

                        This was fixed on svn by wistof. (http://community.centreon.com/issues/1536)
                        package will be ok on next release.
                        Raphael
                        --
                        Bi Intel(R) Xeon(TM) CPU 3.06GHz - 3Gb ram
                        Debian
                        Nagios® Core™ Version 3.2.1 - Nagios Plugins 1.4.14 - NDO 1.4b9 patché
                        Centreon 2.3.4 - Syslog Module 1.3.2 - StatusMap Module 2.5 - NDO Tools Module 0.4 SVN - Nagvis
                        Beta tester : centreon-engine - centreon-broker

                        Comment


                        • #27
                          Thanks so much for this module, it proved very useful when I had duplicate entries due to renaming a poller.

                          Comment

                          Working...
                          X