SELECT host_name,
  host_alias,
  host_address
FROM centreon.host
WHERE host_register="1"
AND host_activate='1';

SELECT host_name,
  host_alias,
  host_address
FROM centreon.host
WHERE host_register="1"
AND host_activate='1';

SELECT host_name,
  host_alias
FROM centreon.host
where host_register="0"
AND host_activate="1"
AND (host_name like "%Centreon%" OR host_name like "%Linux%")
ORDER BY host_name;

SELECT host_name,
  host_alias
FROM centreon.host
where host_register="0"
AND host_activate="1"
AND (host_name like "%Centreon%" OR host_name like "%Linux%")
ORDER BY host_name;

SELECT HST.host_name AS Host,
  HTPL.host_name AS Template
FROM centreon.host as HST
LEFT JOIN centreon.host_template_relation AS HTR ON HTR.host_host_id=HST.host_id
LEFT JOIN centreon.host as HTPL ON HTPL.host_id=HTR.host_tpl_id
WHERE HST.host_register="1"
AND HST.host_activate="1"

SELECT HST.host_name AS Host,
  HTPL.host_name AS Template
FROM centreon.host as HST
LEFT JOIN centreon.host_template_relation AS HTR ON HTR.host_host_id=HST.host_id
LEFT JOIN centreon.host as HTPL ON HTPL.host_id=HTR.host_tpl_id
WHERE HST.host_register="1"
AND HST.host_activate="1"

SELECT HST.host_name AS HOST,
  HTPL.host_name AS Host
FROM centreon.host as HTPL
LEFT JOIN centreon.host_template_relation AS HTR ON HTR.host_tpl_id=HTPL.host_id
LEFT JOIN centreon.host AS HST ON HTR.host_host_id=HST.host_id
WHERE HTPL.host_register="0"
AND HTPL.host_activate="1"
AND HST.host_register="1"
ORDER BY HST.host_name,HTPL.host_name;

SELECT HST.host_name AS HOST,
  HTPL.host_name AS Host
FROM centreon.host as HTPL
LEFT JOIN centreon.host_template_relation AS HTR ON HTR.host_tpl_id=HTPL.host_id
LEFT JOIN centreon.host AS HST ON HTR.host_host_id=HST.host_id
WHERE HTPL.host_register="0"
AND HTPL.host_activate="1"
AND HST.host_register="1"
ORDER BY HST.host_name,HTPL.host_name;

SELECT HST.host_name AS HOST,
  HTPL.host_name AS Host
FROM centreon.host_template_relation AS HTR
LEFT JOIN centreon.host AS HTPL ON HTR.host_tpl_id=HTPL.host_id
LEFT JOIN centreon.host AS HST ON HTR.host_host_id=HST.host_id
WHERE HTPL.host_register="0"
AND HTPL.host_activate="1"
AND HST.host_register="1"
ORDER BY HST.host_name,HTPL.host_name ;

SELECT HST.host_name AS HOST,
  HTPL.host_name AS Host
FROM centreon.host_template_relation AS HTR
LEFT JOIN centreon.host AS HTPL ON HTR.host_tpl_id=HTPL.host_id
LEFT JOIN centreon.host AS HST ON HTR.host_host_id=HST.host_id
WHERE HTPL.host_register="0"
AND HTPL.host_activate="1"
AND HST.host_register="1"
ORDER BY HST.host_name,HTPL.host_name ;

SELECT HST.host_name,
  HST.host_address,
  SVC.service_description
FROM centreon.service AS SVC
LEFT JOIN centreon.host_service_relation AS HSR ON HSR.service_service_id=SVC.service_id
LEFT JOIN centreon.host AS HST ON HST.host_id=HSR.host_host_id
WHERE HST.host_register="1"
AND HST.host_activate="1"
ORDER BY HST.host_name,SVC.service_description;

SELECT HST.host_name,
  HST.host_address,
  SVC.service_description
FROM centreon.service AS SVC
LEFT JOIN centreon.host_service_relation AS HSR ON HSR.service_service_id=SVC.service_id
LEFT JOIN centreon.host AS HST ON HST.host_id=HSR.host_host_id
WHERE HST.host_register="1"
AND HST.host_activate="1"
ORDER BY HST.host_name,SVC.service_description;

SELECT HST.host_name,
  HST.host_address,
  SVC.service_description
FROM centreon.host AS HST
LEFT JOIN centreon.host_service_relation AS HSR ON HSR.host_host_id=HST.host_id
LEFT JOIN centreon.service AS SVC ON SVC.service_id=HSR.service_service_id
WHERE HST.host_register="1"
AND HST.host_activate="1"
ORDER BY HST.host_name,SVC.service_description;

