Locating the Instance History Information in the Database

Hello everyone,

I’m currently trying to access the history of an instance directly from the database but am unsure which table contains this information. Could someone please advise which table stores the instance history?

Thank you in advance for your assistance!

Best regards,
Marvin Lorenz

Would this API endpoint fit your needs?

Is there a specific reason you need to get it from the DB? I would try to stick with the API whenever possible.

Hey,
I’m in the process of creating a dashboard in Grafana based on the DB Connection. An overview generates a list of all faulty instances with tenant name and creator. I would like to add the error message from the history there.
The API must effectively pull this information from the database somewhere.

I think you’d need to pull this from the process table, possibly process_event. The process_type table shows the processes that are tracked, which include instance lifecycle type stuff.

It would be easier over the API endpoint Tyler mentioned.

It looks like you would want to look at the process table. You can look at the instance_id column to see what it was run against and the status column to see if it completed or failed. Other info in the table might be good to display in your dashboard as well.