<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="fr">
	<id>http://wiki.les-noulot.fr/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=24.206.98.112</id>
	<title>Wiki-noulot - Contributions de l’utilisateur [fr]</title>
	<link rel="self" type="application/atom+xml" href="http://wiki.les-noulot.fr/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=24.206.98.112"/>
	<link rel="alternate" type="text/html" href="http://wiki.les-noulot.fr/index.php?title=Sp%C3%A9cial:Contributions/24.206.98.112"/>
	<updated>2026-11-17T08:38:32Z</updated>
	<subtitle>Contributions de l’utilisateur</subtitle>
	<generator>MediaWiki 1.33.0</generator>
	<entry>
		<id>http://wiki.les-noulot.fr/index.php?title=Centreon&amp;diff=406</id>
		<title>Centreon</title>
		<link rel="alternate" type="text/html" href="http://wiki.les-noulot.fr/index.php?title=Centreon&amp;diff=406"/>
		<updated>2023-04-19T14:02:59Z</updated>

		<summary type="html">&lt;p&gt;24.206.98.112 : /* Réaffecter les vues d'un user vers un autre */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;=Centreon=&lt;br /&gt;
&lt;br /&gt;
==Les valeurs par défaut des ACKNOWLEDGE dans les widgets==&lt;br /&gt;
&lt;br /&gt;
Il est possible de cocher des cases par défaut (sticky, notify...) en éditant le fichier suivant:&lt;br /&gt;
&lt;br /&gt;
 /usr/share/centreon/www/widgets/service-monitoring/src/acknowledge.ihtml&lt;br /&gt;
 La différence est l'ajout du mot &amp;quot;checked&amp;quot;.&lt;br /&gt;
&lt;br /&gt;
==Vérification config==&lt;br /&gt;
 /usr/sbin/centengine -v /etc/centreon-engine/centengine.cfg&lt;br /&gt;
&lt;br /&gt;
==RRDTools==&lt;br /&gt;
&lt;br /&gt;
 Check fichier rrdfile:&lt;br /&gt;
 rrdtool &amp;quot;nom du fichier .rrd&amp;quot;&lt;br /&gt;
&lt;br /&gt;
 log : &lt;br /&gt;
 tailf /var/log/centreon-broker/central-master-rrd.log&lt;br /&gt;
&lt;br /&gt;
 Taille des fichiers de rétention des Graphiques&lt;br /&gt;
 Configuration =&amp;gt; Centreon =&amp;gt; configuration =&amp;gt; Output&lt;br /&gt;
 Maximum size of file : 104857600&lt;br /&gt;
&lt;br /&gt;
==Check interface LAN windows==&lt;br /&gt;
&lt;br /&gt;
Permet de lister vos interfaces Windows&lt;br /&gt;
 /usr/lib64/nagios/plugins/centreon_plugins.pl --plugin=os::windows::snmp::plugin --hostname=X.X.X.X --snmp-version='2c' --snmp-community='XXX' --mode list-interfaces&lt;br /&gt;
&lt;br /&gt;
Vous pourrez ensuite superviser les interfaces via leur ID ou leur nom.&lt;br /&gt;
&lt;br /&gt;
Voici par exemple comment remonter le trafic d'une interface en utilisant son nom:&lt;br /&gt;
 /usr/lib64/nagios/plugins/centreon_plugins.pl --plugin=os::windows::snmp::plugin --hostname=X.X.X.X --snmp-version='2c' --snmp-community='XXX' --mode interfaces --name --interface  &lt;br /&gt;
 'ethernet_7' --add-traffic&lt;br /&gt;
&lt;br /&gt;
Vous pouvez remonter le traffic toutes les interfaces avec une seule et même en commande en ne spécifiant ni l'ID ni le nom.&lt;br /&gt;
Vous pouvez également utiliser des regexp dans le nom pour en remonter plusieurs:&lt;br /&gt;
 /usr/lib64/nagios/plugins/centreon_plugins.pl --plugin=os::windows::snmp::plugin --hostname=X.X.X.X --snmp-version='2c' --snmp-community='XXX' --mode interfaces --name --interface &lt;br /&gt;
 'ethernet_*' --add-traffic&lt;br /&gt;
&lt;br /&gt;
==Changer le owner des vue custum==&lt;br /&gt;
 use centreon;&lt;br /&gt;
 select * from custom_views&lt;br /&gt;
 Verifier le n° de la view dans Centreon en passant la sourie sur l'onglet de la vue.&lt;br /&gt;
 select * from custom_view_user_relation where custom_view_id='ID_VIEW';&lt;br /&gt;
 update custom_view_user_relation set locked='0' where custom_view_id='320' and user_id='ID_NEW_USER';&lt;br /&gt;
 update custom_view_user_relation set is_owner='1' where custom_view_id='320' and user_id='ID_NEW_USER'; (user_id=19 &amp;gt;adm-snoulot)&lt;br /&gt;
&lt;br /&gt;
===Réaffecter les vues d'un user vers un autre===&lt;br /&gt;
Lui supprime les vues.&lt;br /&gt;
&lt;br /&gt;
Lister les vues du user&lt;br /&gt;
&lt;br /&gt;
       select V.custom_view_id, V.name from custom_views as V&lt;br /&gt;
       inner join custom_view_user_relation as C on C.custom_view_id = V.custom_view_id&lt;br /&gt;
       where C.user_id = &amp;lt;&amp;lt;ID_USER&amp;gt;&amp;gt; and is_owner = 1;&lt;br /&gt;
&lt;br /&gt;
Lister les vues du nouvel user&lt;br /&gt;
&lt;br /&gt;
       select V.custom_view_id, V.name from custom_views as V&lt;br /&gt;
       inner join custom_view_user_relation as C on C.custom_view_id = V.custom_view_id&lt;br /&gt;
       where C.user_id = &amp;lt;&amp;lt;ID_USER&amp;gt;&amp;gt;;&lt;br /&gt;
&lt;br /&gt;
Comparer les 2 listes et exclure les vues présentes des 2 cotés et leurs changer le owner avec la procédure précédente.&lt;br /&gt;
Pour les autres utiliser la requête suivante:&lt;br /&gt;
&lt;br /&gt;
       update custom_view_user_relation set user_id='&amp;lt;&amp;lt;New_user_ID&amp;gt;&amp;gt;', locked='0', is_owner='1' &lt;br /&gt;
       where custom_view_id in (&amp;lt;&amp;lt;liste des custom_view_id séparés par des ','&amp;gt;&amp;gt;) and user_id='&amp;lt;&amp;lt;old_USER_ID&amp;gt;&amp;gt;';&lt;br /&gt;
&lt;br /&gt;
==Problème lié à des métriques erronées==&lt;br /&gt;
&lt;br /&gt;
Certains services étaient associés a des métriques incohérentes (métrique de cpu associé à un contrôle de disque, ou une métrique nommée à l'aide d'une apostrophe). &lt;br /&gt;
Ces métriques ne contient également aucune données. &lt;br /&gt;
Toutes ces incohérences étaient la source du dysfonctionnement des graphiques.&lt;br /&gt;
&lt;br /&gt;
Voici la méthode utilisée pour résoudre le problème :&lt;br /&gt;
 &lt;br /&gt;
 Se connecter au serveur MySQL et lister les métriques du service posant problème : &lt;br /&gt;
 Pour un host&lt;br /&gt;
 mysql&amp;gt; select metric_id, metric_name from index_data i, metrics m where i.host_name = 'FRCCEISSUP01' and i.service_description = 'DISK-Usage' and i.id = m.index_id;&lt;br /&gt;
 &lt;br /&gt;
 Pour tout les host&lt;br /&gt;
 mysql&amp;gt;select i.host_name, metric_id, metric_name from index_data i, metrics m where i.service_description = 'DISK-Usage' and i.id = m.index_id and metric_name like '\'';&lt;br /&gt;
 *************************** 1. row ***************************&lt;br /&gt;
 metric_id: 35987&lt;br /&gt;
 metric_name: /var/lib/centreon&lt;br /&gt;
 *************************** 2. row ***************************&lt;br /&gt;
 metric_id: 35986&lt;br /&gt;
 metric_name: /var/lib/mysql&lt;br /&gt;
 *************************** 3. row ***************************&lt;br /&gt;
 metric_id: 29686&lt;br /&gt;
 metric_name: /&lt;br /&gt;
 *************************** 4. row ***************************&lt;br /&gt;
 metric_id: 29687&lt;br /&gt;
 metric_name: /boot&lt;br /&gt;
 *************************** 5. row ***************************&lt;br /&gt;
 metric_id: 29688&lt;br /&gt;
 metric_name: /dev/shm&lt;br /&gt;
 *************************** 6. row ***************************&lt;br /&gt;
 metric_id: 38748&lt;br /&gt;
 metric_name: '&lt;br /&gt;
 6 rows in set (0.00 sec)&lt;br /&gt;
&lt;br /&gt;
Pour chaque métrique, vérifier que chacune contient des données à l'aide de la requête suivante (où ID METRIC correspond au champs metric_id précédent) :&lt;br /&gt;
 mysql&amp;gt; SELECT max(ctime) FROM data_bin WHERE id_metric = 'ID METRIC' ;&lt;br /&gt;
&lt;br /&gt;
Si le requête ne renvoie aucune donnée, ou si la métrique se nomme basiquement 'apostrophe&amp;quot;, la supprimer comme ci-dessous :&lt;br /&gt;
 mysql&amp;gt; update metrics set to_delete = '1' where metric_id = 'ID METRIC' ;&lt;br /&gt;
 Query OK, 1 row affected (0.00 sec)&lt;br /&gt;
 Rows matched: 1 Changed: 1 Warnings: 0&lt;br /&gt;
&lt;br /&gt;
Ensuite redémarrer le service cbd pour prendre en compte la suppression.&lt;br /&gt;
&lt;br /&gt;
 # /etc/init.d/cbd restart&lt;br /&gt;
 Stopping cbd_central-rrd: [ OK ]&lt;br /&gt;
 Stopping cbd_central-broker: [ OK ]&lt;br /&gt;
 Starting cbd_central-rrd: [ OK ]&lt;br /&gt;
 Starting cbd_central-broker: [ OK ]&lt;br /&gt;
&lt;br /&gt;
==Trouver un graphe erreur Centreon.==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Retourne ID service  (collone ID)&lt;br /&gt;
&lt;br /&gt;
 select * from centreon_storage.index_data where host_name like 'FRCCEISSUP04'; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Retourne les lignes du service (si ' supprimer la ligne) (ID = index_id)&lt;br /&gt;
&lt;br /&gt;
 Select * from centreon_storage.metrics where index_id like '4530'; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Requette graphe disk KO &lt;br /&gt;
&lt;br /&gt;
Affiche toutes les entrées avec une ' dans le nom&lt;br /&gt;
&lt;br /&gt;
 select * from centreon_storage.metrics where metric_name = &amp;quot;'&amp;quot;; &lt;br /&gt;
&lt;br /&gt;
===Clapi===&lt;br /&gt;
====Liste des objets et actions Centreon-Clapi v 1.3.1====&lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
!Objet !! Désignation !! Désignation   &lt;br /&gt;
|-&lt;br /&gt;
!   !! English !! Français&lt;br /&gt;
|-&lt;br /&gt;
|ACL||Access List||Liste d'accès&lt;br /&gt;
|-&lt;br /&gt;
|ACLACTION||Actions Access||Gestion des accès sur les actions&lt;br /&gt;
|-&lt;br /&gt;
|ACLGROUP||Access Groups||Gestion des groupe d'accès&lt;br /&gt;
|-&lt;br /&gt;
|ACLMENU||Menus Access||Gestion des accès aux menus&lt;br /&gt;
|-&lt;br /&gt;
|ACLRESOURCE||Ressources Access||Gestion des accès aux ressources&lt;br /&gt;
|-&lt;br /&gt;
|CG||Contact Groups||Groupes de contacts&lt;br /&gt;
|-&lt;br /&gt;
|CGICFG||cgi Nagios||cgi Nagios&lt;br /&gt;
|-&lt;br /&gt;
|CMD||Commands||Commandes&lt;br /&gt;
|-&lt;br /&gt;
|CONTACT||Contacts / Users||Contacts / Utilisateurs&lt;br /&gt;
|-&lt;br /&gt;
|CONTACTTPL||Contact Template||Modèles de contact&lt;br /&gt;
|-&lt;br /&gt;
|HC||Hosts Catégories||Catégories d'hôtes&lt;br /&gt;
|-&lt;br /&gt;
|HG||Hosts Groups||Groupes d'hôtes&lt;br /&gt;
|-&lt;br /&gt;
|HOST||Hosts||Hôtes&lt;br /&gt;
|-&lt;br /&gt;
|HTPL||Hosts Template||Modèle d'hôtes&lt;br /&gt;
|-&lt;br /&gt;
|INSTANCE||Poller||Collecteur&lt;br /&gt;
|-&lt;br /&gt;
|LDAP||Ldap||Ldap&lt;br /&gt;
|-&lt;br /&gt;
|NAGIOSCFG||nagios.cfg Nagios||nagios.cfg Nagios&lt;br /&gt;
|-&lt;br /&gt;
|NDO2DBCFG||ndo2db.cfg NDOutils||ndo2db.cfg NDOutils&lt;br /&gt;
|-&lt;br /&gt;
|NDOMODCFG||ndomod.cfg NDOutils||ndomod.cfg NDOutils&lt;br /&gt;
|-&lt;br /&gt;
|RESOURCECFG||Resources Nagios||Ressources Nagios&lt;br /&gt;
|-&lt;br /&gt;
|SC||Services Catégories||Catégories de services&lt;br /&gt;
|-&lt;br /&gt;
|SERVICE||Services||Services&lt;br /&gt;
|-&lt;br /&gt;
|SG||Services Groups||Groupes de services&lt;br /&gt;
|-&lt;br /&gt;
|STPL||Services Template||Modèle de services&lt;br /&gt;
|-&lt;br /&gt;
|TIMEPERIOD||Time periods||Périodes temporelles&lt;br /&gt;
|}&lt;br /&gt;
 &lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
