Nagios Support Forum

Code: Select all

SELECT 
    h.display_name AS child,
    h.host_object_id child_object_id,
    p.parent_host_object_id,
    o.name1 parent_name
FROM
    nagios.nagios_hosts h
        JOIN
    nagios.nagios_host_parenthosts p ON p.host_id = h.host_id
        JOIN
    nagios.nagios_objects o ON o.object_id = p.parent_host_object_id
WHERE
    h.display_name = 'testapihost';

Code: Select all

<?php

// include the xi component helper
require_once(dirname(__FILE__) . '/../componenthelper.inc.php');

// Testing the inclusion of the common include
require_once(dirname(__FILE__) . '../../../common.inc.php');

// define/call our component initialize function
toddcustomendpoints_component_init();
function toddcustomendpoints_component_init()
{

    // information to pass to xi about our component
    $args = array(
        COMPONENT_NAME =>           "toddcustomendpoints",
        COMPONENT_VERSION =>        "1.0",
        COMPONENT_AUTHOR =>         "todd, LLC",
        COMPONENT_DESCRIPTION =>    "todd Nagios XI Custom API Endpoints",
        COMPONENT_TITLE =>          "todd retrieve data operations"
        );

    // register with xi
    register_component("toddcustomendpoints", $args);

    // register todd custom api handlers
    register_custom_api_callback('todd', 'host', 'toddcustomendpoints_todd_host');
    register_custom_api_callback('todd', 'hostgroup', 'toddcustomendpoints_todd_hostgroup');
}

// Returns host and host's parents separated with comma. First element in $args is host name
function toddcustomendpoints_todd_host($endpoint, $verb, $args) {
    // Validate first element in $args
	if (sizeof($args) == 0) {
		return '{ "error":"host argument not found and is required" }';
	}
	
    $sql = "
		SELECT 
			h2.host_name parent_host
		FROM
			tbl_host h
				JOIN
			tbl_lnkHostToHost hh ON hh.idMaster = h.id
				JOIN
			tbl_host h2 ON h2.id = hh.idSlave
		WHERE
			h.host_name = '" . $args[0] . "';	
	";
	
	$host = $args[0];
	$parents = '';	
    $rs = exec_sql_query(DB_NAGIOSQL, $sql);
	
	// Concatenate parent names
	while($row = $rs->FetchRow()) {
		$parents = $parents . ',' . $row['parent_host'];
	}
	
	// Strip leading comma
	$parents = substr($parents, 1);
	
    return '{ "host_name":"' . $host . '", "parents":"' . $parents . '" }';
}

// Returns hostgroup and groups members separated with comma. First element in $args is hostgroup_name
function toddcustomendpoints_todd_hostgroup($endpoint, $verb, $args) {
    // Validate first element in $args
	if (sizeof($args) == 0) {
		return '{ "error":"host argument not found and is required" }';
	}
	
    $sql = "
		SELECT 
			h.host_name
		FROM
			tbl_hostgroup hg
				JOIN
			tbl_lnkHostgroupToHost hgh ON hgh.idMaster = hg.id
				JOIN
			tbl_host h ON h.id = hgh.idSlave
		WHERE
			hg.hostgroup_name = '" . $args[0] . "';	
	";
	
	$hostGroup = $args[0];
	$hosts = '';	
    $rs = exec_sql_query(DB_NAGIOSQL, $sql);
	
	// Concatenate parent names
	while($row = $rs->FetchRow()) {
		$hosts = $hosts . ',' . $row['host_name'];
	}
	
	// Strip leading comma
	$hosts = substr($hosts, 1);
	
    return '{ "hostgroup_name":"' . $hostGroup . '", "members":"' . $hosts . '" }';
}

?>