SQL query to delete old logs

JulenBaron — Fri, 01 Jul 2022 04:39:19 GMT

Hello,

From some odd reason, old logs in BPASessionLog_NonUnicode from past years are not appearing in blue prism. Right now we can get rid of them, but I wanted to know if I launch the following query, may I have any Issues? I guess not, but just wanna double check. Thank you

DELETE FROM [dbo].[BPASessionLog_NonUnicode]
WHERE startdatetime > CAST('2020-01-01 01:00:00.00' AS DATETIME) AND startdatetime < CAST('2020-12-31 23:59:00.00' AS DATETIME)

Re: SQL query to delete old logs

expertcr — Fri, 01 Jul 2022 15:56:33 GMT

We recommend you use our official scripts for this task.
Please contact our support department and request the maintenance script to help you with that.

topic Re: SQL query to delete old logs in Product Forum

SQL query to delete old logs

Re: SQL query to delete old logs