Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support
It is currently Sat Oct 25, 2014 3:38 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: SQL Query For Relating Host, RRD File (rra), and Graph ID
PostPosted: Mon Sep 13, 2010 5:04 pm 
Offline
Cacti User

Joined: Sat Feb 23, 2008 10:41 am
Posts: 61
Location: Flint, Michigan
I wrote a script, which in an archaic way references the RRD # and host id (I have a structured directory) and sends it to a script on my cacti server from my web server, then returns the data as XML, then it also pulls the graph from an internal path on the webserver where graphs are exported. All works fine, but I see I need 3 pieces of information for it to work: graph id, rrd #, and host number. In essence I was looking for a way to get two of them and giving only one, but I am unable to find the pieces to put them together in one query. Is anyone with insight into the DB structure help me relate these? I also realize you need something to specify the graph type, what would be the easiest way to do this, assuming I would hard code this option.

P.S.- The witness told me to look, but after an hour and a half I can't seem to find anything similar.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Sep 14, 2010 9:33 am 
Offline
Developer
User avatar

Joined: Thu Dec 02, 2004 2:46 am
Posts: 22461
Location: Muenster, Germany
Please see http://docs.cacti.net/manual:087:99_ref ... ase_design
R.

_________________
Official Cacti Documentation
Official Debugging Help
Central Plugin Repository
Central Templates Repository


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 17, 2010 8:35 am 
Offline
Cacti User

Joined: Sat Feb 23, 2008 10:41 am
Posts: 61
Location: Flint, Michigan
Thank you gandalf, this really does help, but I am noticing one thing that is causing an issue for the query I am trying to write. In graph_tree_items rra_id appears as it relates to the id column in rra, but in my graph_tree_items tables, the entire rra_id column are 1's


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group