! ACTION !! OBJET SUPERVISEUR&lt;br /&gt;
|-&lt;br /&gt;
|ADD||ACLACTION, ACLGROUP, ACLMENU, ACLRESOURCE, CGICFG, CMD, CONTACT, CONTACTTPL, CG, HTPL, HOST, HG, HC, INSTANCE, LDAP, NAGIOSCFG,NDO2DBCFG, NDOMODCFG, RESOURCECFG, STPL, SERVICE, SG, SC, TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|ADDCONTACT||CG, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|ADDCONTACTGROUP||ACLGROUP, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|ADDHOST||STPL&lt;br /&gt;
|-&lt;br /&gt;
|ADDHOSTGROUP||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|ADDMEMBER||HG, HC&lt;br /&gt;
|-&lt;br /&gt;
|ADDPARENT||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|ADDRESOURCE||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|ADDSERVICE||SG, SC&lt;br /&gt;
|-&lt;br /&gt;
|ADDSERVICETEMPLATE||SC&lt;br /&gt;
|-&lt;br /&gt;
|ADDTEMPLATE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|APPLYTPL||HOST&lt;br /&gt;
|-&lt;br /&gt;
|CFGMOVE||&lt;br /&gt;
|-&lt;br /&gt;
|DEL||ACLACTION, ACLGROUP, ACLMENU, ACLRESOURCE, CGICFG, CMD, CONTACT, CONTACTTPL, CG, HTPL, HOST, HG, HC, INSTANCE, LDAP, NAGIOSCFG, NDO2DBCFG, NDOMODCFG, RESOURCECFG, STPL, SERVICE, SG, SC, TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|DELACTION||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|DELCONTACT||ACLGROUP, CG, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|DELCONTACTGROUP||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|DELEXCEPTION||TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|DELHOST||STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|DELHOSTGROUP||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|DELHOSTGROUPSERVICE||SG&lt;br /&gt;
|-&lt;br /&gt;
|DELMACRO||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|DELMEMBER||HG, HC&lt;br /&gt;
|-&lt;br /&gt;
|DELPARENT||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|DELSERVICE||SG, SC&lt;br /&gt;
|-&lt;br /&gt;
|DELSERVICETEMPLATE||SC&lt;br /&gt;
|-&lt;br /&gt;
|DELTEMPLATE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|DISABLE||CONTACT, CONTACTTPL, CG, HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|ENABLE||CONTACT, CONTACTTPL, CG, HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|GETACTION||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|GETACLGROUP||ACLACTION, ACLMENU, ACLRESOURCE, CONTACT, CONTACTTPL&lt;br /&gt;
|-&lt;br /&gt;
|GETCONTACT||ACLGROUP, CG, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|GETCONTACTGROUP||ACLGROUP, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|GETEXCEPTION||TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|GETHOSTGROUP||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|GETHOSTGROUPSERVICE||SG&lt;br /&gt;
|-&lt;br /&gt;
|GETMACRO||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|GETMEMBER||HG, HC&lt;br /&gt;
|-&lt;br /&gt;
|GETMENU||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|GETPARENT||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|GETRESOURCE||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|GETSERVICE||SG, SC&lt;br /&gt;
|-&lt;br /&gt;
|GETSERVICETEMPLATE||SC&lt;br /&gt;
|-&lt;br /&gt;
|GETTEMPLATE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|GRANT||ACLACTION, ACLMENU&lt;br /&gt;
|-&lt;br /&gt;
|LASTRELOAD||ACL&lt;br /&gt;
|-&lt;br /&gt;
|POLLERGENERATE||&lt;br /&gt;
|-&lt;br /&gt;
|POLLERLIST||&lt;br /&gt;
|-&lt;br /&gt;
|POLLERRELOAD||&lt;br /&gt;
|-&lt;br /&gt;
|POLLERESTART||&lt;br /&gt;
|-&lt;br /&gt;
|POLLERTEST||&lt;br /&gt;
|-&lt;br /&gt;
|RELOAD	ACL||&lt;br /&gt;
|-&lt;br /&gt;
|REVOKE||ACLACTION, ACLMENU&lt;br /&gt;
|-&lt;br /&gt;
|SETCONTACT||ACLGROUP, CG, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|SETCONTACTGROUP||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|SETCONTACTTEMPLATE||LDAP&lt;br /&gt;
|-&lt;br /&gt;
|SETEXCEPTION||TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|SETHOST||STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|SETHOSTGROUP||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|SETHOSTGROUPSERVICE||SG&lt;br /&gt;
|-&lt;br /&gt;
|SETINSTANCE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|SETMACRO||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|SETMEMBER||HG, HC&lt;br /&gt;
|-&lt;br /&gt;
|SETMENU||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|SETPARAM||ACLACTION, ACLGROUP, ACLMENU, ACLRESOURCE, CGICFG, CMD, CONTACT, CONTACTTPL, CG, HTPL, HOST, HG, INSTANCE, LDAP, NAGIOSCFG, NDO2DBCFG, NDOMODCFG, RESOURCECFG, STPL, SERVICE, SG, SC, TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|SETPARENT||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|SETSERVICE||SG&lt;br /&gt;
|-&lt;br /&gt;
|SETTEMPLATE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|SHOW||ACLACTION, ACLGROUP, ACLMENU, ACLRESOURCE, CGICFG, CMD, CONTACT, CONTACTTPL, CG, HTPL, HOST, HG, HC, INSTANCE, LDAP, NAGIOSCFG, NDO2DBCFG, NDOMODCFG, RESOURCECFG, STPL, SERVICE, SG, SC, TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|UNSETACLGROUP||CONTACT, CONTACTTPL&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
==BAM==&lt;br /&gt;
&lt;br /&gt;
===ClapiBAM===&lt;br /&gt;
&lt;br /&gt;
Ajout KPI &lt;br /&gt;
 centreon -u admin -p BZeGqxtGarc -o KPI -a ADD -v 'service;FRCCESGAPA01|CPU;IBM_Cognos_TM1;Weak;Minor;Major'&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Trucs==&lt;br /&gt;
&lt;br /&gt;
===Redimensionnement des Services name en configuration.===&lt;br /&gt;
&lt;br /&gt;
 Modifier la ligne 65 du fichier :&lt;br /&gt;
 /usr/share/centreon/www/include/configuration/configObject/service/listService.ihtml&lt;br /&gt;
 &lt;br /&gt;
 &amp;lt;td class=&amp;quot;ListColLeft '''resizeTitle'''&amp;quot;&amp;gt;&lt;br /&gt;
 en&lt;br /&gt;
 &amp;lt;td class=&amp;quot;ListColLeft&amp;quot;&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===Mysql recheche des status===&lt;br /&gt;
&lt;br /&gt;
====Remonte tout les hosts et services en Critique et / ou inconnue====&lt;br /&gt;
 SELECT hostgroups.hostgroup_id, hostgroups.name AS HostGroup, hosts.host_id, hosts.name AS Hosts, hosts.state, services.description AS Services, services.state &lt;br /&gt;
  FROM hostgroups, hosts_hostgroups, hosts, services &lt;br /&gt;
  WHERE hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id &lt;br /&gt;
  AND hosts_hostgroups.host_id = hosts.host_id &lt;br /&gt;
  AND services.host_id = hosts.host_id &lt;br /&gt;
  AND hosts.enabled='1' &lt;br /&gt;
  AND services.enabled='1' &lt;br /&gt;
  AND hostgroups.name = 'hg-sextant'&lt;br /&gt;
  AND hosts.state in ('2','3')&lt;br /&gt;
  OR hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id &lt;br /&gt;
  AND hosts_hostgroups.host_id = hosts.host_id &lt;br /&gt;
  AND services.host_id = hosts.host_id &lt;br /&gt;
  AND hosts.enabled='1' &lt;br /&gt;
  AND services.enabled='1' &lt;br /&gt;
  AND hostgroups.name = 'hg-sextant'&lt;br /&gt;
  AND services.state in ('2','3');&lt;br /&gt;
&lt;br /&gt;
====Remonte tout les hosts et services en Critique et / ou inconnue non Acknowledged====&lt;br /&gt;
 SELECT hostgroups.hostgroup_id, hostgroups.name AS HostGroup, hosts.host_id, hosts.name AS Hosts, hosts.state, hosts.acknowledged As Acknowledged, services.description AS Services, services.state,    &lt;br /&gt;
  services.acknowledged As Acknowledged &lt;br /&gt;
  FROM hostgroups, hosts_hostgroups, hosts, services &lt;br /&gt;
  WHERE hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id &lt;br /&gt;
  AND hosts_hostgroups.host_id = hosts.host_id &lt;br /&gt;
  AND services.host_id = hosts.host_id &lt;br /&gt;
  AND hosts.enabled='1' &lt;br /&gt;
  AND services.enabled='1' &lt;br /&gt;
  AND hostgroups.name = 'hg-sextant'&lt;br /&gt;
  AND hosts.state in ('2','3')&lt;br /&gt;
  AND hosts.acknowledged = 0&lt;br /&gt;
  OR hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id &lt;br /&gt;
  AND hosts_hostgroups.host_id = hosts.host_id &lt;br /&gt;
  AND services.host_id = hosts.host_id &lt;br /&gt;
  AND hosts.enabled='1' &lt;br /&gt;
  AND services.enabled='1' &lt;br /&gt;
  AND hostgroups.name = 'hg-sextant'&lt;br /&gt;
  AND services.state in ('2','3')&lt;br /&gt;
  AND services.acknowledged = 0;&lt;br /&gt;
&lt;br /&gt;
====Remonte les indicateurs sans downtime n'y Acknoledged====&lt;br /&gt;
  use centreon_storage;&lt;br /&gt;
&lt;br /&gt;
 /*select HOST*/&lt;br /&gt;
 select concat(count(distinct(hosts.name)),':hosts') as 'RESULT'&lt;br /&gt;
 from hosts&lt;br /&gt;
  inner join hosts_hostgroups on hosts.host_id = hosts_hostgroups.host_id&lt;br /&gt;
  inner join hostgroups on hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id&lt;br /&gt;
 where hosts.enabled=1&lt;br /&gt;
 and hosts.state != 0&lt;br /&gt;
 and hosts.acknowledged = 0&lt;br /&gt;
 and hostgroups.name = 'HG-SEXTANT'&lt;br /&gt;
 and hosts.host_id not in ( select downtimes.host_id from downtimes where actual_end_time is null and cancelled = 0 )&lt;br /&gt;
 union&lt;br /&gt;
 /*select services*/&lt;br /&gt;
 select concat(count(distinct(hosts.name)),':services') as 'RESULT'&lt;br /&gt;
 from services&lt;br /&gt;
  inner join hosts on hosts.host_id = services.host_id&lt;br /&gt;
  inner join hosts_hostgroups on services.host_id = hosts_hostgroups.host_id&lt;br /&gt;
  inner join hostgroups on hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id&lt;br /&gt;
  where&lt;br /&gt;
  hosts.enabled=1&lt;br /&gt;
  AND services.enabled=1&lt;br /&gt;
  AND services.state in (2,3)&lt;br /&gt;
  AND services.acknowledged = 0&lt;br /&gt;
  AND hostgroups.name = 'HG-SEXTANT'&lt;br /&gt;
  AND services.host_id not in ( select downtimes.host_id from downtimes where actual_end_time is null and cancelled = 0 )&lt;br /&gt;
  AND hosts.acknowledged = 0&lt;br /&gt;
  AND services.service_id != '26732';&lt;br /&gt;
&lt;br /&gt;
====Liste service template====&lt;br /&gt;
&lt;br /&gt;
 select * from service where service_register = '0';&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=====Liste service Template avec commentaire et exemple argument=====&lt;br /&gt;
&lt;br /&gt;
 select service_id,service_description,'|',service_comment,'|',command_command_id_arg &lt;br /&gt;
 from service&lt;br /&gt;
 where service_register = '0' and service_description not like 'Generic%' order by service_id ; &lt;br /&gt;
&lt;br /&gt;
=====Liste des service Template avec description des arguments=====&lt;br /&gt;
&lt;br /&gt;
 select service_id,service_description,'|',macro_description&lt;br /&gt;
 from service&lt;br /&gt;
 inner join command_arg_description&lt;br /&gt;
 on cmd_id = command_command_id&lt;br /&gt;
 where service_register = '0' and service_description not like 'Generic%' order by service_id ;&lt;br /&gt;
&lt;br /&gt;
=====Check catégorie service=====&lt;br /&gt;
&lt;br /&gt;
 SELECT service_id, service_description FROM service WHERE service_id NOT IN (SELECT service_service_id FROM service_categories_relation) AND service_register = '1';&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Clear cashe sonde swap===&lt;br /&gt;
&lt;br /&gt;
sur le poller où est testé le host, supprimer le fichier /var/lib/centreon/centplugins/remote_storage_cache_$HOST$&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Ajout Vues personnalisées===&lt;br /&gt;
&lt;br /&gt;
Récuperation widget_id&lt;br /&gt;
 select * from widgets where title like 'Proc%' ;&lt;br /&gt;
Récuperation custom_view_id &lt;br /&gt;
 select custom_view_id from widget_views where widget_id = $widget_id$ ;&lt;br /&gt;
Récuperation contact_id&lt;br /&gt;
 select contact_alias, contact_id from contact where contact_alias like '%user%';&lt;br /&gt;
Création view pour un utilisateur&lt;br /&gt;
 insert into custom_view_user_relation (custom_view_id,user_id,locked,is_owner,is_consumed)  values($custom_view_id$,$user_id$,1,0,1);&lt;br /&gt;
&lt;br /&gt;
===Liste les HG des serveurs actif===&lt;br /&gt;
&lt;br /&gt;
 select h.host_id,h.host_name,h.host_activate, HG.hg_name from host as h &lt;br /&gt;
 inner join hostgroup_relation as HR on HR.host_host_id = h.host_id&lt;br /&gt;
 inner join hostgroup as HG on HG.hg_id = HR.hostgroup_hg_id&lt;br /&gt;
 where h.host_activate = '1';&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===delock model de service===&lt;br /&gt;
&lt;br /&gt;
 select * from service where service_register = '0'  and service_description like '%';&lt;br /&gt;
 &lt;br /&gt;
 update service set service_locked=0 where service_description like '%';&lt;br /&gt;
&lt;br /&gt;
===Liste des VM pour un Datcenter===&lt;br /&gt;
&lt;br /&gt;
 /usr/lib/centreon/plugins/centreon_vmware_connector_client.pl --plugin=apps::vmware::connector::plugin --mode getmap --container='DC1_VDI' --connector-hostname localhost&lt;br /&gt;
&lt;br /&gt;
===Check des TimePeriodes en fonction d'un hoste===&lt;br /&gt;
&lt;br /&gt;
   SQL&lt;br /&gt;
 select concat( hosts.name,';',services.display_name,';check_period;',hosts.check_period) from services&lt;br /&gt;
 inner join hosts on services.host_id = hosts.host_id &lt;br /&gt;
 where services.check_period != hosts.check_period and services.check_period ='24X7;&lt;br /&gt;
