Influxdb get historical alerts

Hello all,

I have some alerts configured and the output to InfluxDBout. Then I have first point when the the alert is active, and other point if the alert is inactive. Thus I have 2 points with the alert is inactive and 1 point if is active.
But I can't find a query to get all the alerts for historian purposes with the last status with it's time.

Thank you

Review how Kapacitor writes alert state points to InfluxDB and how historical alert data is expected to be queried; the issue names no files, tests, or entry points. The work is complete when a documented or implemented way exists to retrieve each alert's latest status together with its timestamp.

Written by the indexing model from the issue text.