locked
Bulk delete mail in CRM queue permanently RRS feed

  • Question

  • Over the Christmas break, one of my clients put an auto reply message on one of their mailboxes. Unfortunatley, this caused a major issue where all incoming spam was being replied to with the Out Of Office message, which in turn caused further bounce backs. The problem is that they now have over 300,000 additional messages in the CRM 3.0 queue. Is there a way that you can permanently delete the majority of messages in bulk, as 99% of them all have the same subject heading - Mail Delivery Failed? Can this be done with an SQL script perhaps?

    They had started deleting them manually (250 at a time) until I pointed out to them that this does not actually remove them from the CRM system.

    Any help is greatly appreciated.

    Thanks


    Friday, January 9, 2009 3:17 AM

Answers

  • If you are going to delete records from the database and you are not a developer, I would probably look to a CRM specialist that has done this type of work in the past.  It will probably be money well spent.  There are many highly competent people in the forums that can most likely help.  The MVP's are a good resource and I would trust their judgement.  Of course, backup the database before the code is run but I am sure the consultant will also tell you that.

     

    Have a good day.

     

    Monday, January 12, 2009 1:55 PM

All replies

  • Here is a link to the CRM 3.0 sdk that shows some sample code for generating a bulk delete request. 

     

    http://msdn.microsoft.com/en-us/library/bb407663.aspx

     

    Friday, January 9, 2009 4:58 PM
  • Thanks for your response Donna.

    I had come across this sdk last week when doing my research. Unfortunately I am a consultant and not a programmer. I know nothing about C# or Visual Basic .Net, so would not be able to tailor the code for my clients needs.

    Do you therefore think I am better off calling in a CRM specialist, or is there another way I can find out how to use the code (eg. whitepaper)?

    Brenton
    Monday, January 12, 2009 5:26 AM
  • If you are going to delete records from the database and you are not a developer, I would probably look to a CRM specialist that has done this type of work in the past.  It will probably be money well spent.  There are many highly competent people in the forums that can most likely help.  The MVP's are a good resource and I would trust their judgement.  Of course, backup the database before the code is run but I am sure the consultant will also tell you that.

     

    Have a good day.

     

    Monday, January 12, 2009 1:55 PM