|
|
| 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 |
Hello,
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.
Thanks,
| 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 - http://wiki.zenoss.org/Working_with_the_JSON_API
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.
Thanks,
| 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.
http://wiki.zenoss.org/Working_with_the_JSON_API
| < |
Previous Windows Event Filter Problem / Error |
Next Reportmail unable to load the address |
> |