/* 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";