Announcement

Collapse
No announcement yet.

NDO Tools Module

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

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

    Leave a comment:


  • raphaelt
    replied
    Hi,

    This was fixed on svn by wistof. (http://community.centreon.com/issues/1536)
    package will be ok on next release.

    Leave a comment:


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

    Leave a comment:


  • mrcoffee
    replied
    Cool! Chouette! Will try this one and give you feedback if I run into something interesting.
    Roderick

    Leave a comment:


  • raphaelt
    replied
    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.

    Leave a comment:


  • sugiggs
    replied
    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?

    Leave a comment:


  • magicbret
    replied
    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.

    Leave a comment:


  • raphaelt
    replied
    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

    Leave a comment:


  • tosage
    replied
    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:

    Leave a comment:


  • tntteam
    replied
    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

    Leave a comment:


  • clifden
    replied
    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).

    Leave a comment:


  • tosage
    replied
    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

    Leave a comment:


  • jingchao.zhao
    replied
    Hi wistof,
    Could NDO Tools can list the service's check latency?
    I want to purge the check latency information.

    Leave a comment:


  • emmjott
    replied
    Very nice piece of software!
    Helped me a lot today cleaning out my NDO database which contained some orphaned hosts, which made Centreon show me wrong numbers!
    I'd recommend NDOTools to be integrated in Centreon by default ;-)

    Leave a comment:


  • wistof
    replied
    Si tu as d'autres idées

    Leave a comment:

Working...
X