cancel
Showing results for 
Search instead for 
Did you mean: 

SQL query to delete old logs

JulenBaron
Level 2
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)
1 REPLY 1

expertcr
Staff
Staff
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.