&lt;br /&gt;
  Copier le résultat dans un fichier TMP.&lt;br /&gt;
 Lancer une requête CLAPI:&lt;br /&gt;
 ./ADD_Centreon.sh admin BZeGqxtGarc /tmp/tp_update.txt SERVICE setparam&lt;br /&gt;
&lt;br /&gt;
 Recharger Centreon.&lt;br /&gt;
 Faire check EZV&lt;/div&gt;</summary>
		<author><name>24.206.98.112</name></author>
		
	</entry>
	<entry>
		<id>http://wiki.les-noulot.fr/index.php?title=Centreon&amp;diff=405</id>
		<title>Centreon</title>
		<link rel="alternate" type="text/html" href="http://wiki.les-noulot.fr/index.php?title=Centreon&amp;diff=405"/>
		<updated>2023-04-19T14:02:33Z</updated>

		<summary type="html">&lt;p&gt;24.206.98.112 : /* Réaffecter les vues d'un user vers un autre */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;=Centreon=&lt;br /&gt;
&lt;br /&gt;
==Les valeurs par défaut des ACKNOWLEDGE dans les widgets==&lt;br /&gt;
&lt;br /&gt;
Il est possible de cocher des cases par défaut (sticky, notify...) en éditant le fichier suivant:&lt;br /&gt;
&lt;br /&gt;
 /usr/share/centreon/www/widgets/service-monitoring/src/acknowledge.ihtml&lt;br /&gt;
 La différence est l'ajout du mot &amp;quot;checked&amp;quot;.&lt;br /&gt;
&lt;br /&gt;
==Vérification config==&lt;br /&gt;
 /usr/sbin/centengine -v /etc/centreon-engine/centengine.cfg&lt;br /&gt;
&lt;br /&gt;
==RRDTools==&lt;br /&gt;
&lt;br /&gt;
 Check fichier rrdfile:&lt;br /&gt;
 rrdtool &amp;quot;nom du fichier .rrd&amp;quot;&lt;br /&gt;
&lt;br /&gt;
 log : &lt;br /&gt;
 tailf /var/log/centreon-broker/central-master-rrd.log&lt;br /&gt;
&lt;br /&gt;
 Taille des fichiers de rétention des Graphiques&lt;br /&gt;
 Configuration =&amp;gt; Centreon =&amp;gt; configuration =&amp;gt; Output&lt;br /&gt;
 Maximum size of file : 104857600&lt;br /&gt;
&lt;br /&gt;
==Check interface LAN windows==&lt;br /&gt;
&lt;br /&gt;
Permet de lister vos interfaces Windows&lt;br /&gt;
 /usr/lib64/nagios/plugins/centreon_plugins.pl --plugin=os::windows::snmp::plugin --hostname=X.X.X.X --snmp-version='2c' --snmp-community='XXX' --mode list-interfaces&lt;br /&gt;
&lt;br /&gt;
Vous pourrez ensuite superviser les interfaces via leur ID ou leur nom.&lt;br /&gt;
&lt;br /&gt;
Voici par exemple comment remonter le trafic d'une interface en utilisant son nom:&lt;br /&gt;
 /usr/lib64/nagios/plugins/centreon_plugins.pl --plugin=os::windows::snmp::plugin --hostname=X.X.X.X --snmp-version='2c' --snmp-community='XXX' --mode interfaces --name --interface  &lt;br /&gt;
 'ethernet_7' --add-traffic&lt;br /&gt;
&lt;br /&gt;
Vous pouvez remonter le traffic toutes les interfaces avec une seule et même en commande en ne spécifiant ni l'ID ni le nom.&lt;br /&gt;
Vous pouvez également utiliser des regexp dans le nom pour en remonter plusieurs:&lt;br /&gt;
 /usr/lib64/nagios/plugins/centreon_plugins.pl --plugin=os::windows::snmp::plugin --hostname=X.X.X.X --snmp-version='2c' --snmp-community='XXX' --mode interfaces --name --interface &lt;br /&gt;
 'ethernet_*' --add-traffic&lt;br /&gt;
&lt;br /&gt;
==Changer le owner des vue custum==&lt;br /&gt;
 use centreon;&lt;br /&gt;
 select * from custom_views&lt;br /&gt;
 Verifier le n° de la view dans Centreon en passant la sourie sur l'onglet de la vue.&lt;br /&gt;
 select * from custom_view_user_relation where custom_view_id='ID_VIEW';&lt;br /&gt;
 update custom_view_user_relation set locked='0' where custom_view_id='320' and user_id='ID_NEW_USER';&lt;br /&gt;
 update custom_view_user_relation set is_owner='1' where custom_view_id='320' and user_id='ID_NEW_USER'; (user_id=19 &amp;gt;adm-snoulot)&lt;br /&gt;
&lt;br /&gt;
===Réaffecter les vues d'un user vers un autre===&lt;br /&gt;
Lui supprime les vues.&lt;br /&gt;
&lt;br /&gt;
 Lister les vues du user&lt;br /&gt;
       select V.custom_view_id, V.name from custom_views as V&lt;br /&gt;
       inner join custom_view_user_relation as C on C.custom_view_id = V.custom_view_id&lt;br /&gt;
       where C.user_id = &amp;lt;&amp;lt;ID_USER&amp;gt;&amp;gt; and is_owner = 1;&lt;br /&gt;
&lt;br /&gt;
 Lister les vues du nouvel user&lt;br /&gt;
       select V.custom_view_id, V.name from custom_views as V&lt;br /&gt;
       inner join custom_view_user_relation as C on C.custom_view_id = V.custom_view_id&lt;br /&gt;
       where C.user_id = &amp;lt;&amp;lt;ID_USER&amp;gt;&amp;gt;;&lt;br /&gt;
&lt;br /&gt;
Comparer les 2 listes et exclure les vues présentes des 2 cotés et leurs changer le owner avec la procédure précédente.&lt;br /&gt;
Pour les autres utiliser la requête suivante:&lt;br /&gt;
&lt;br /&gt;
       update custom_view_user_relation set user_id='&amp;lt;&amp;lt;New_user_ID&amp;gt;&amp;gt;', locked='0', is_owner='1' &lt;br /&gt;
       where custom_view_id in (&amp;lt;&amp;lt;liste des custom_view_id séparés par des ','&amp;gt;&amp;gt;) and user_id='&amp;lt;&amp;lt;old_USER_ID&amp;gt;&amp;gt;';&lt;br /&gt;
&lt;br /&gt;
==Problème lié à des métriques erronées==&lt;br /&gt;
&lt;br /&gt;
Certains services étaient associés a des métriques incohérentes (métrique de cpu associé à un contrôle de disque, ou une métrique nommée à l'aide d'une apostrophe). &lt;br /&gt;
Ces métriques ne contient également aucune données. &lt;br /&gt;
Toutes ces incohérences étaient la source du dysfonctionnement des graphiques.&lt;br /&gt;
&lt;br /&gt;
Voici la méthode utilisée pour résoudre le problème :&lt;br /&gt;
 &lt;br /&gt;
 Se connecter au serveur MySQL et lister les métriques du service posant problème : &lt;br /&gt;
 Pour un host&lt;br /&gt;
 mysql&amp;gt; select metric_id, metric_name from index_data i, metrics m where i.host_name = 'FRCCEISSUP01' and i.service_description = 'DISK-Usage' and i.id = m.index_id;&lt;br /&gt;
 &lt;br /&gt;
 Pour tout les host&lt;br /&gt;
 mysql&amp;gt;select i.host_name, metric_id, metric_name from index_data i, metrics m where i.service_description = 'DISK-Usage' and i.id = m.index_id and metric_name like '\'';&lt;br /&gt;
 *************************** 1. row ***************************&lt;br /&gt;
 metric_id: 35987&lt;br /&gt;
 metric_name: /var/lib/centreon&lt;br /&gt;
 *************************** 2. row ***************************&lt;br /&gt;
 metric_id: 35986&lt;br /&gt;
 metric_name: /var/lib/mysql&lt;br /&gt;
 *************************** 3. row ***************************&lt;br /&gt;
 metric_id: 29686&lt;br /&gt;
 metric_name: /&lt;br /&gt;
 *************************** 4. row ***************************&lt;br /&gt;
 metric_id: 29687&lt;br /&gt;
 metric_name: /boot&lt;br /&gt;
 *************************** 5. row ***************************&lt;br /&gt;
 metric_id: 29688&lt;br /&gt;
 metric_name: /dev/shm&lt;br /&gt;
 *************************** 6. row ***************************&lt;br /&gt;
 metric_id: 38748&lt;br /&gt;
 metric_name: '&lt;br /&gt;
 6 rows in set (0.00 sec)&lt;br /&gt;
&lt;br /&gt;
Pour chaque métrique, vérifier que chacune contient des données à l'aide de la requête suivante (où ID METRIC correspond au champs metric_id précédent) :&lt;br /&gt;
 mysql&amp;gt; SELECT max(ctime) FROM data_bin WHERE id_metric = 'ID METRIC' ;&lt;br /&gt;
&lt;br /&gt;
Si le requête ne renvoie aucune donnée, ou si la métrique se nomme basiquement 'apostrophe&amp;quot;, la supprimer comme ci-dessous :&lt;br /&gt;
 mysql&amp;gt; update metrics set to_delete = '1' where metric_id = 'ID METRIC' ;&lt;br /&gt;
 Query OK, 1 row affected (0.00 sec)&lt;br /&gt;
 Rows matched: 1 Changed: 1 Warnings: 0&lt;br /&gt;
&lt;br /&gt;
Ensuite redémarrer le service cbd pour prendre en compte la suppression.&lt;br /&gt;
&lt;br /&gt;
 # /etc/init.d/cbd restart&lt;br /&gt;
 Stopping cbd_central-rrd: [ OK ]&lt;br /&gt;
 Stopping cbd_central-broker: [ OK ]&lt;br /&gt;
 Starting cbd_central-rrd: [ OK ]&lt;br /&gt;
 Starting cbd_central-broker: [ OK ]&lt;br /&gt;
&lt;br /&gt;
==Trouver un graphe erreur Centreon.==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Retourne ID service  (collone ID)&lt;br /&gt;
&lt;br /&gt;
 select * from centreon_storage.index_data where host_name like 'FRCCEISSUP04'; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Retourne les lignes du service (si ' supprimer la ligne) (ID = index_id)&lt;br /&gt;
&lt;br /&gt;
 Select * from centreon_storage.metrics where index_id like '4530'; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Requette graphe disk KO &lt;br /&gt;
&lt;br /&gt;
Affiche toutes les entrées avec une ' dans le nom&lt;br /&gt;
&lt;br /&gt;
 select * from centreon_storage.metrics where metric_name = &amp;quot;'&amp;quot;; &lt;br /&gt;
&lt;br /&gt;
===Clapi===&lt;br /&gt;
====Liste des objets et actions Centreon-Clapi v 1.3.1====&lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
!Objet !! Désignation !! Désignation   &lt;br /&gt;
|-&lt;br /&gt;
!   !! English !! Français&lt;br /&gt;
|-&lt;br /&gt;
|ACL||Access List||Liste d'accès&lt;br /&gt;
|-&lt;br /&gt;
|ACLACTION||Actions Access||Gestion des accès sur les actions&lt;br /&gt;
|-&lt;br /&gt;
|ACLGROUP||Access Groups||Gestion des groupe d'accès&lt;br /&gt;
|-&lt;br /&gt;
|ACLMENU||Menus Access||Gestion des accès aux menus&lt;br /&gt;
|-&lt;br /&gt;
|ACLRESOURCE||Ressources Access||Gestion des accès aux ressources&lt;br /&gt;
|-&lt;br /&gt;
|CG||Contact Groups||Groupes de contacts&lt;br /&gt;
|-&lt;br /&gt;
|CGICFG||cgi Nagios||cgi Nagios&lt;br /&gt;
|-&lt;br /&gt;
|CMD||Commands||Commandes&lt;br /&gt;
|-&lt;br /&gt;
|CONTACT||Contacts / Users||Contacts / Utilisateurs&lt;br /&gt;
|-&lt;br /&gt;
|CONTACTTPL||Contact Template||Modèles de contact&lt;br /&gt;
|-&lt;br /&gt;
|HC||Hosts Catégories||Catégories d'hôtes&lt;br /&gt;
|-&lt;br /&gt;
|HG||Hosts Groups||Groupes d'hôtes&lt;br /&gt;
|-&lt;br /&gt;
|HOST||Hosts||Hôtes&lt;br /&gt;
|-&lt;br /&gt;
|HTPL||Hosts Template||Modèle d'hôtes&lt;br /&gt;
|-&lt;br /&gt;
|INSTANCE||Poller||Collecteur&lt;br /&gt;
|-&lt;br /&gt;
|LDAP||Ldap||Ldap&lt;br /&gt;
|-&lt;br /&gt;
|NAGIOSCFG||nagios.cfg Nagios||nagios.cfg Nagios&lt;br /&gt;
|-&lt;br /&gt;
|NDO2DBCFG||ndo2db.cfg NDOutils||ndo2db.cfg NDOutils&lt;br /&gt;
|-&lt;br /&gt;
|NDOMODCFG||ndomod.cfg NDOutils||ndomod.cfg NDOutils&lt;br /&gt;
|-&lt;br /&gt;
|RESOURCECFG||Resources Nagios||Ressources Nagios&lt;br /&gt;
|-&lt;br /&gt;
|SC||Services Catégories||Catégories de services&lt;br /&gt;
|-&lt;br /&gt;
|SERVICE||Services||Services&lt;br /&gt;
|-&lt;br /&gt;
|SG||Services Groups||Groupes de services&lt;br /&gt;
|-&lt;br /&gt;
|STPL||Services Template||Modèle de services&lt;br /&gt;
|-&lt;br /&gt;
|TIMEPERIOD||Time periods||Périodes temporelles&lt;br /&gt;
|}&lt;br /&gt;
 &lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
