I am looking for a tool or guidence on writing either an API tool or SQL proceedure to extract the default data object attributte values from completed process instances.
The PS database volume has grown very large as there has not been any maintenance on finished processes as these were being kept to allow TCP reports to run on them. It has now become too large a system to report back in time and I would like to extract the data and store in a flat table structure in separate database for archive reports through SQL. This will allow us to remove finished processes from the PS database using the maintenance job.
We can then look at implementing the process history agent to document the processes to HTML documents or put in direct data archiving into the processes going forward but need to get the old large volume of data history out first. I only need the default data object as at the end step and something similar to the history agent xml would work.
Anyone with similar data extraction comments welcome.