Hello,
We are planning to initiate the Database Maintenance Activities using the doc below.
Automation Suite - Cleaning up the Orchestrator database
We are a bit lost on one point. If we have an Insights Dashboard which fetches data from Orchestrator (such as Queue items, Jobs etc.), will deleting older Queue items or Jobs using the Database maintenance scripts impact the dashboard values or will the changes be added to insights on incremental basis?
Yes it will impact the Insights dashboard. As insights pulls everything from database, any changes made to the database will impact the stats in insights as well.
However, if you want, before making any changes to the database, you can store versions of insights dashboard that reflect the current data. So if anything changes later on, you would still have the values from past dashboards.
Deleting old orchestrator queue items or jobs using maintenance scripts does not change existing Insights dashboards, because Insights stores its own historical dataset.only new data added after cleanup is ingested, so dashboards remain intact.
Happy Automation