SELECT HST.host_name,
  HST.host_address,
  SVC.service_description
FROM centreon.host AS HST
LEFT JOIN centreon.host_service_relation AS HSR ON HSR.host_host_id=HST.host_id
LEFT JOIN centreon.service AS SVC ON SVC.service_id=HSR.service_service_id
WHERE HST.host_register="1"
AND HST.host_activate="1"
ORDER BY HST.host_name,SVC.service_description;

SELECT HG.hg_name AS HOSTGROUP,
HG.hg_alias AS DESCRIPTION,
HST.host_name AS HOST
FROM centreon.host AS HST
LEFT JOIN centreon.hostgroup_relation AS HGR ON HGR.host_host_id=HST.host_id
LEFT JOIN centreon.hostgroup AS HG ON HG.hg_id=HGR.hostgroup_hg_id
WHERE HST.host_activate="1"
AND HST.host_register="1"
ORDER BY HG.hg_name,HST.host_name;

SELECT HG.hg_name AS HOSTGROUP,
HG.hg_alias AS DESCRIPTION,
HST.host_name AS HOST
FROM centreon.host AS HST
LEFT JOIN centreon.hostgroup_relation AS HGR ON HGR.host_host_id=HST.host_id
LEFT JOIN centreon.hostgroup AS HG ON HG.hg_id=HGR.hostgroup_hg_id
WHERE HST.host_activate="1"
AND HST.host_register="1"
ORDER BY HG.hg_name,HST.host_name;

SELECT HG.hg_name AS HOSTGROUP,
HG.hg_alias AS DESCRIPTION,
HST.host_name AS HOST
FROM centreon.hostgroup AS HG
LEFT JOIN centreon.hostgroup_relation AS HGR ON HGR.hostgroup_hg_id=HG.hg_id
LEFT JOIN centreon.host AS HST ON HST.host_id=HGR.host_host_id
WHERE HST.host_activate="1"
AND HST.host_register="1"
ORDER BY HG.hg_name,HST.host_name;

SELECT HG.hg_name AS HOSTGROUP,
HG.hg_alias AS DESCRIPTION,
HST.host_name AS HOST
FROM centreon.hostgroup AS HG
LEFT JOIN centreon.hostgroup_relation AS HGR ON HGR.hostgroup_hg_id=HG.hg_id
LEFT JOIN centreon.host AS HST ON HST.host_id=HGR.host_host_id
WHERE HST.host_activate="1"
AND HST.host_register="1"
ORDER BY HG.hg_name,HST.host_name;

SELECT HST.host_name AS HOST,
HC.hc_name AS HOSTCATEGORY
FROM centreon.host AS HST
LEFT JOIN centreon.hostcategories_relation AS HCR ON HCR.host_host_id=HST.host_id
LEFT JOIN centreon.hostcategories AS HC ON HC.hc_id=HCR.hostcategories_hc_id
WHERE HST.host_activate="1"
AND HST.host_register="1"
ORDER BY HC.hc_name,HST.host_name;

SELECT HST.host_name AS HOST,
HC.hc_name AS HOSTCATEGORY
FROM centreon.host AS HST
LEFT JOIN centreon.hostcategories_relation AS HCR ON HCR.host_host_id=HST.host_id
LEFT JOIN centreon.hostcategories AS HC ON HC.hc_id=HCR.hostcategories_hc_id
WHERE HST.host_activate="1"
AND HST.host_register="1"
ORDER BY HC.hc_name,HST.host_name;

SELECT HST.host_name AS HOST,
HC.hc_name AS HOSTCATEGORY
FROM centreon.hostcategories AS HC
LEFT JOIN centreon.hostcategories_relation AS HCR ON HCR.hostcategories_hc_id=HC.hc_id
LEFT JOIN centreon.host AS HST ON HST.host_id=HCR.host_host_id
WHERE HST.host_activate="1"
AND HST.host_register="1"
ORDER BY HC.hc_name,HST.host_name;

SELECT HST.host_name AS HOST,
HC.hc_name AS HOSTCATEGORY
FROM centreon.hostcategories AS HC
LEFT JOIN centreon.hostcategories_relation AS HCR ON HCR.hostcategories_hc_id=HC.hc_id
LEFT JOIN centreon.host AS HST ON HST.host_id=HCR.host_host_id
WHERE HST.host_activate="1"
AND HST.host_register="1"
ORDER BY HC.hc_name,HST.host_name;