topic RE: How to clear Audit Events/Audit Log data permanently from System tab? in Product Forum

How to clear Audit Events/Audit Log data permanently from System tab?

Tejaskumar_Darji — Tue, 14 Mar 2023 13:03:00 GMT

How to clear Audit Events/Audit Log data permanently from the System tab?

We have the auto archive set up but that only archives process logs and not audit logs

Please correct me if I'm wrong.

I know there are some cmd scripts that we can run but looking for an option in the System tab.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------

RE: How to clear Audit Events/Audit Log data permanently from System tab?

Mukeshh_k — Tue, 14 Mar 2023 13:48:00 GMT

Hi @Tejaskumar_Darji , I am afraid I could not find any such options to delete the audit logs from within the system tab and as you rightly mentioned the System Tab> System > Archiving only deletes the Process and Objects logs but not the Audit logs.

It seems we are left with one option only and that is to Delete the logs via SSMS BP Database with SQL Query as: DELETE FROM [dbo].[BPAAuditEvents] WHERE eventdatetime >= '2023-03-07' AND eventdatetime <= '2023-03-14'

------------------------------
Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

Regards,

Mukesh Kumar - Senior Automation Developer

NHS England, United Kingdom, GB
------------------------------

RE: How to clear Audit Events/Audit Log data permanently from System tab?

Tejaskumar_Darji — Wed, 15 Mar 2023 05:44:00 GMT

Thanks, @Mukesh Kumar for your prompt response.

Added to the Ideation portal - link to idea is here for an upvote.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------

RE: How to clear Audit Events/Audit Log data permanently from System tab?

Tejaskumar_Darji — Wed, 15 Mar 2023 05:54:00 GMT

I was able to clear the Audit table from DB using the query mentioned above by Mukesh.

A quick note if anyone performs this in the future. Ensure you take a backup of all your BP stuff before doing such direct DB actions. Thanks.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------

RE: How to clear Audit Events/Audit Log data permanently from System tab?

Mukeshh_k — Wed, 15 Mar 2023 08:34:00 GMT

Thanks Tejaskumar Darji : It would be great to see such options inside Blue Prism itself and we always have control on who to provide access with to such tabs via admins and etc - Sounds like an Idea, Upvoted.

RE: How to clear Audit Events/Audit Log data permanently from System tab?

Tejaskumar_Darji — Thu, 16 Mar 2023 08:57:00 GMT

One more update -

It cleaned up all edit history across all the processes and objects. Is this impact of clearing the Audit log DB table? Any idea about this scenario?

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------

RE: How to clear Audit Events/Audit Log data permanently from System tab?

Mukeshh_k — Thu, 16 Mar 2023 09:59:00 GMT

Hi Tejaskumar Darji - Yes Audit Logs itself means all the audit trails & logs related to any user or system doing any changes or edits. The recommended protocol is never to delete the Auditlogs, but as your query stated it wanted to get rid of all the audit logs permanently.

RE: How to clear Audit Events/Audit Log data permanently from System tab?

Tejaskumar_Darji — Thu, 16 Mar 2023 10:20:00 GMT

Got it, thanks for the details.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------