! ACTION !! OBJET SUPERVISEUR&lt;br /&gt;
|-&lt;br /&gt;
|ADD||ACLACTION, ACLGROUP, ACLMENU, ACLRESOURCE, CGICFG, CMD, CONTACT, CONTACTTPL, CG, HTPL, HOST, HG, HC, INSTANCE, LDAP, NAGIOSCFG,NDO2DBCFG, NDOMODCFG, RESOURCECFG, STPL, SERVICE, SG, SC, TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|ADDCONTACT||CG, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|ADDCONTACTGROUP||ACLGROUP, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|ADDHOST||STPL&lt;br /&gt;
|-&lt;br /&gt;
|ADDHOSTGROUP||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|ADDMEMBER||HG, HC&lt;br /&gt;
|-&lt;br /&gt;
|ADDPARENT||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|ADDRESOURCE||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|ADDSERVICE||SG, SC&lt;br /&gt;
|-&lt;br /&gt;
|ADDSERVICETEMPLATE||SC&lt;br /&gt;
|-&lt;br /&gt;
|ADDTEMPLATE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|APPLYTPL||HOST&lt;br /&gt;
|-&lt;br /&gt;
|CFGMOVE||&lt;br /&gt;
|-&lt;br /&gt;
|DEL||ACLACTION, ACLGROUP, ACLMENU, ACLRESOURCE, CGICFG, CMD, CONTACT, CONTACTTPL, CG, HTPL, HOST, HG, HC, INSTANCE, LDAP, NAGIOSCFG, NDO2DBCFG, NDOMODCFG, RESOURCECFG, STPL, SERVICE, SG, SC, TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|DELACTION||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|DELCONTACT||ACLGROUP, CG, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|DELCONTACTGROUP||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|DELEXCEPTION||TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|DELHOST||STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|DELHOSTGROUP||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|DELHOSTGROUPSERVICE||SG&lt;br /&gt;
|-&lt;br /&gt;
|DELMACRO||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|DELMEMBER||HG, HC&lt;br /&gt;
|-&lt;br /&gt;
|DELPARENT||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|DELSERVICE||SG, SC&lt;br /&gt;
|-&lt;br /&gt;
|DELSERVICETEMPLATE||SC&lt;br /&gt;
|-&lt;br /&gt;
|DELTEMPLATE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|DISABLE||CONTACT, CONTACTTPL, CG, HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|ENABLE||CONTACT, CONTACTTPL, CG, HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|GETACTION||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|GETACLGROUP||ACLACTION, ACLMENU, ACLRESOURCE, CONTACT, CONTACTTPL&lt;br /&gt;
|-&lt;br /&gt;
|GETCONTACT||ACLGROUP, CG, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|GETCONTACTGROUP||ACLGROUP, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|GETEXCEPTION||TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|GETHOSTGROUP||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|GETHOSTGROUPSERVICE||SG&lt;br /&gt;
|-&lt;br /&gt;
|GETMACRO||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|GETMEMBER||HG, HC&lt;br /&gt;
|-&lt;br /&gt;
|GETMENU||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|GETPARENT||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|GETRESOURCE||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|GETSERVICE||SG, SC&lt;br /&gt;
|-&lt;br /&gt;
|GETSERVICETEMPLATE||SC&lt;br /&gt;
|-&lt;br /&gt;
|GETTEMPLATE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|GRANT||ACLACTION, ACLMENU&lt;br /&gt;
|-&lt;br /&gt;
|LASTRELOAD||ACL&lt;br /&gt;
|-&lt;br /&gt;
|POLLERGENERATE||&lt;br /&gt;
|-&lt;br /&gt;
|POLLERLIST||&lt;br /&gt;
|-&lt;br /&gt;
|POLLERRELOAD||&lt;br /&gt;
|-&lt;br /&gt;
|POLLERESTART||&lt;br /&gt;
|-&lt;br /&gt;
|POLLERTEST||&lt;br /&gt;
|-&lt;br /&gt;
|RELOAD	ACL||&lt;br /&gt;
|-&lt;br /&gt;
|REVOKE||ACLACTION, ACLMENU&lt;br /&gt;
|-&lt;br /&gt;
|SETCONTACT||ACLGROUP, CG, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|SETCONTACTGROUP||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|SETCONTACTTEMPLATE||LDAP&lt;br /&gt;
|-&lt;br /&gt;
|SETEXCEPTION||TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|SETHOST||STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|SETHOSTGROUP||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|SETHOSTGROUPSERVICE||SG&lt;br /&gt;
|-&lt;br /&gt;
|SETINSTANCE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|SETMACRO||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|SETMEMBER||HG, HC&lt;br /&gt;
|-&lt;br /&gt;
|SETMENU||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|SETPARAM||ACLACTION, ACLGROUP, ACLMENU, ACLRESOURCE, CGICFG, CMD, CONTACT, CONTACTTPL, CG, HTPL, HOST, HG, INSTANCE, LDAP, NAGIOSCFG, NDO2DBCFG, NDOMODCFG, RESOURCECFG, STPL, SERVICE, SG, SC, TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|SETPARENT||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|SETSERVICE||SG&lt;br /&gt;
|-&lt;br /&gt;
|SETTEMPLATE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|SHOW||ACLACTION, ACLGROUP, ACLMENU, ACLRESOURCE, CGICFG, CMD, CONTACT, CONTACTTPL, CG, HTPL, HOST, HG, HC, INSTANCE, LDAP, NAGIOSCFG, NDO2DBCFG, NDOMODCFG, RESOURCECFG, STPL, SERVICE, SG, SC, TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|UNSETACLGROUP||CONTACT, CONTACTTPL&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
==BAM==&lt;br /&gt;
&lt;br /&gt;
===ClapiBAM===&lt;br /&gt;
&lt;br /&gt;
Ajout KPI &lt;br /&gt;
 centreon -u admin -p BZeGqxtGarc -o KPI -a ADD -v 'service;FRCCESGAPA01|CPU;IBM_Cognos_TM1;Weak;Minor;Major'&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Trucs==&lt;br /&gt;
&lt;br /&gt;
===Redimensionnement des Services name en configuration.===&lt;br /&gt;
&lt;br /&gt;
 Modifier la ligne 65 du fichier :&lt;br /&gt;
 /usr/share/centreon/www/include/configuration/configObject/service/listService.ihtml&lt;br /&gt;
 &lt;br /&gt;
 &amp;lt;td class=&amp;quot;ListColLeft '''resizeTitle'''&amp;quot;&amp;gt;&lt;br /&gt;
 en&lt;br /&gt;
 &amp;lt;td class=&amp;quot;ListColLeft&amp;quot;&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===Mysql recheche des status===&lt;br /&gt;
&lt;br /&gt;
====Remonte tout les hosts et services en Critique et / ou inconnue====&lt;br /&gt;
 SELECT hostgroups.hostgroup_id, hostgroups.name AS HostGroup, hosts.host_id, hosts.name AS Hosts, hosts.state, services.description AS Services, services.state &lt;br /&gt;
  FROM hostgroups, hosts_hostgroups, hosts, services &lt;br /&gt;
  WHERE hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id &lt;br /&gt;
  AND hosts_hostgroups.host_id = hosts.host_id &lt;br /&gt;
  AND services.host_id = hosts.host_id &lt;br /&gt;
  AND hosts.enabled='1' &lt;br /&gt;
  AND services.enabled='1' &lt;br /&gt;
  AND hostgroups.name = 'hg-sextant'&lt;br /&gt;
  AND hosts.state in ('2','3')&lt;br /&gt;
  OR hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id &lt;br /&gt;
  AND hosts_hostgroups.host_id = hosts.host_id &lt;br /&gt;
  AND services.host_id = hosts.host_id &lt;br /&gt;
  AND hosts.enabled='1' &lt;br /&gt;
  AND services.enabled='1' &lt;br /&gt;
  AND hostgroups.name = 'hg-sextant'&lt;br /&gt;
  AND services.state in ('2','3');&lt;br /&gt;
&lt;br /&gt;
====Remonte tout les hosts et services en Critique et / ou inconnue non Acknowledged====&lt;br /&gt;
 SELECT hostgroups.hostgroup_id, hostgroups.name AS HostGroup, hosts.host_id, hosts.name AS Hosts, hosts.state, hosts.acknowledged As Acknowledged, services.description AS Services, services.state,    &lt;br /&gt;
  services.acknowledged As Acknowledged &lt;br /&gt;
  FROM hostgroups, hosts_hostgroups, hosts, services &lt;br /&gt;
  WHERE hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id &lt;br /&gt;
  AND hosts_hostgroups.host_id = hosts.host_id &lt;br /&gt;
  AND services.host_id = hosts.host_id &lt;br /&gt;
  AND hosts.enabled='1' &lt;br /&gt;
  AND services.enabled='1' &lt;br /&gt;
  AND hostgroups.name = 'hg-sextant'&lt;br /&gt;
  AND hosts.state in ('2','3')&lt;br /&gt;
  AND hosts.acknowledged = 0&lt;br /&gt;
  OR hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id &lt;br /&gt;
  AND hosts_hostgroups.host_id = hosts.host_id &lt;br /&gt;
  AND services.host_id = hosts.host_id &lt;br /&gt;
  AND hosts.enabled='1' &lt;br /&gt;
  AND services.enabled='1' &lt;br /&gt;
  AND hostgroups.name = 'hg-sextant'&lt;br /&gt;
  AND services.state in ('2','3')&lt;br /&gt;
  AND services.acknowledged = 0;&lt;br /&gt;
&lt;br /&gt;
====Remonte les indicateurs sans downtime n'y Acknoledged====&lt;br /&gt;
  use centreon_storage;&lt;br /&gt;
&lt;br /&gt;
 /*select HOST*/&lt;br /&gt;
 select concat(count(distinct(hosts.name)),':hosts') as 'RESULT'&lt;br /&gt;
 from hosts&lt;br /&gt;
  inner join hosts_hostgroups on hosts.host_id = hosts_hostgroups.host_id&lt;br /&gt;
  inner join hostgroups on hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id&lt;br /&gt;
 where hosts.enabled=1&lt;br /&gt;
 and hosts.state != 0&lt;br /&gt;
 and hosts.acknowledged = 0&lt;br /&gt;
 and hostgroups.name = 'HG-SEXTANT'&lt;br /&gt;
 and hosts.host_id not in ( select downtimes.host_id from downtimes where actual_end_time is null and cancelled = 0 )&lt;br /&gt;
 union&lt;br /&gt;
 /*select services*/&lt;br /&gt;
 select concat(count(distinct(hosts.name)),':services') as 'RESULT'&lt;br /&gt;
 from services&lt;br /&gt;
  inner join hosts on hosts.host_id = services.host_id&lt;br /&gt;
  inner join hosts_hostgroups on services.host_id = hosts_hostgroups.host_id&lt;br /&gt;
  inner join hostgroups on hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id&lt;br /&gt;
  where&lt;br /&gt;
  hosts.enabled=1&lt;br /&gt;
  AND services.enabled=1&lt;br /&gt;
  AND services.state in (2,3)&lt;br /&gt;
  AND services.acknowledged = 0&lt;br /&gt;
  AND hostgroups.name = 'HG-SEXTANT'&lt;br /&gt;
  AND services.host_id not in ( select downtimes.host_id from downtimes where actual_end_time is null and cancelled = 0 )&lt;br /&gt;
  AND hosts.acknowledged = 0&lt;br /&gt;
  AND services.service_id != '26732';&lt;br /&gt;
&lt;br /&gt;
====Liste service template====&lt;br /&gt;
&lt;br /&gt;
 select * from service where service_register = '0';&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=====Liste service Template avec commentaire et exemple argument=====&lt;br /&gt;
&lt;br /&gt;
 select service_id,service_description,'|',service_comment,'|',command_command_id_arg &lt;br /&gt;
 from service&lt;br /&gt;
 where service_register = '0' and service_description not like 'Generic%' order by service_id ; &lt;br /&gt;
&lt;br /&gt;
=====Liste des service Template avec description des arguments=====&lt;br /&gt;
&lt;br /&gt;
 select service_id,service_description,'|',macro_description&lt;br /&gt;
 from service&lt;br /&gt;
 inner join command_arg_description&lt;br /&gt;
 on cmd_id = command_command_id&lt;br /&gt;
 where service_register = '0' and service_description not like 'Generic%' order by service_id ;&lt;br /&gt;
&lt;br /&gt;
=====Check catégorie service=====&lt;br /&gt;
&lt;br /&gt;
 SELECT service_id, service_description FROM service WHERE service_id NOT IN (SELECT service_service_id FROM service_categories_relation) AND service_register = '1';&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Clear cashe sonde swap===&lt;br /&gt;
&lt;br /&gt;
sur le poller où est testé le host, supprimer le fichier /var/lib/centreon/centplugins/remote_storage_cache_$HOST$&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Ajout Vues personnalisées===&lt;br /&gt;
&lt;br /&gt;
Récuperation widget_id&lt;br /&gt;
 select * from widgets where title like 'Proc%' ;&lt;br /&gt;
Récuperation custom_view_id &lt;br /&gt;
 select custom_view_id from widget_views where widget_id = $widget_id$ ;&lt;br /&gt;
Récuperation contact_id&lt;br /&gt;
 select contact_alias, contact_id from contact where contact_alias like '%user%';&lt;br /&gt;
Création view pour un utilisateur&lt;br /&gt;
 insert into custom_view_user_relation (custom_view_id,user_id,locked,is_owner,is_consumed)  values($custom_view_id$,$user_id$,1,0,1);&lt;br /&gt;
&lt;br /&gt;
===Liste les HG des serveurs actif===&lt;br /&gt;
&lt;br /&gt;
 select h.host_id,h.host_name,h.host_activate, HG.hg_name from host as h &lt;br /&gt;
 inner join hostgroup_relation as HR on HR.host_host_id = h.host_id&lt;br /&gt;
 inner join hostgroup as HG on HG.hg_id = HR.hostgroup_hg_id&lt;br /&gt;
 where h.host_activate = '1';&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===delock model de service===&lt;br /&gt;
&lt;br /&gt;
 select * from service where service_register = '0'  and service_description like '%';&lt;br /&gt;
 &lt;br /&gt;
 update service set service_locked=0 where service_description like '%';&lt;br /&gt;
&lt;br /&gt;
===Liste des VM pour un Datcenter===&lt;br /&gt;
&lt;br /&gt;
 /usr/lib/centreon/plugins/centreon_vmware_connector_client.pl --plugin=apps::vmware::connector::plugin --mode getmap --container='DC1_VDI' --connector-hostname localhost&lt;br /&gt;
&lt;br /&gt;
===Check des TimePeriodes en fonction d'un hoste===&lt;br /&gt;
&lt;br /&gt;
   SQL&lt;br /&gt;
 select concat( hosts.name,';',services.display_name,';check_period;',hosts.check_period) from services&lt;br /&gt;
 inner join hosts on services.host_id = hosts.host_id &lt;br /&gt;
 where services.check_period != hosts.check_period and services.check_period ='24X7;&lt;br /&gt;
&lt;br /&gt;
  Copier le résultat dans un fichier TMP.&lt;br /&gt;
 Lancer une requête CLAPI:&lt;br /&gt;
 ./ADD_Centreon.sh admin BZeGqxtGarc /tmp/tp_update.txt SERVICE setparam&lt;br /&gt;
