Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Modifying BPAuditEvents Archiving Script

MaxMcConchie
Level 5

‎25-03-20 02:29 AM

​Hi,


I am trying to work out the best way to manage the BPAuditEvents table in Blue Prism. We currently have a policy to delete anything > 6 months old via the trim-process-history.sql query. The problem with this is that process/object versions are deleted.
What I want to do is to ensure there is at least 1 historical version of a process/object at all times as it's important for our release manager to be able to compare to a previous version when importing.

Has anyone been able to modify the script or has an alternative way to manage this?

Any assistance would be appreciated.

Thanks

------------------------------
Max McConchie
Automation Manager
Australian Government Department of Finance
------------------------------
0 Likes
1 REPLY 1

John__Carter
Staff
Staff

‎25-03-20 10:19 AM

Hi Max - please ask advice from our support team, but I guess it would be a case of adding a condition to exclude the 'user x modified process y' rows.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------
0 Likes