How can I query Ambari for historical error and maintenance information?

[#1]

Is there any built-in way to query Ambari for (a) when a service was last in maintenance mode, (b) the last error for a service plus why, etc. Accessing this information via the REST API would be ok if it is possible. Accessing it via Phoenix could also work, but is there a working example?

[#2]

Sounds like an enhancement jira

[#3]

@Peter Coates@Artem Ervits

Is your goal to query historical information for Ambari server that is not available from Ambari Rest API ? Look at Temporal metrics section

https://github.com/apache/ambari/blob/trunk/ambari-server/docs/api/v1/index.md#temporal-metrics

and you may be able to build your query using this info.

[#4]

@Shishir Saxena does Ambari maintain the dates and times of all maintenance modes?

[#5]

@Artem Ervits @Peter CoatesI looked at Ambari db tables and there is no table with a history of dates and times for maintenance modes but I could get indirectly this info from Alerts. As you suggested, it sounds like an enhancement jira.