&lt;br /&gt;
 Recharger Centreon.&lt;br /&gt;
 Faire check EZV&lt;/div&gt;</summary>
		<author><name>24.206.98.112</name></author>
		
	</entry>
	<entry>
		<id>http://wiki.les-noulot.fr/index.php?title=Centreon&amp;diff=404</id>
		<title>Centreon</title>
		<link rel="alternate" type="text/html" href="http://wiki.les-noulot.fr/index.php?title=Centreon&amp;diff=404"/>
		<updated>2023-04-19T14:02:00Z</updated>

		<summary type="html">&lt;p&gt;24.206.98.112 : /* réaffecter les vues d'un user vers un autre */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;=Centreon=&lt;br /&gt;
&lt;br /&gt;
==Les valeurs par défaut des ACKNOWLEDGE dans les widgets==&lt;br /&gt;
&lt;br /&gt;
Il est possible de cocher des cases par défaut (sticky, notify...) en éditant le fichier suivant:&lt;br /&gt;
&lt;br /&gt;
 /usr/share/centreon/www/widgets/service-monitoring/src/acknowledge.ihtml&lt;br /&gt;
 La différence est l'ajout du mot &amp;quot;checked&amp;quot;.&lt;br /&gt;
&lt;br /&gt;
==Vérification config==&lt;br /&gt;
 /usr/sbin/centengine -v /etc/centreon-engine/centengine.cfg&lt;br /&gt;
&lt;br /&gt;
==RRDTools==&lt;br /&gt;
&lt;br /&gt;
 Check fichier rrdfile:&lt;br /&gt;
 rrdtool &amp;quot;nom du fichier .rrd&amp;quot;&lt;br /&gt;
&lt;br /&gt;
 log : &lt;br /&gt;
 tailf /var/log/centreon-broker/central-master-rrd.log&lt;br /&gt;
&lt;br /&gt;
 Taille des fichiers de rétention des Graphiques&lt;br /&gt;
 Configuration =&amp;gt; Centreon =&amp;gt; configuration =&amp;gt; Output&lt;br /&gt;
 Maximum size of file : 104857600&lt;br /&gt;
&lt;br /&gt;
==Check interface LAN windows==&lt;br /&gt;
&lt;br /&gt;
Permet de lister vos interfaces Windows&lt;br /&gt;
 /usr/lib64/nagios/plugins/centreon_plugins.pl --plugin=os::windows::snmp::plugin --hostname=X.X.X.X --snmp-version='2c' --snmp-community='XXX' --mode list-interfaces&lt;br /&gt;
&lt;br /&gt;
Vous pourrez ensuite superviser les interfaces via leur ID ou leur nom.&lt;br /&gt;
&lt;br /&gt;
Voici par exemple comment remonter le trafic d'une interface en utilisant son nom:&lt;br /&gt;
 /usr/lib64/nagios/plugins/centreon_plugins.pl --plugin=os::windows::snmp::plugin --hostname=X.X.X.X --snmp-version='2c' --snmp-community='XXX' --mode interfaces --name --interface  &lt;br /&gt;
 'ethernet_7' --add-traffic&lt;br /&gt;
&lt;br /&gt;
Vous pouvez remonter le traffic toutes les interfaces avec une seule et même en commande en ne spécifiant ni l'ID ni le nom.&lt;br /&gt;
Vous pouvez également utiliser des regexp dans le nom pour en remonter plusieurs:&lt;br /&gt;
 /usr/lib64/nagios/plugins/centreon_plugins.pl --plugin=os::windows::snmp::plugin --hostname=X.X.X.X --snmp-version='2c' --snmp-community='XXX' --mode interfaces --name --interface &lt;br /&gt;
 'ethernet_*' --add-traffic&lt;br /&gt;
&lt;br /&gt;
==Changer le owner des vue custum==&lt;br /&gt;
 use centreon;&lt;br /&gt;
 select * from custom_views&lt;br /&gt;
 Verifier le n° de la view dans Centreon en passant la sourie sur l'onglet de la vue.&lt;br /&gt;
 select * from custom_view_user_relation where custom_view_id='ID_VIEW';&lt;br /&gt;
 update custom_view_user_relation set locked='0' where custom_view_id='320' and user_id='ID_NEW_USER';&lt;br /&gt;
 update custom_view_user_relation set is_owner='1' where custom_view_id='320' and user_id='ID_NEW_USER'; (user_id=19 &amp;gt;adm-snoulot)&lt;br /&gt;
&lt;br /&gt;
===Réaffecter les vues d'un user vers un autre===&lt;br /&gt;
Lui supprime les vues.&lt;br /&gt;
&lt;br /&gt;
 Lister les vues du user&lt;br /&gt;
&lt;br /&gt;
       select V.custom_view_id, V.name from custom_views as V&lt;br /&gt;
       inner join custom_view_user_relation as C on C.custom_view_id = V.custom_view_id&lt;br /&gt;
       where C.user_id = &amp;lt;&amp;lt;ID_USER&amp;gt;&amp;gt; and is_owner = 1;&lt;br /&gt;
&lt;br /&gt;
 Lister les vues du nouvel user&lt;br /&gt;
 &lt;br /&gt;
       select V.custom_view_id, V.name from custom_views as V&lt;br /&gt;
       inner join custom_view_user_relation as C on C.custom_view_id = V.custom_view_id&lt;br /&gt;
       where C.user_id = &amp;lt;&amp;lt;ID_USER&amp;gt;&amp;gt;;&lt;br /&gt;
&lt;br /&gt;
Comparer les 2 listes et exclure les vues présentes des 2 cotés et leurs changer le owner avec la procédure précédente.&lt;br /&gt;
Pour les autres utiliser la requête suivante:&lt;br /&gt;
&lt;br /&gt;
       update custom_view_user_relation set user_id='&amp;lt;&amp;lt;New_user_ID&amp;gt;&amp;gt;', locked='0', is_owner='1' &lt;br /&gt;
       where custom_view_id in (&amp;lt;&amp;lt;liste des custom_view_id séparés par des ','&amp;gt;&amp;gt;) and user_id='&amp;lt;&amp;lt;old_USER_ID&amp;gt;&amp;gt;';&lt;br /&gt;
&lt;br /&gt;
==Problème lié à des métriques erronées==&lt;br /&gt;
&lt;br /&gt;
Certains services étaient associés a des métriques incohérentes (métrique de cpu associé à un contrôle de disque, ou une métrique nommée à l'aide d'une apostrophe). &lt;br /&gt;
Ces métriques ne contient également aucune données. &lt;br /&gt;
Toutes ces incohérences étaient la source du dysfonctionnement des graphiques.&lt;br /&gt;
&lt;br /&gt;
Voici la méthode utilisée pour résoudre le problème :&lt;br /&gt;
 &lt;br /&gt;
 Se connecter au serveur MySQL et lister les métriques du service posant problème : &lt;br /&gt;
 Pour un host&lt;br /&gt;
 mysql&amp;gt; select metric_id, metric_name from index_data i, metrics m where i.host_name = 'FRCCEISSUP01' and i.service_description = 'DISK-Usage' and i.id = m.index_id;&lt;br /&gt;
 &lt;br /&gt;
 Pour tout les host&lt;br /&gt;
 mysql&amp;gt;select i.host_name, metric_id, metric_name from index_data i, metrics m where i.service_description = 'DISK-Usage' and i.id = m.index_id and metric_name like '\'';&lt;br /&gt;
 *************************** 1. row ***************************&lt;br /&gt;
 metric_id: 35987&lt;br /&gt;
 metric_name: /var/lib/centreon&lt;br /&gt;
 *************************** 2. row ***************************&lt;br /&gt;
 metric_id: 35986&lt;br /&gt;
 metric_name: /var/lib/mysql&lt;br /&gt;
 *************************** 3. row ***************************&lt;br /&gt;
 metric_id: 29686&lt;br /&gt;
 metric_name: /&lt;br /&gt;
 *************************** 4. row ***************************&lt;br /&gt;
 metric_id: 29687&lt;br /&gt;
 metric_name: /boot&lt;br /&gt;
 *************************** 5. row ***************************&lt;br /&gt;
 metric_id: 29688&lt;br /&gt;
 metric_name: /dev/shm&lt;br /&gt;
 *************************** 6. row ***************************&lt;br /&gt;
 metric_id: 38748&lt;br /&gt;
 metric_name: '&lt;br /&gt;
 6 rows in set (0.00 sec)&lt;br /&gt;
&lt;br /&gt;
Pour chaque métrique, vérifier que chacune contient des données à l'aide de la requête suivante (où ID METRIC correspond au champs metric_id précédent) :&lt;br /&gt;
 mysql&amp;gt; SELECT max(ctime) FROM data_bin WHERE id_metric = 'ID METRIC' ;&lt;br /&gt;
&lt;br /&gt;
Si le requête ne renvoie aucune donnée, ou si la métrique se nomme basiquement 'apostrophe&amp;quot;, la supprimer comme ci-dessous :&lt;br /&gt;
 mysql&amp;gt; update metrics set to_delete = '1' where metric_id = 'ID METRIC' ;&lt;br /&gt;
 Query OK, 1 row affected (0.00 sec)&lt;br /&gt;
 Rows matched: 1 Changed: 1 Warnings: 0&lt;br /&gt;
&lt;br /&gt;
Ensuite redémarrer le service cbd pour prendre en compte la suppression.&lt;br /&gt;
&lt;br /&gt;
 # /etc/init.d/cbd restart&lt;br /&gt;
 Stopping cbd_central-rrd: [ OK ]&lt;br /&gt;
 Stopping cbd_central-broker: [ OK ]&lt;br /&gt;
 Starting cbd_central-rrd: [ OK ]&lt;br /&gt;
 Starting cbd_central-broker: [ OK ]&lt;br /&gt;
&lt;br /&gt;
==Trouver un graphe erreur Centreon.==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Retourne ID service  (collone ID)&lt;br /&gt;
&lt;br /&gt;
 select * from centreon_storage.index_data where host_name like 'FRCCEISSUP04'; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Retourne les lignes du service (si ' supprimer la ligne) (ID = index_id)&lt;br /&gt;
&lt;br /&gt;
 Select * from centreon_storage.metrics where index_id like '4530'; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Requette graphe disk KO &lt;br /&gt;
&lt;br /&gt;
Affiche toutes les entrées avec une ' dans le nom&lt;br /&gt;
&lt;br /&gt;
 select * from centreon_storage.metrics where metric_name = &amp;quot;'&amp;quot;; &lt;br /&gt;
&lt;br /&gt;
===Clapi===&lt;br /&gt;
====Liste des objets et actions Centreon-Clapi v 1.3.1====&lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
!Objet !! Désignation !! Désignation   &lt;br /&gt;
|-&lt;br /&gt;
!   !! English !! Français&lt;br /&gt;
|-&lt;br /&gt;
|ACL||Access List||Liste d'accès&lt;br /&gt;
|-&lt;br /&gt;
|ACLACTION||Actions Access||Gestion des accès sur les actions&lt;br /&gt;
|-&lt;br /&gt;
|ACLGROUP||Access Groups||Gestion des groupe d'accès&lt;br /&gt;
|-&lt;br /&gt;
|ACLMENU||Menus Access||Gestion des accès aux menus&lt;br /&gt;
|-&lt;br /&gt;
|ACLRESOURCE||Ressources Access||Gestion des accès aux ressources&lt;br /&gt;
|-&lt;br /&gt;
|CG||Contact Groups||Groupes de contacts&lt;br /&gt;
|-&lt;br /&gt;
|CGICFG||cgi Nagios||cgi Nagios&lt;br /&gt;
|-&lt;br /&gt;
|CMD||Commands||Commandes&lt;br /&gt;
|-&lt;br /&gt;
|CONTACT||Contacts / Users||Contacts / Utilisateurs&lt;br /&gt;
|-&lt;br /&gt;
|CONTACTTPL||Contact Template||Modèles de contact&lt;br /&gt;
|-&lt;br /&gt;
|HC||Hosts Catégories||Catégories d'hôtes&lt;br /&gt;
|-&lt;br /&gt;
|HG||Hosts Groups||Groupes d'hôtes&lt;br /&gt;
|-&lt;br /&gt;
|HOST||Hosts||Hôtes&lt;br /&gt;
|-&lt;br /&gt;
|HTPL||Hosts Template||Modèle d'hôtes&lt;br /&gt;
|-&lt;br /&gt;
|INSTANCE||Poller||Collecteur&lt;br /&gt;
|-&lt;br /&gt;
|LDAP||Ldap||Ldap&lt;br /&gt;
|-&lt;br /&gt;
|NAGIOSCFG||nagios.cfg Nagios||nagios.cfg Nagios&lt;br /&gt;
|-&lt;br /&gt;
|NDO2DBCFG||ndo2db.cfg NDOutils||ndo2db.cfg NDOutils&lt;br /&gt;
|-&lt;br /&gt;
|NDOMODCFG||ndomod.cfg NDOutils||ndomod.cfg NDOutils&lt;br /&gt;
|-&lt;br /&gt;
|RESOURCECFG||Resources Nagios||Ressources Nagios&lt;br /&gt;
|-&lt;br /&gt;
|SC||Services Catégories||Catégories de services&lt;br /&gt;
|-&lt;br /&gt;
|SERVICE||Services||Services&lt;br /&gt;
|-&lt;br /&gt;
|SG||Services Groups||Groupes de services&lt;br /&gt;
|-&lt;br /&gt;
|STPL||Services Template||Modèle de services&lt;br /&gt;
|-&lt;br /&gt;
|TIMEPERIOD||Time periods||Périodes temporelles&lt;br /&gt;
|}&lt;br /&gt;
 &lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
