04-15-2013 11:49 AM - edited 03-14-2019 11:33 AM
I have a customer with several email queues but on of these queues had an auto reply loop and the went into the Exchange mailbox to manually delete the emails. Now in CSD if you open the email queue and click on "Queued" these emails are still listed. The "Total emails in queue" shows the corect nubmer of emails actually in the exchange folder.
My question is how do we get these phantom emails out of the CSD dispaly?
They are on UCCX 9.0.2-10000-17.
05-28-2015 11:26 AM
Hello Martin,
Finally you solve this.. i have the same issue..
Thanks.
05-28-2015 11:40 AM
We ended up removing the distribution list so the emails would stop bouncing around then put it back.
05-28-2015 04:32 PM
Martin, it is great that you were able to do this after removing the distribution list altogether. There is also an easy way to do this from UCCX CLI:
utils uccx eemtables cleanup normal 3 02/11/2014 queued
You can also use the above command to remove ghost e-mails from the Assigned and Resolved folder too. Just replace the queued with assigned or resolved.
Note : 3 is the CSQid in this case and date is what you will need to choose based on which you need to delete e-mails from the Queued Folder. In order to get the CSQid, just login to UCCX Administration page and hover the mouse on CSQ name and you will be able to see the CSqid in bottom. Below is the screenshot as well for your reference
Regards
Deepak
05-28-2015 07:36 PM
Hello Deepak,
For me your method works great.. thanks for this..
A final question. Can i delete a unique email ex: 02/11/2014 03:00:00
Thanks,
05-28-2015 08:02 PM
Hi Christian,
Glad that works for you.No you cannot remove the e-mail for a specific time using the command I mentioned earlier. The way to do this is to find the uid for a particular e-mail based on the time like below:
run uccx sql db_cra select emailUIDOnMailServer from eemactiveemail where queueddatetime='2014-11-10 08:00:00'
Once you have the uid, then run the below command to remove the e-mail
utils uccx eemtables cleanup uid <uid you got from above mentioned command>
In case, if the uid is negative then you will not able to delete it because of the below defect and the only option then left will be to go for deleting it using the csqid and cutoff date :
https://tools.cisco.com/bugsearch/bug/CSCuh23009/?reffering_site=dumpcr
Regards
Deepak
05-31-2015 05:49 PM
Hello Deepak,
Thanks for this... finally your suggestion solve my issue.
All procedures works fine with my ccx version 10.5 :)
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide