gilles Cacti User
Joined: 12 Jul 2005 Posts: 216
|
Posted: Wed Dec 05, 2007 10:57 am Post subject: listings graphs |
|
|
i don't know if i can ask this here...
can i have a sql statement for listing the graphs ids per host ?
this sql statement must list only graphs ids which have the associated datasource on
currently, i have this :
| Code: | | $sql = "SELECT * FROM graph_local where host_id = '<id>'"; |
this give me 6 results on a particular host and i know this host have only 5 graphs and 5 datasources
and i don't know how to select only graphs with active datasources
thanks |
|