! ACTION !! OBJET SUPERVISEUR&lt;br /&gt;
|-&lt;br /&gt;
|ADD||ACLACTION, ACLGROUP, ACLMENU, ACLRESOURCE, CGICFG, CMD, CONTACT, CONTACTTPL, CG, HTPL, HOST, HG, HC, INSTANCE, LDAP, NAGIOSCFG,NDO2DBCFG, NDOMODCFG, RESOURCECFG, STPL, SERVICE, SG, SC, TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|ADDCONTACT||CG, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|ADDCONTACTGROUP||ACLGROUP, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|ADDHOST||STPL&lt;br /&gt;
|-&lt;br /&gt;
|ADDHOSTGROUP||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|ADDMEMBER||HG, HC&lt;br /&gt;
|-&lt;br /&gt;
|ADDPARENT||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|ADDRESOURCE||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|ADDSERVICE||SG, SC&lt;br /&gt;
|-&lt;br /&gt;
|ADDSERVICETEMPLATE||SC&lt;br /&gt;
|-&lt;br /&gt;
|ADDTEMPLATE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|APPLYTPL||HOST&lt;br /&gt;
|-&lt;br /&gt;
|CFGMOVE||&lt;br /&gt;
|-&lt;br /&gt;
|DEL||ACLACTION, ACLGROUP, ACLMENU, ACLRESOURCE, CGICFG, CMD, CONTACT, CONTACTTPL, CG, HTPL, HOST, HG, HC, INSTANCE, LDAP, NAGIOSCFG, NDO2DBCFG, NDOMODCFG, RESOURCECFG, STPL, SERVICE, SG, SC, TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|DELACTION||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|DELCONTACT||ACLGROUP, CG, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|DELCONTACTGROUP||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|DELEXCEPTION||TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|DELHOST||STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|DELHOSTGROUP||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|DELHOSTGROUPSERVICE||SG&lt;br /&gt;
|-&lt;br /&gt;
|DELMACRO||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|DELMEMBER||HG, HC&lt;br /&gt;
|-&lt;br /&gt;
|DELPARENT||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|DELSERVICE||SG, SC&lt;br /&gt;
|-&lt;br /&gt;
|DELSERVICETEMPLATE||SC&lt;br /&gt;
|-&lt;br /&gt;
|DELTEMPLATE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|DISABLE||CONTACT, CONTACTTPL, CG, HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|ENABLE||CONTACT, CONTACTTPL, CG, HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|GETACTION||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|GETACLGROUP||ACLACTION, ACLMENU, ACLRESOURCE, CONTACT, CONTACTTPL&lt;br /&gt;
|-&lt;br /&gt;
|GETCONTACT||ACLGROUP, CG, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|GETCONTACTGROUP||ACLGROUP, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|GETEXCEPTION||TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|GETHOSTGROUP||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|GETHOSTGROUPSERVICE||SG&lt;br /&gt;
|-&lt;br /&gt;
|GETMACRO||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|GETMEMBER||HG, HC&lt;br /&gt;
|-&lt;br /&gt;
|GETMENU||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|GETPARENT||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|GETRESOURCE||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|GETSERVICE||SG, SC&lt;br /&gt;
|-&lt;br /&gt;
|GETSERVICETEMPLATE||SC&lt;br /&gt;
|-&lt;br /&gt;
|GETTEMPLATE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|GRANT||ACLACTION, ACLMENU&lt;br /&gt;
|-&lt;br /&gt;
|LASTRELOAD||ACL&lt;br /&gt;
|-&lt;br /&gt;
|POLLERGENERATE||&lt;br /&gt;
|-&lt;br /&gt;
|POLLERLIST||&lt;br /&gt;
|-&lt;br /&gt;
|POLLERRELOAD||&lt;br /&gt;
|-&lt;br /&gt;
|POLLERESTART||&lt;br /&gt;
|-&lt;br /&gt;
|POLLERTEST||&lt;br /&gt;
|-&lt;br /&gt;
|RELOAD	ACL||&lt;br /&gt;
|-&lt;br /&gt;
|REVOKE||ACLACTION, ACLMENU&lt;br /&gt;
|-&lt;br /&gt;
|SETCONTACT||ACLGROUP, CG, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|SETCONTACTGROUP||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|SETCONTACTTEMPLATE||LDAP&lt;br /&gt;
|-&lt;br /&gt;
|SETEXCEPTION||TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|SETHOST||STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|SETHOSTGROUP||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|SETHOSTGROUPSERVICE||SG&lt;br /&gt;
|-&lt;br /&gt;
|SETINSTANCE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|SETMACRO||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|SETMEMBER||HG, HC&lt;br /&gt;
|-&lt;br /&gt;
|SETMENU||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|SETPARAM||ACLACTION, ACLGROUP, ACLMENU, ACLRESOURCE, CGICFG, CMD, CONTACT, CONTACTTPL, CG, HTPL, HOST, HG, INSTANCE, LDAP, NAGIOSCFG, NDO2DBCFG, NDOMODCFG, RESOURCECFG, STPL, SERVICE, SG, SC, TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|SETPARENT||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|SETSERVICE||SG&lt;br /&gt;
|-&lt;br /&gt;
|SETTEMPLATE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|SHOW||ACLACTION, ACLGROUP, ACLMENU, ACLRESOURCE, CGICFG, CMD, CONTACT, CONTACTTPL, CG, HTPL, HOST, HG, HC, INSTANCE, LDAP, NAGIOSCFG, NDO2DBCFG, NDOMODCFG, RESOURCECFG, STPL, SERVICE, SG, SC, TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|UNSETACLGROUP||CONTACT, CONTACTTPL&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
==BAM==&lt;br /&gt;
&lt;br /&gt;
===ClapiBAM===&lt;br /&gt;
&lt;br /&gt;
Ajout KPI &lt;br /&gt;
 centreon -u admin -p BZeGqxtGarc -o KPI -a ADD -v 'service;FRCCESGAPA01|CPU;IBM_Cognos_TM1;Weak;Minor;Major'&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Trucs==&lt;br /&gt;
&lt;br /&gt;
===Redimensionnement des Services name en configuration.===&lt;br /&gt;
&lt;br /&gt;
 Modifier la ligne 65 du fichier :&lt;br /&gt;
 /usr/share/centreon/www/include/configuration/configObject/service/listService.ihtml&lt;br /&gt;
 &lt;br /&gt;
 &amp;lt;td class=&amp;quot;ListColLeft '''resizeTitle'''&amp;quot;&amp;gt;&lt;br /&gt;
 en&lt;br /&gt;
 &amp;lt;td class=&amp;quot;ListColLeft&amp;quot;&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===Mysql recheche des status===&lt;br /&gt;
&lt;br /&gt;
====Remonte tout les hosts et services en Critique et / ou inconnue====&lt;br /&gt;
 SELECT hostgroups.hostgroup_id, hostgroups.name AS HostGroup, hosts.host_id, hosts.name AS Hosts, hosts.state, services.description AS Services, services.state &lt;br /&gt;
  FROM hostgroups, hosts_hostgroups, hosts, services &lt;br /&gt;
  WHERE hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id &lt;br /&gt;
  AND hosts_hostgroups.host_id = hosts.host_id &lt;br /&gt;
  AND services.host_id = hosts.host_id &lt;br /&gt;
  AND hosts.enabled='1' &lt;br /&gt;
  AND services.enabled='1' &lt;br /&gt;
  AND hostgroups.name = 'hg-sextant'&lt;br /&gt;
  AND hosts.state in ('2','3')&lt;br /&gt;
  OR hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id &lt;br /&gt;
  AND hosts_hostgroups.host_id = hosts.host_id &lt;br /&gt;
  AND services.host_id = hosts.host_id &lt;br /&gt;
  AND hosts.enabled='1' &lt;br /&gt;
  AND services.enabled='1' &lt;br /&gt;
  AND hostgroups.name = 'hg-sextant'&lt;br /&gt;
  AND services.state in ('2','3');&lt;br /&gt;
&lt;br /&gt;
====Remonte tout les hosts et services en Critique et / ou inconnue non Acknowledged====&lt;br /&gt;
 SELECT hostgroups.hostgroup_id, hostgroups.name AS HostGroup, hosts.host_id, hosts.name AS Hosts, hosts.state, hosts.acknowledged As Acknowledged, services.description AS Services, services.state,    &lt;br /&gt;
  services.acknowledged As Acknowledged &lt;br /&gt;
  FROM hostgroups, hosts_hostgroups, hosts, services &lt;br /&gt;
  WHERE hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id &lt;br /&gt;
  AND hosts_hostgroups.host_id = hosts.host_id &lt;br /&gt;
  AND services.host_id = hosts.host_id &lt;br /&gt;
  AND hosts.enabled='1' &lt;br /&gt;
  AND services.enabled='1' &lt;br /&gt;
  AND hostgroups.name = 'hg-sextant'&lt;br /&gt;
  AND hosts.state in ('2','3')&lt;br /&gt;
  AND hosts.acknowledged = 0&lt;br /&gt;
  OR hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id &lt;br /&gt;
  AND hosts_hostgroups.host_id = hosts.host_id &lt;br /&gt;
  AND services.host_id = hosts.host_id &lt;br /&gt;
  AND hosts.enabled='1' &lt;br /&gt;
  AND services.enabled='1' &lt;br /&gt;
  AND hostgroups.name = 'hg-sextant'&lt;br /&gt;
  AND services.state in ('2','3')&lt;br /&gt;
  AND services.acknowledged = 0;&lt;br /&gt;
&lt;br /&gt;
====Remonte les indicateurs sans downtime n'y Acknoledged====&lt;br /&gt;
  use centreon_storage;&lt;br /&gt;
&lt;br /&gt;
 /*select HOST*/&lt;br /&gt;
 select concat(count(distinct(hosts.name)),':hosts') as 'RESULT'&lt;br /&gt;
 from hosts&lt;br /&gt;
  inner join hosts_hostgroups on hosts.host_id = hosts_hostgroups.host_id&lt;br /&gt;
  inner join hostgroups on hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id&lt;br /&gt;
 where hosts.enabled=1&lt;br /&gt;
 and hosts.state != 0&lt;br /&gt;
 and hosts.acknowledged = 0&lt;br /&gt;
 and hostgroups.name = 'HG-SEXTANT'&lt;br /&gt;
 and hosts.host_id not in ( select downtimes.host_id from downtimes where actual_end_time is null and cancelled = 0 )&lt;br /&gt;
 union&lt;br /&gt;
 /*select services*/&lt;br /&gt;
 select concat(count(distinct(hosts.name)),':services') as 'RESULT'&lt;br /&gt;
 from services&lt;br /&gt;
  inner join hosts on hosts.host_id = services.host_id&lt;br /&gt;
  inner join hosts_hostgroups on services.host_id = hosts_hostgroups.host_id&lt;br /&gt;
  inner join hostgroups on hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id&lt;br /&gt;
  where&lt;br /&gt;
  hosts.enabled=1&lt;br /&gt;
  AND services.enabled=1&lt;br /&gt;
  AND services.state in (2,3)&lt;br /&gt;
  AND services.acknowledged = 0&lt;br /&gt;
  AND hostgroups.name = 'HG-SEXTANT'&lt;br /&gt;
  AND services.host_id not in ( select downtimes.host_id from downtimes where actual_end_time is null and cancelled = 0 )&lt;br /&gt;
  AND hosts.acknowledged = 0&lt;br /&gt;
  AND services.service_id != '26732';&lt;br /&gt;
&lt;br /&gt;
====Liste service template====&lt;br /&gt;
&lt;br /&gt;
 select * from service where service_register = '0';&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=====Liste service Template avec commentaire et exemple argument=====&lt;br /&gt;
&lt;br /&gt;
 select service_id,service_description,'|',service_comment,'|',command_command_id_arg &lt;br /&gt;
 from service&lt;br /&gt;
 where service_register = '0' and service_description not like 'Generic%' order by service_id ; &lt;br /&gt;
&lt;br /&gt;
=====Liste des service Template avec description des arguments=====&lt;br /&gt;
&lt;br /&gt;
 select service_id,service_description,'|',macro_description&lt;br /&gt;
 from service&lt;br /&gt;
 inner join command_arg_description&lt;br /&gt;
 on cmd_id = command_command_id&lt;br /&gt;
 where service_register = '0' and service_description not like 'Generic%' order by service_id ;&lt;br /&gt;
&lt;br /&gt;
=====Check catégorie service=====&lt;br /&gt;
&lt;br /&gt;
 SELECT service_id, service_description FROM service WHERE service_id NOT IN (SELECT service_service_id FROM service_categories_relation) AND service_register = '1';&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Clear cashe sonde swap===&lt;br /&gt;
&lt;br /&gt;
sur le poller où est testé le host, supprimer le fichier /var/lib/centreon/centplugins/remote_storage_cache_$HOST$&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Ajout Vues personnalisées===&lt;br /&gt;
&lt;br /&gt;
Récuperation widget_id&lt;br /&gt;
 select * from widgets where title like 'Proc%' ;&lt;br /&gt;
Récuperation custom_view_id &lt;br /&gt;
 select custom_view_id from widget_views where widget_id = $widget_id$ ;&lt;br /&gt;
Récuperation contact_id&lt;br /&gt;
 select contact_alias, contact_id from contact where contact_alias like '%user%';&lt;br /&gt;
Création view pour un utilisateur&lt;br /&gt;
 insert into custom_view_user_relation (custom_view_id,user_id,locked,is_owner,is_consumed)  values($custom_view_id$,$user_id$,1,0,1);&lt;br /&gt;
&lt;br /&gt;
===Liste les HG des serveurs actif===&lt;br /&gt;
&lt;br /&gt;
 select h.host_id,h.host_name,h.host_activate, HG.hg_name from host as h &lt;br /&gt;
 inner join hostgroup_relation as HR on HR.host_host_id = h.host_id&lt;br /&gt;
 inner join hostgroup as HG on HG.hg_id = HR.hostgroup_hg_id&lt;br /&gt;
 where h.host_activate = '1';&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===delock model de service===&lt;br /&gt;
&lt;br /&gt;
 select * from service where service_register = '0'  and service_description like '%';&lt;br /&gt;
 &lt;br /&gt;
 update service set service_locked=0 where service_description like '%';&lt;br /&gt;
&lt;br /&gt;
===Liste des VM pour un Datcenter===&lt;br /&gt;
&lt;br /&gt;
 /usr/lib/centreon/plugins/centreon_vmware_connector_client.pl --plugin=apps::vmware::connector::plugin --mode getmap --container='DC1_VDI' --connector-hostname localhost&lt;br /&gt;
&lt;br /&gt;
===Check des TimePeriodes en fonction d'un hoste===&lt;br /&gt;
&lt;br /&gt;
   SQL&lt;br /&gt;
 select concat( hosts.name,';',services.display_name,';check_period;',hosts.check_period) from services&lt;br /&gt;
 inner join hosts on services.host_id = hosts.host_id &lt;br /&gt;
 where services.check_period != hosts.check_period and services.check_period ='24X7;&lt;br /&gt;
&lt;br /&gt;
  Copier le résultat dans un fichier TMP.&lt;br /&gt;
 Lancer une requête CLAPI:&lt;br /&gt;
 ./ADD_Centreon.sh admin BZeGqxtGarc /tmp/tp_update.txt SERVICE setparam&lt;br /&gt;
&lt;br /&gt;
 Recharger Centreon.&lt;br /&gt;
 Faire check EZV&lt;/div&gt;</summary>
		<author><name>24.206.98.112</name></author>
		
	</entry>
	<entry>
		<id>http://wiki.les-noulot.fr/index.php?title=Centreon&amp;diff=403</id>
		<title>Centreon</title>
		<link rel="alternate" type="text/html" href="http://wiki.les-noulot.fr/index.php?title=Centreon&amp;diff=403"/>
		<updated>2023-04-19T14:01:41Z</updated>

		<summary type="html">&lt;p&gt;24.206.98.112 : &amp;lt;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;=Centreon=&lt;br /&gt;
