Remove private messages for archive users

Continua CI Discussion
1

Hi guys,

In order to cleanup our Continua CI database I’d like to get rid of private messages that are linked to users that are no longer available in Continua CI. According to the database the user records are available but the username include an archive date. Is there a way to remove them from the database? I could just execute the appropiate SQL command on the database but I’d to get you approval that this is the way to go.

Kind regards

Kay Zumbusch

2

Hi Kay

Yes, this is safe to do : 

DELETE FROM [dbo].[core_privatemessage]
      WHERE  recipientid in (select id from [dbo].[core_user] where archived = 1)

3

Hi Vincent,

thanks a lot.

Kind regards

Kay Zumbusch