We are running Blue Prism 6.2 in a production environment. It has been in use for over 2 years. Our DBA informed me some of the audit tables are taking about 11 megabytes per row! He asked if there is a way we can purge the audit logs.
I looked at Blue Prism's tools and can see the Audit logs, but it doesn't appear you can erase these using Blue Prism's interface. I guess we'd need to use a tool like SQL Server Express to handle the delete?
How safe is it to have our DBA purge the tables? We would probably only need to retain the last 30 days or so. I don't want to purge records and find out we have wrecked some of our scheduled jobs.
I did not see a lot of options within Blue Prism to control the audit tables. It'd be nice to have a setting where it can clean up after a specified amount of time or allow the admin to specify what is saved in the audit tables.
Please share your thoughts on how your organization is handling the audit tables. Thanks!
I looked at Blue Prism's tools and can see the Audit logs, but it doesn't appear you can erase these using Blue Prism's interface. I guess we'd need to use a tool like SQL Server Express to handle the delete?
How safe is it to have our DBA purge the tables? We would probably only need to retain the last 30 days or so. I don't want to purge records and find out we have wrecked some of our scheduled jobs.
I did not see a lot of options within Blue Prism to control the audit tables. It'd be nice to have a setting where it can clean up after a specified amount of time or allow the admin to specify what is saved in the audit tables.
Please share your thoughts on how your organization is handling the audit tables. Thanks!