/* form a valid sql statement for device_id */
$selection = "WHERE " . str_replace("id", "device_id", array_to_sql_or($devices, "id")) . " ";
}
if (isset($graph_template_id) && !($graph_template_id === 0) && (db_fetch_cell("SELECT id FROM graph_templates WHERE id=$graph_template_id"))) {
/* form a valid sql statement for device_id */
$selection .= (strlen($selection) ? " AND " : " WHERE ") . " graph_templates.id=" . $graph_template_id;
}
$columns = array();
$graphs = getGraphs($selection, $columns);
$title = __("List of existing graphs for given device selection");
/* display matching devices */
displayGenericArray($graphs, $columns, $title, $quietMode);
}
} else {
display_help($me);
exit(1);
}
function display_help($me) {
echo "List Graphs Script 1.0" . ", " . __("Copyright 2004-2010 - The Cacti Group") . "\n";
echo __("A simple command line utility to list graphs in Cacti") . "\n\n";
echo __("usage: ") . $me . " --device-id=[ID] --graph-template-id=[ID] [--graph-id=]\n\n";
echo __("List Options:") . "\n";
echo " --list-graph-templates [--device-template-id=[ID]]\n";
echo " --list-input-fields --graph-template-id=[ID]\n";
/* get devices matching criteria */
$devices = getDevices($device);
if (!sizeof($devices)) {
$data_queries = getSNMPQueries();
displaySNMPQueries($data_queries, $quietMode);
} else {
$columns = array();
if (isset($dq["snmp_query_id"])) {
$data_queries = getSNMPQueriesByDevices($devices, $dq["snmp_query_id"], $columns);
} else {
$data_queries = getSNMPQueriesByDevices($devices, '', $columns);
}
$title = __("List of Data Queries for given Devices");
# these are the table columns for display
displayGenericArray($data_queries, $columns, $title, $quietMode);
}
}else{
$data_queries = getSNMPQueries();
displaySNMPQueries($data_queries, $quietMode);
}
function display_help($me) {
echo "List Data Query Script 1.0" . ", " . __("Copyright 2004-2010 - The Cacti Group") . "\n";
echo __("A simple command line utility to list data queries in Cacti") . "\n\n";
echo __("usage: ") . $me . " [--data-query-id=] [--reindex-method=] [--device-id=] [--site-id=] [--poller-id=]\n";
echo " [--description=] [--ip=] [--template=] [--notes=\"[]\"] [--disabled]\n";
echo " [--avail=[pingsnmp]] [--ping-method=[tcp] --ping-port=[N/A, 1-65534]] --ping-retries=[2] --ping-timeout=[500]\n";
echo " [--version=1] [--community=] [--port=161] [--timeout=500]\n";
echo " [--username= --password=] [--authproto=] [--privpass= --privproto=] [--context=]\n";
echo " [--quiet]\n\n";
