# Remove private messages for archive users

**URL:** <https://www.finalbuilder.com/forums/t/remove-private-messages-for-archive-users/5572>\
**Category:** Discussion\
**Created:** [June 27, 2017, 2:10am UTC](https://www.finalbuilder.com/forums/t/remove-private-messages-for-archive-users/5572 "2017-06-27T02:10:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kay.zumbusch](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/k/cc9497/32.png) [@kay.zumbusch](https://www.finalbuilder.com/forums/u/kay.zumbusch)\
**Post date:** [June 27, 2017, 2:10am UTC](https://www.finalbuilder.com/forums/t/remove-private-messages-for-archive-users/5572/1 "2017-06-27T02:10:33Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Vincent](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/vincent/32/938_2.png) [@Vincent](https://www.finalbuilder.com/forums/u/Vincent)\
**Post date:** [June 28, 2017, 1:27am UTC](https://www.finalbuilder.com/forums/t/remove-private-messages-for-archive-users/5572/2 "2017-06-28T01:27:45Z")

</div>

Hi Kay  
  
Yes, this is safe to do :&nbsp;

`DELETE` `FROM` `[dbo].[core_privatemessage]`

`      ``WHERE`&nbsp; `recipientid ``in` `(``select` `id ``from` `[dbo].[core_user] ``where` `archived = 1)`

---

<div class="post-metadata">

**Author:** ![kay.zumbusch](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/k/cc9497/32.png) [@kay.zumbusch](https://www.finalbuilder.com/forums/u/kay.zumbusch)\
**Post date:** [June 28, 2017, 12:08pm UTC](https://www.finalbuilder.com/forums/t/remove-private-messages-for-archive-users/5572/3 "2017-06-28T12:08:44Z")

</div>

Hi Vincent,   
  
 thanks a lot.   
  
 Kind regards   
  
 Kay Zumbusch
