nevermind it worked.. for some reason just saving the vbs file in notepad and running it wasn't saving my changes.. or something. i closed it and ran it on my test server.. and it worked. i just tried it on my production server for hotmai.com that had one email in it.. and it cleared that right up.. so here i go on my 85,000 queue :)
-Ben On Thu, Jan 31, 2008 at 11:39 AM, Ben Nordlander <[EMAIL PROTECTED]> wrote: > i'm trying this out on my test server.. and it doesn't seem to work. i > sent an email to [EMAIL PROTECTED] which is now queued for retry on my test > exchange server. and i put in attbi.com in the script config part and run > cscript thatscript.vbs and it finishes with no error or output really > beyond the script host version. hmm.. do you think i'd need to put in the > entire name as it is displayed in ESM? > > -Ben > > On Thu, Jan 31, 2008 at 10:56 AM, Ben Nordlander <[EMAIL PROTECTED]> > wrote: > > > 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 ~