I find out table services stores IT services configuration but want to know which table the actual IT services history data being stored? It looks like it doesn't store in table history or trends like normal item. How can I retrieve IT services data using SQL?
-
-
Hello!
History of state changes of IT Services is kept in service_alarms table. -
Thanks, unfortunately, I don't know how to calculate SLA base on service_alarm table.Comment
-
What are you trying to achieve?Comment
-
On my zabbix IT service front end, it shows for "This Month"
Service Status Problem Time SLA/Acceptable SLA
----------------------------------------------------------------------
System1 OK 0.0000 100.00/99.95
System2 OK 0.5270 99.9473/99.95
I want to know how I can use SQL command to query Zabbix database in order to get the SLA value 99.9473 of System2 for this month, or SLA value of System1 for last 7 days or 24 days ...
The query result will be dump to the file and email outComment
-
Yes, i guess it would be a bit hard to come up with SQL... How about API? It has the necessary method from what I can tell:
Comment
Comment