w00t thanks Michael. i will give that a try! thanks a ton, and i'll be back with results.
-Ben On Thu, Jan 31, 2008 at 10:43 AM, Michael B. Smith < [EMAIL PROTECTED]> wrote: > > > 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 <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 (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 ~