TECHZEN Zenoss User Community ARCHIVE  

sql query to fetch the event archive between two time intervals in zenoss 4.2.5

Subject: sql query to fetch the event archive between two time intervals in zenoss 4.2.5
Author: [Not Specified]
Posted: 2016-08-12 04:08


We am currently using zenoss 4.2.5, We use event archive feature to get the list of open/acked/closed events for past 1 week from zenoss and rearrange the columns to send report. We are trying to automate through bash script by fetchign data from mysql. Can we get the mysql query which will be used when event archive is used from webportal. Thanks in advance.


Subject: SELECT * FROM event_archive
Author: Jan Garaj
Posted: 2016-08-12 07:06

SELECT * FROM event_archive

and add time condition, for example:

WHERE first_seen<=

I don't recommend direct SQL queries. JSON API is better option -

Devops Monitoring Expert advice: Dockerize/automate/monitor all the things.

DevOps stack: Docker / Kubernetes / Mesos / Zabbix / Zenoss / Grafana / Puppet / Ansible / Vagrant / Terraform / Elasticsearch

Subject: query based on timeestamp
Author: [Not Specified]
Posted: 2016-08-16 07:34

Hi Jan.garaj,

Thanks for taking a look into this issue, I would like to know how can we query all the events from eventarchive api between 1 week timestamp Can you through somemore light here on how to do that through jsonapi.


Subject: Hi Sriman,
Author: Jay Stanley
Posted: 2016-09-01 09:04

Hi Sriman,

Using the link Jan provided will point you to the documentation, which shows you how to use the API.

< Previous
Windows Event Filter Problem / Error
Reportmail unable to load the address