&lt;br /&gt;
==Les valeurs par défaut des ACKNOWLEDGE dans les widgets==&lt;br /&gt;
&lt;br /&gt;
Il est possible de cocher des cases par défaut (sticky, notify...) en éditant le fichier suivant:&lt;br /&gt;
&lt;br /&gt;
 /usr/share/centreon/www/widgets/service-monitoring/src/acknowledge.ihtml&lt;br /&gt;
 La différence est l'ajout du mot &amp;quot;checked&amp;quot;.&lt;br /&gt;
&lt;br /&gt;
==Vérification config==&lt;br /&gt;
 /usr/sbin/centengine -v /etc/centreon-engine/centengine.cfg&lt;br /&gt;
&lt;br /&gt;
==RRDTools==&lt;br /&gt;
&lt;br /&gt;
 Check fichier rrdfile:&lt;br /&gt;
 rrdtool &amp;quot;nom du fichier .rrd&amp;quot;&lt;br /&gt;
&lt;br /&gt;
 log : &lt;br /&gt;
 tailf /var/log/centreon-broker/central-master-rrd.log&lt;br /&gt;
&lt;br /&gt;
 Taille des fichiers de rétention des Graphiques&lt;br /&gt;
 Configuration =&amp;gt; Centreon =&amp;gt; configuration =&amp;gt; Output&lt;br /&gt;
 Maximum size of file : 104857600&lt;br /&gt;
&lt;br /&gt;
==Check interface LAN windows==&lt;br /&gt;
&lt;br /&gt;
Permet de lister vos interfaces Windows&lt;br /&gt;
 /usr/lib64/nagios/plugins/centreon_plugins.pl --plugin=os::windows::snmp::plugin --hostname=X.X.X.X --snmp-version='2c' --snmp-community='XXX' --mode list-interfaces&lt;br /&gt;
&lt;br /&gt;
Vous pourrez ensuite superviser les interfaces via leur ID ou leur nom.&lt;br /&gt;
&lt;br /&gt;
Voici par exemple comment remonter le trafic d'une interface en utilisant son nom:&lt;br /&gt;
 /usr/lib64/nagios/plugins/centreon_plugins.pl --plugin=os::windows::snmp::plugin --hostname=X.X.X.X --snmp-version='2c' --snmp-community='XXX' --mode interfaces --name --interface  &lt;br /&gt;
 'ethernet_7' --add-traffic&lt;br /&gt;
&lt;br /&gt;
Vous pouvez remonter le traffic toutes les interfaces avec une seule et même en commande en ne spécifiant ni l'ID ni le nom.&lt;br /&gt;
Vous pouvez également utiliser des regexp dans le nom pour en remonter plusieurs:&lt;br /&gt;
 /usr/lib64/nagios/plugins/centreon_plugins.pl --plugin=os::windows::snmp::plugin --hostname=X.X.X.X --snmp-version='2c' --snmp-community='XXX' --mode interfaces --name --interface &lt;br /&gt;
 'ethernet_*' --add-traffic&lt;br /&gt;
&lt;br /&gt;
==Changer le owner des vue custum==&lt;br /&gt;
 use centreon;&lt;br /&gt;
 select * from custom_views&lt;br /&gt;
 Verifier le n° de la view dans Centreon en passant la sourie sur l'onglet de la vue.&lt;br /&gt;
 select * from custom_view_user_relation where custom_view_id='ID_VIEW';&lt;br /&gt;
 update custom_view_user_relation set locked='0' where custom_view_id='320' and user_id='ID_NEW_USER';&lt;br /&gt;
 update custom_view_user_relation set is_owner='1' where custom_view_id='320' and user_id='ID_NEW_USER'; (user_id=19 &amp;gt;adm-snoulot)&lt;br /&gt;
&lt;br /&gt;
===réaffecter les vues d'un user vers un autre===&lt;br /&gt;
Lui supprime les vues.&lt;br /&gt;
&lt;br /&gt;
 Lister les vues du user&lt;br /&gt;
&lt;br /&gt;
       select V.custom_view_id, V.name from custom_views as V&lt;br /&gt;
       inner join custom_view_user_relation as C on C.custom_view_id = V.custom_view_id&lt;br /&gt;
       where C.user_id = &amp;lt;&amp;lt;ID_USER&amp;gt;&amp;gt; and is_owner = 1;&lt;br /&gt;
&lt;br /&gt;
 Lister les vues du nouvel user&lt;br /&gt;
 &lt;br /&gt;
       select V.custom_view_id, V.name from custom_views as V&lt;br /&gt;
       inner join custom_view_user_relation as C on C.custom_view_id = V.custom_view_id&lt;br /&gt;
       where C.user_id = &amp;lt;&amp;lt;ID_USER&amp;gt;&amp;gt;;&lt;br /&gt;
&lt;br /&gt;
Comparer les 2 listes et exclure les vues présentes des 2 cotés et leurs changer le owner avec la procédure précédente.&lt;br /&gt;
Pour les autres utiliser la requête suivante:&lt;br /&gt;
&lt;br /&gt;
       update custom_view_user_relation set user_id='&amp;lt;&amp;lt;New_user_ID&amp;gt;&amp;gt;', locked='0', is_owner='1' &lt;br /&gt;
       where custom_view_id in (&amp;lt;&amp;lt;liste des custom_view_id séparés par des ','&amp;gt;&amp;gt;) and user_id='&amp;lt;&amp;lt;old_USER_ID&amp;gt;&amp;gt;';&lt;br /&gt;
&lt;br /&gt;
==Problème lié à des métriques erronées==&lt;br /&gt;
&lt;br /&gt;
Certains services étaient associés a des métriques incohérentes (métrique de cpu associé à un contrôle de disque, ou une métrique nommée à l'aide d'une apostrophe). &lt;br /&gt;
Ces métriques ne contient également aucune données. &lt;br /&gt;
Toutes ces incohérences étaient la source du dysfonctionnement des graphiques.&lt;br /&gt;
&lt;br /&gt;
Voici la méthode utilisée pour résoudre le problème :&lt;br /&gt;
 &lt;br /&gt;
 Se connecter au serveur MySQL et lister les métriques du service posant problème : &lt;br /&gt;
 Pour un host&lt;br /&gt;
 mysql&amp;gt; select metric_id, metric_name from index_data i, metrics m where i.host_name = 'FRCCEISSUP01' and i.service_description = 'DISK-Usage' and i.id = m.index_id;&lt;br /&gt;
 &lt;br /&gt;
 Pour tout les host&lt;br /&gt;
 mysql&amp;gt;select i.host_name, metric_id, metric_name from index_data i, metrics m where i.service_description = 'DISK-Usage' and i.id = m.index_id and metric_name like '\'';&lt;br /&gt;
 *************************** 1. row ***************************&lt;br /&gt;
 metric_id: 35987&lt;br /&gt;
 metric_name: /var/lib/centreon&lt;br /&gt;
 *************************** 2. row ***************************&lt;br /&gt;
 metric_id: 35986&lt;br /&gt;
 metric_name: /var/lib/mysql&lt;br /&gt;
 *************************** 3. row ***************************&lt;br /&gt;
 metric_id: 29686&lt;br /&gt;
 metric_name: /&lt;br /&gt;
 *************************** 4. row ***************************&lt;br /&gt;
 metric_id: 29687&lt;br /&gt;
 metric_name: /boot&lt;br /&gt;
 *************************** 5. row ***************************&lt;br /&gt;
 metric_id: 29688&lt;br /&gt;
 metric_name: /dev/shm&lt;br /&gt;
 *************************** 6. row ***************************&lt;br /&gt;
 metric_id: 38748&lt;br /&gt;
 metric_name: '&lt;br /&gt;
 6 rows in set (0.00 sec)&lt;br /&gt;
&lt;br /&gt;
Pour chaque métrique, vérifier que chacune contient des données à l'aide de la requête suivante (où ID METRIC correspond au champs metric_id précédent) :&lt;br /&gt;
 mysql&amp;gt; SELECT max(ctime) FROM data_bin WHERE id_metric = 'ID METRIC' ;&lt;br /&gt;
&lt;br /&gt;
Si le requête ne renvoie aucune donnée, ou si la métrique se nomme basiquement 'apostrophe&amp;quot;, la supprimer comme ci-dessous :&lt;br /&gt;
 mysql&amp;gt; update metrics set to_delete = '1' where metric_id = 'ID METRIC' ;&lt;br /&gt;
 Query OK, 1 row affected (0.00 sec)&lt;br /&gt;
 Rows matched: 1 Changed: 1 Warnings: 0&lt;br /&gt;
&lt;br /&gt;
Ensuite redémarrer le service cbd pour prendre en compte la suppression.&lt;br /&gt;
&lt;br /&gt;
 # /etc/init.d/cbd restart&lt;br /&gt;
 Stopping cbd_central-rrd: [ OK ]&lt;br /&gt;
 Stopping cbd_central-broker: [ OK ]&lt;br /&gt;
 Starting cbd_central-rrd: [ OK ]&lt;br /&gt;
 Starting cbd_central-broker: [ OK ]&lt;br /&gt;
&lt;br /&gt;
==Trouver un graphe erreur Centreon.==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Retourne ID service  (collone ID)&lt;br /&gt;
&lt;br /&gt;
 select * from centreon_storage.index_data where host_name like 'FRCCEISSUP04'; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Retourne les lignes du service (si ' supprimer la ligne) (ID = index_id)&lt;br /&gt;
&lt;br /&gt;
 Select * from centreon_storage.metrics where index_id like '4530'; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Requette graphe disk KO &lt;br /&gt;
&lt;br /&gt;
Affiche toutes les entrées avec une ' dans le nom&lt;br /&gt;
&lt;br /&gt;
 select * from centreon_storage.metrics where metric_name = &amp;quot;'&amp;quot;; &lt;br /&gt;
&lt;br /&gt;
===Clapi===&lt;br /&gt;
====Liste des objets et actions Centreon-Clapi v 1.3.1====&lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
!Objet !! Désignation !! Désignation   &lt;br /&gt;
|-&lt;br /&gt;
!   !! English !! Français&lt;br /&gt;
|-&lt;br /&gt;
|ACL||Access List||Liste d'accès&lt;br /&gt;
|-&lt;br /&gt;
|ACLACTION||Actions Access||Gestion des accès sur les actions&lt;br /&gt;
|-&lt;br /&gt;
|ACLGROUP||Access Groups||Gestion des groupe d'accès&lt;br /&gt;
|-&lt;br /&gt;
|ACLMENU||Menus Access||Gestion des accès aux menus&lt;br /&gt;
|-&lt;br /&gt;
|ACLRESOURCE||Ressources Access||Gestion des accès aux ressources&lt;br /&gt;
|-&lt;br /&gt;
|CG||Contact Groups||Groupes de contacts&lt;br /&gt;
|-&lt;br /&gt;
|CGICFG||cgi Nagios||cgi Nagios&lt;br /&gt;
|-&lt;br /&gt;
|CMD||Commands||Commandes&lt;br /&gt;
|-&lt;br /&gt;
|CONTACT||Contacts / Users||Contacts / Utilisateurs&lt;br /&gt;
|-&lt;br /&gt;
|CONTACTTPL||Contact Template||Modèles de contact&lt;br /&gt;
|-&lt;br /&gt;
|HC||Hosts Catégories||Catégories d'hôtes&lt;br /&gt;
|-&lt;br /&gt;
|HG||Hosts Groups||Groupes d'hôtes&lt;br /&gt;
|-&lt;br /&gt;
|HOST||Hosts||Hôtes&lt;br /&gt;
|-&lt;br /&gt;
|HTPL||Hosts Template||Modèle d'hôtes&lt;br /&gt;
|-&lt;br /&gt;
|INSTANCE||Poller||Collecteur&lt;br /&gt;
|-&lt;br /&gt;
|LDAP||Ldap||Ldap&lt;br /&gt;
|-&lt;br /&gt;
|NAGIOSCFG||nagios.cfg Nagios||nagios.cfg Nagios&lt;br /&gt;
|-&lt;br /&gt;
|NDO2DBCFG||ndo2db.cfg NDOutils||ndo2db.cfg NDOutils&lt;br /&gt;
|-&lt;br /&gt;
|NDOMODCFG||ndomod.cfg NDOutils||ndomod.cfg NDOutils&lt;br /&gt;
|-&lt;br /&gt;
|RESOURCECFG||Resources Nagios||Ressources Nagios&lt;br /&gt;
|-&lt;br /&gt;
|SC||Services Catégories||Catégories de services&lt;br /&gt;
|-&lt;br /&gt;
|SERVICE||Services||Services&lt;br /&gt;
|-&lt;br /&gt;
|SG||Services Groups||Groupes de services&lt;br /&gt;
|-&lt;br /&gt;
|STPL||Services Template||Modèle de services&lt;br /&gt;
|-&lt;br /&gt;
|TIMEPERIOD||Time periods||Périodes temporelles&lt;br /&gt;
|}&lt;br /&gt;
 &lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
