Query database directly?

[dminstrel]

Hi,

at my company, we're using a data warehouse to collect different trends and performance indicators (mostly from our ERP system). I'd like to be able to query the ZABBIX database to obtain the IT services SLA. However, this seems to be a calculated value and my programmer seems stumped. Has anyone tried to extract this kind of data? I've whipped up an unstable and ugly shell script that parses the PHP but I'd rather go the database route.

Any SQL donations will be much appreciated :o.

Cheers,

Jonathan

[James Wells]

Greetings,

Started looking at this last night, after reading your email. So far, I have not made much headway against this, though from what I can tell, it is indeed calculated, but it is calculated based on the trigger being TRUE / FALSE, which means you should be able to do a simple SQL query to get the count of TRUE and another for the count of FALSE. Then you can use this information to generate your own statistics.

Also, from what I saw last night, it looks like you can use a similar SQL statement to perform various trending analysis checks.

You might also want to look at the code that Stankju used to create his PDF Monitoring Reports (http://www.zabbix.com/forum/showthread.php?t=1049) as they appear to do some of what you are trying to do.