Selecting historical data from zabbix 1.8 database

[waardd]

I'm trying to select data from de zabbix database to export to a file for using in fr instance excel.
But i get no historical data.
I use Workbench to select data like so:

select * from zabbix.hosts where host like 'lsrv1790%';

This results in 10184
...

[kultys]

I try create select in DB and have problem.
I need show only noode so have problems for now.

Query must show me all noodes so have problem (resolved and unresolved).
I need show only unresolved. You now whith table have this data ?

Thanks for help.

[polivox]

Opa Galera,

O meu chefe está pedindo um relatorio pra extrair direto do banco e jogar em outra aplicação porem eu nao sei como conseguir... ou como calcular...

Já fiz essa consulta... porem a unica coisa q falta... é definir o tempo de duração de cada evento......