! ACTION !! OBJET SUPERVISEUR&lt;br /&gt;
|-&lt;br /&gt;
|ADD||ACLACTION, ACLGROUP, ACLMENU, ACLRESOURCE, CGICFG, CMD, CONTACT, CONTACTTPL, CG, HTPL, HOST, HG, HC, INSTANCE, LDAP, NAGIOSCFG,NDO2DBCFG, NDOMODCFG, RESOURCECFG, STPL, SERVICE, SG, SC, TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|ADDCONTACT||CG, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|ADDCONTACTGROUP||ACLGROUP, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|ADDHOST||STPL&lt;br /&gt;
|-&lt;br /&gt;
|ADDHOSTGROUP||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|ADDMEMBER||HG, HC&lt;br /&gt;
|-&lt;br /&gt;
|ADDPARENT||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|ADDRESOURCE||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|ADDSERVICE||SG, SC&lt;br /&gt;
|-&lt;br /&gt;
|ADDSERVICETEMPLATE||SC&lt;br /&gt;
|-&lt;br /&gt;
|ADDTEMPLATE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|APPLYTPL||HOST&lt;br /&gt;
|-&lt;br /&gt;
|CFGMOVE||&lt;br /&gt;
|-&lt;br /&gt;
|DEL||ACLACTION, ACLGROUP, ACLMENU, ACLRESOURCE, CGICFG, CMD, CONTACT, CONTACTTPL, CG, HTPL, HOST, HG, HC, INSTANCE, LDAP, NAGIOSCFG, NDO2DBCFG, NDOMODCFG, RESOURCECFG, STPL, SERVICE, SG, SC, TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|DELACTION||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|DELCONTACT||ACLGROUP, CG, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|DELCONTACTGROUP||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|DELEXCEPTION||TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|DELHOST||STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|DELHOSTGROUP||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|DELHOSTGROUPSERVICE||SG&lt;br /&gt;
|-&lt;br /&gt;
|DELMACRO||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|DELMEMBER||HG, HC&lt;br /&gt;
|-&lt;br /&gt;
|DELPARENT||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|DELSERVICE||SG, SC&lt;br /&gt;
|-&lt;br /&gt;
|DELSERVICETEMPLATE||SC&lt;br /&gt;
|-&lt;br /&gt;
|DELTEMPLATE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|DISABLE||CONTACT, CONTACTTPL, CG, HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|ENABLE||CONTACT, CONTACTTPL, CG, HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|GETACTION||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|GETACLGROUP||ACLACTION, ACLMENU, ACLRESOURCE, CONTACT, CONTACTTPL&lt;br /&gt;
|-&lt;br /&gt;
|GETCONTACT||ACLGROUP, CG, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|GETCONTACTGROUP||ACLGROUP, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|GETEXCEPTION||TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|GETHOSTGROUP||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|GETHOSTGROUPSERVICE||SG&lt;br /&gt;
|-&lt;br /&gt;
|GETMACRO||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|GETMEMBER||HG, HC&lt;br /&gt;
|-&lt;br /&gt;
|GETMENU||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|GETPARENT||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|GETRESOURCE||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|GETSERVICE||SG, SC&lt;br /&gt;
|-&lt;br /&gt;
|GETSERVICETEMPLATE||SC&lt;br /&gt;
|-&lt;br /&gt;
|GETTEMPLATE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|GRANT||ACLACTION, ACLMENU&lt;br /&gt;
|-&lt;br /&gt;
|LASTRELOAD||ACL&lt;br /&gt;
|-&lt;br /&gt;
|POLLERGENERATE||&lt;br /&gt;
|-&lt;br /&gt;
|POLLERLIST||&lt;br /&gt;
|-&lt;br /&gt;
|POLLERRELOAD||&lt;br /&gt;
|-&lt;br /&gt;
|POLLERESTART||&lt;br /&gt;
|-&lt;br /&gt;
|POLLERTEST||&lt;br /&gt;
|-&lt;br /&gt;
|RELOAD	ACL||&lt;br /&gt;
|-&lt;br /&gt;
|REVOKE||ACLACTION, ACLMENU&lt;br /&gt;
|-&lt;br /&gt;
|SETCONTACT||ACLGROUP, CG, HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|SETCONTACTGROUP||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|SETCONTACTTEMPLATE||LDAP&lt;br /&gt;
|-&lt;br /&gt;
|SETEXCEPTION||TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|SETHOST||STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|SETHOSTGROUP||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|SETHOSTGROUPSERVICE||SG&lt;br /&gt;
|-&lt;br /&gt;
|SETINSTANCE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|SETMACRO||HTPL, HOST, STPL, SERVICE&lt;br /&gt;
|-&lt;br /&gt;
|SETMEMBER||HG, HC&lt;br /&gt;
|-&lt;br /&gt;
|SETMENU||ACLGROUP&lt;br /&gt;
|-&lt;br /&gt;
|SETPARAM||ACLACTION, ACLGROUP, ACLMENU, ACLRESOURCE, CGICFG, CMD, CONTACT, CONTACTTPL, CG, HTPL, HOST, HG, INSTANCE, LDAP, NAGIOSCFG, NDO2DBCFG, NDOMODCFG, RESOURCECFG, STPL, SERVICE, SG, SC, TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|SETPARENT||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|SETSERVICE||SG&lt;br /&gt;
|-&lt;br /&gt;
|SETTEMPLATE||HTPL, HOST&lt;br /&gt;
|-&lt;br /&gt;
|SHOW||ACLACTION, ACLGROUP, ACLMENU, ACLRESOURCE, CGICFG, CMD, CONTACT, CONTACTTPL, CG, HTPL, HOST, HG, HC, INSTANCE, LDAP, NAGIOSCFG, NDO2DBCFG, NDOMODCFG, RESOURCECFG, STPL, SERVICE, SG, SC, TIMEPERIOD&lt;br /&gt;
|-&lt;br /&gt;
|UNSETACLGROUP||CONTACT, CONTACTTPL&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
==BAM==&lt;br /&gt;
&lt;br /&gt;
===ClapiBAM===&lt;br /&gt;
&lt;br /&gt;
Ajout KPI &lt;br /&gt;
 centreon -u admin -p BZeGqxtGarc -o KPI -a ADD -v 'service;FRCCESGAPA01|CPU;IBM_Cognos_TM1;Weak;Minor;Major'&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Trucs==&lt;br /&gt;
&lt;br /&gt;
===Redimensionnement des Services name en configuration.===&lt;br /&gt;
&lt;br /&gt;
 Modifier la ligne 65 du fichier :&lt;br /&gt;
 /usr/share/centreon/www/include/configuration/configObject/service/listService.ihtml&lt;br /&gt;
 &lt;br /&gt;
 &amp;lt;td class=&amp;quot;ListColLeft '''resizeTitle'''&amp;quot;&amp;gt;&lt;br /&gt;
 en&lt;br /&gt;
 &amp;lt;td class=&amp;quot;ListColLeft&amp;quot;&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===Mysql recheche des status===&lt;br /&gt;
&lt;br /&gt;
====Remonte tout les hosts et services en Critique et / ou inconnue====&lt;br /&gt;
 SELECT hostgroups.hostgroup_id, hostgroups.name AS HostGroup, hosts.host_id, hosts.name AS Hosts, hosts.state, services.description AS Services, services.state &lt;br /&gt;
  FROM hostgroups, hosts_hostgroups, hosts, services &lt;br /&gt;
  WHERE hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id &lt;br /&gt;
  AND hosts_hostgroups.host_id = hosts.host_id &lt;br /&gt;
  AND services.host_id = hosts.host_id &lt;br /&gt;
  AND hosts.enabled='1' &lt;br /&gt;
  AND services.enabled='1' &lt;br /&gt;
  AND hostgroups.name = 'hg-sextant'&lt;br /&gt;
  AND hosts.state in ('2','3')&lt;br /&gt;
  OR hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id &lt;br /&gt;
  AND hosts_hostgroups.host_id = hosts.host_id &lt;br /&gt;
  AND services.host_id = hosts.host_id &lt;br /&gt;
  AND hosts.enabled='1' &lt;br /&gt;
  AND services.enabled='1' &lt;br /&gt;
  AND hostgroups.name = 'hg-sextant'&lt;br /&gt;
  AND services.state in ('2','3');&lt;br /&gt;
&lt;br /&gt;
====Remonte tout les hosts et services en Critique et / ou inconnue non Acknowledged====&lt;br /&gt;
 SELECT hostgroups.hostgroup_id, hostgroups.name AS HostGroup, hosts.host_id, hosts.name AS Hosts, hosts.state, hosts.acknowledged As Acknowledged, services.description AS Services, services.state,    &lt;br /&gt;
  services.acknowledged As Acknowledged &lt;br /&gt;
  FROM hostgroups, hosts_hostgroups, hosts, services &lt;br /&gt;
  WHERE hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id &lt;br /&gt;
  AND hosts_hostgroups.host_id = hosts.host_id &lt;br /&gt;
  AND services.host_id = hosts.host_id &lt;br /&gt;
  AND hosts.enabled='1' &lt;br /&gt;
  AND services.enabled='1' &lt;br /&gt;
  AND hostgroups.name = 'hg-sextant'&lt;br /&gt;
  AND hosts.state in ('2','3')&lt;br /&gt;
  AND hosts.acknowledged = 0&lt;br /&gt;
  OR hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id &lt;br /&gt;
  AND hosts_hostgroups.host_id = hosts.host_id &lt;br /&gt;
  AND services.host_id = hosts.host_id &lt;br /&gt;
  AND hosts.enabled='1' &lt;br /&gt;
  AND services.enabled='1' &lt;br /&gt;
  AND hostgroups.name = 'hg-sextant'&lt;br /&gt;
  AND services.state in ('2','3')&lt;br /&gt;
  AND services.acknowledged = 0;&lt;br /&gt;
&lt;br /&gt;
====Remonte les indicateurs sans downtime n'y Acknoledged====&lt;br /&gt;
  use centreon_storage;&lt;br /&gt;
&lt;br /&gt;
 /*select HOST*/&lt;br /&gt;
 select concat(count(distinct(hosts.name)),':hosts') as 'RESULT'&lt;br /&gt;
 from hosts&lt;br /&gt;
  inner join hosts_hostgroups on hosts.host_id = hosts_hostgroups.host_id&lt;br /&gt;
  inner join hostgroups on hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id&lt;br /&gt;
 where hosts.enabled=1&lt;br /&gt;
 and hosts.state != 0&lt;br /&gt;
 and hosts.acknowledged = 0&lt;br /&gt;
 and hostgroups.name = 'HG-SEXTANT'&lt;br /&gt;
 and hosts.host_id not in ( select downtimes.host_id from downtimes where actual_end_time is null and cancelled = 0 )&lt;br /&gt;
 union&lt;br /&gt;
 /*select services*/&lt;br /&gt;
 select concat(count(distinct(hosts.name)),':services') as 'RESULT'&lt;br /&gt;
 from services&lt;br /&gt;
  inner join hosts on hosts.host_id = services.host_id&lt;br /&gt;
  inner join hosts_hostgroups on services.host_id = hosts_hostgroups.host_id&lt;br /&gt;
  inner join hostgroups on hostgroups.hostgroup_id = hosts_hostgroups.hostgroup_id&lt;br /&gt;
  where&lt;br /&gt;
  hosts.enabled=1&lt;br /&gt;
  AND services.enabled=1&lt;br /&gt;
  AND services.state in (2,3)&lt;br /&gt;
  AND services.acknowledged = 0&lt;br /&gt;
  AND hostgroups.name = 'HG-SEXTANT'&lt;br /&gt;
  AND services.host_id not in ( select downtimes.host_id from downtimes where actual_end_time is null and cancelled = 0 )&lt;br /&gt;
  AND hosts.acknowledged = 0&lt;br /&gt;
  AND services.service_id != '26732';&lt;br /&gt;
&lt;br /&gt;
====Liste service template====&lt;br /&gt;
&lt;br /&gt;
 select * from service where service_register = '0';&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=====Liste service Template avec commentaire et exemple argument=====&lt;br /&gt;
&lt;br /&gt;
 select service_id,service_description,'|',service_comment,'|',command_command_id_arg &lt;br /&gt;
 from service&lt;br /&gt;
 where service_register = '0' and service_description not like 'Generic%' order by service_id ; &lt;br /&gt;
&lt;br /&gt;
=====Liste des service Template avec description des arguments=====&lt;br /&gt;
&lt;br /&gt;
 select service_id,service_description,'|',macro_description&lt;br /&gt;
 from service&lt;br /&gt;
 inner join command_arg_description&lt;br /&gt;
 on cmd_id = command_command_id&lt;br /&gt;
 where service_register = '0' and service_description not like 'Generic%' order by service_id ;&lt;br /&gt;
&lt;br /&gt;
=====Check catégorie service=====&lt;br /&gt;
&lt;br /&gt;
 SELECT service_id, service_description FROM service WHERE service_id NOT IN (SELECT service_service_id FROM service_categories_relation) AND service_register = '1';&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Clear cashe sonde swap===&lt;br /&gt;
&lt;br /&gt;
sur le poller où est testé le host, supprimer le fichier /var/lib/centreon/centplugins/remote_storage_cache_$HOST$&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Ajout Vues personnalisées===&lt;br /&gt;
&lt;br /&gt;
Récuperation widget_id&lt;br /&gt;
 select * from widgets where title like 'Proc%' ;&lt;br /&gt;
Récuperation custom_view_id &lt;br /&gt;
 select custom_view_id from widget_views where widget_id = $widget_id$ ;&lt;br /&gt;
Récuperation contact_id&lt;br /&gt;
 select contact_alias, contact_id from contact where contact_alias like '%user%';&lt;br /&gt;
Création view pour un utilisateur&lt;br /&gt;
 insert into custom_view_user_relation (custom_view_id,user_id,locked,is_owner,is_consumed)  values($custom_view_id$,$user_id$,1,0,1);&lt;br /&gt;
&lt;br /&gt;
===Liste les HG des serveurs actif===&lt;br /&gt;
&lt;br /&gt;
 select h.host_id,h.host_name,h.host_activate, HG.hg_name from host as h &lt;br /&gt;
 inner join hostgroup_relation as HR on HR.host_host_id = h.host_id&lt;br /&gt;
 inner join hostgroup as HG on HG.hg_id = HR.hostgroup_hg_id&lt;br /&gt;
 where h.host_activate = '1';&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===delock model de service===&lt;br /&gt;
&lt;br /&gt;
 select * from service where service_register = '0'  and service_description like '%';&lt;br /&gt;
 &lt;br /&gt;
 update service set service_locked=0 where service_description like '%';&lt;br /&gt;
&lt;br /&gt;
===Liste des VM pour un Datcenter===&lt;br /&gt;
&lt;br /&gt;
 /usr/lib/centreon/plugins/centreon_vmware_connector_client.pl --plugin=apps::vmware::connector::plugin --mode getmap --container='DC1_VDI' --connector-hostname localhost&lt;br /&gt;
&lt;br /&gt;
===Check des TimePeriodes en fonction d'un hoste===&lt;br /&gt;
&lt;br /&gt;
   SQL&lt;br /&gt;
 select concat( hosts.name,';',services.display_name,';check_period;',hosts.check_period) from services&lt;br /&gt;
 inner join hosts on services.host_id = hosts.host_id &lt;br /&gt;
 where services.check_period != hosts.check_period and services.check_period ='24X7;&lt;br /&gt;
&lt;br /&gt;
  Copier le résultat dans un fichier TMP.&lt;br /&gt;
 Lancer une requête CLAPI:&lt;br /&gt;
 ./ADD_Centreon.sh admin BZeGqxtGarc /tmp/tp_update.txt SERVICE setparam&lt;br /&gt;
&lt;br /&gt;
 Recharger Centreon.&lt;br /&gt;
 Faire check EZV&lt;/div&gt;</summary>
		<author><name>24.206.98.112</name></author>
		
	</entry>
</feed>