[SOLVED]Use cacti mysql to find device graphs

[eholz1]

Hello,

Is there a way to find out how many graphs a cacti device has using MySQL?
I have checked various tables, etc but without success.

I have a need to find out if a device has graphs. The issue comes from a user going
in to cacti, and changing the ip and not the device name, breaks the graphs.

The only way I have found to fix it - is to delete the graphs from the device with new ip
and recrete the graphs,

Any suggestions?

eholz1

[Rno]

You can check into graph_local and make a linke with host using graph-local.host_id like that
SELECT * FROM host, graph_local WHERE host.id=graph_local.host_id AND host.id = 1


the host.id = 1 is the host you would like to have the graph listing

[Rno]

Or more optimized:
SELECT * FROM host INNER JOIN graph_local WHERE host.id=graph_local.host_id AND host.id = 1

[eholz1]

Hello,

Thanks for both of these tips! I was close, but now it works with your info.
I figured it would take a couple of tables to resolve the issue.

Thanks Again,

Eholz1