How to find which graphs are using CDEF?

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
User avatar
Jeeves
Cacti User
Posts: 91
Joined: Wed Jun 12, 2013 6:25 pm

How to find which graphs are using CDEF?

Post by Jeeves »

Dumb problem, but still a problem. I changed the wrong CDEF. The one I modified is attached to 18 graphs and 4 templates.
But how do I tell which?

Unlike other portions of cacti, the numbers in use are not links and I do not see a simple way other than db digging or clicking into each template (far fewer of those than individual graphs).

Thanks!
User avatar
macan
Cacti Guru User
Posts: 1137
Joined: Tue Mar 18, 2008 2:30 am
Location: Czech

Re: How to find which graphs are using CDEF?

Post by macan »

xxx = your cdef id (presets->cdefs-> choose any, ID will be in URL (.../cdef.php?action=edit&id=xxx)
select distinctrow cdef_id, local_graph_id, graph_template_id FROM graph_templates_item where cdef_id=xxx;


Template = local_graph_id = 0
Let the Cacti grow!
User avatar
Jeeves
Cacti User
Posts: 91
Joined: Wed Jun 12, 2013 6:25 pm

Re: How to find which graphs are using CDEF?

Post by Jeeves »

macan wrote: Wed Sep 20, 2023 2:10 am xxx = your cdef id (presets->cdefs-> choose any, ID will be in URL (.../cdef.php?action=edit&id=xxx)
select distinctrow cdef_id, local_graph_id, graph_template_id FROM graph_templates_item where cdef_id=xxx;


Template = local_graph_id = 0
Good tip, though it'd be nice if they just incorporate that into the UI!
Thanks!
User avatar
macan
Cacti Guru User
Posts: 1137
Joined: Tue Mar 18, 2008 2:30 am
Location: Czech

Re: How to find which graphs are using CDEF?

Post by macan »

Yes, I'm thinking about it
Let the Cacti grow!
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: How to find which graphs are using CDEF?

Post by TheWitness »

Log a feature request on GitHub.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
User avatar
Jeeves
Cacti User
Posts: 91
Joined: Wed Jun 12, 2013 6:25 pm

Re: How to find which graphs are using CDEF?

Post by Jeeves »

TheWitness wrote: Fri Sep 22, 2023 11:38 am Log a feature request on GitHub.
Aye Aye Cap'n!
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: How to find which graphs are using CDEF?

Post by TheWitness »

Yea, took some time off. I lost a switch in the home lab, and just did not have the will-power to turn it back on again once the new switch arrived ;)
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
User avatar
Jeeves
Cacti User
Posts: 91
Joined: Wed Jun 12, 2013 6:25 pm

Re: How to find which graphs are using CDEF?

Post by Jeeves »

TheWitness wrote: Fri Sep 22, 2023 11:43 am Yea, took some time off.
HOW DARE YOU!
/s
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests