Take this statement:
Set objMsgsList = objWMIExch.ExecQuery ("Select * From " &_
"Exchange_QueuedSMTPMessage Where ProtocolName='SMTP' And LinkId='"
&_
objQueueInst.LinkID & "' And LinkName='" &_
objQueueInst.LinkName & "' And QueueId='" &_
objQueueInst.QueueID & "' And QueueName='" &_
objQueueInst.QueueName &"' And VirtualMachine='" &_
objQueueInst.VirtualMachine & "' And VirtualServerName='" &_
objQueueInst.VirtualServerName & "' And MessageID ='" &_
strMessageID & "'")
And turn it into this:
Set objMsgsList = objWMIExch.ExecQuery ("Select * From " &_
"Exchange_QueuedSMTPMessage Where ProtocolName='SMTP' And LinkId='"
&_
objQueueInst.LinkID & "' And LinkName='" &_
objQueueInst.LinkName & "' And QueueId='" &_
objQueueInst.QueueID & "' And QueueName='" &_
objQueueInst.QueueName &"' And VirtualMachine='" &_
objQueueInst.VirtualMachine & "' And VirtualServerName='" &_
objQueueInst.VirtualServerName & "'")
Note the two line change that removes the MessageID from the SELECT
statement.
Regards,
Michael B. Smith
MCSE/Exchange MVP
http://TheEssentialExchange.com
From: Ben Nordlander [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 31, 2008 1:37 PM
To: MS-Exchange Admin Issues
Subject: Re: fast way to delete an Exchange Queue
yes, i found this too.. but it isnt' sticking out to me how best to edit
this..
-Ben
On Thu, Jan 31, 2008 at 10:28 AM, Michael B. Smith
<[EMAIL PROTECTED]> wrote:
http://www.exchangecookbook.com/files/07-14-delete-message-from-queue.txt
You'll have to remove the "specific message selection" logic, but this shows
you the path to follow.
Regards,
Michael B. Smith
MCSE/Exchange MVP
http://TheEssentialExchange.com <http://theessentialexchange.com/>
From: Ben Nordlander [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 31, 2008 1:17 PM
To: MS-Exchange Admin Issues
Subject: fast way to delete an Exchange Queue
I have a bunch of emails backed up due to a failed archive/journeling
system. at this point i just want to delete everything that it was trying to
deliver to my email archive system.
In my exchange 2003 server the queue name is "SMTP -
mailarchive.mydomain.net <http://mailarchive.mydomain.net/> (SMTP
Connector)".
any of you have a script that could clear this queue up? I already deleted
the SMTP Connector in 'Routing Groups --> Connectors"
any help, i'd be happy!
-Ben
~ Ninja Email Security with Cloudmark Spam Engine Gets Image Spam ~
~ http://www.sunbeltsoftware.com/Ninja ~
