[SOLVED]Easy way to to access THOLD graph data?

[eholz1]

Hello Members,
Thank you for Cacti. I am using cacti-1.2.24.
I would like to know if there is an way to access data in the plugin_thold_host_failed table.
This table contains the data for the for the "Device Status" tab contained in the "Thold" tab in cacti interface.
Also, what is the criteria for a device to be placed in that table? I know that if a device goes down for
3 minutes, and comes backup, it will not be in that table. And if a device is down for a long time, it is in the
table.

I can access the data in the plugin_thold_host_failed table by running a query on the cacti database.
But I would like to automate this process. i.e: run script everyday, check table, if more than 0 devices in
table/graph - send email. etc.

OR - would this information be contained in an environment variable, OR is there a script already part of the
Cacti application that I have not yet found?

I am open to suggestions!
eholz1

[bmfmancini]

The best way is to write a script to query that table
that table is populated when a device is set to down and is flushed when its restored

However if your looking to get an email if a device has been down for like a Day you can do that
in the Alerting/Threshold tab set the re-alerting config there

[eholz1]

Hello and Thanks,

Yes, that is what I ended up doing. Thanks for the reply.
I created a php file that access the thold table that holds a "down" device, creates an
html file, and emails the information.

Thanks for the reply,

eholz1