Solved

VBScript - check if printer exists; delete old queue; install new queue

Posted on 2011-02-18
8
4,617 Views
Last Modified: 2012-05-11
I will be migrating print queues to a new Windows 2003 Server next week and need a script that will:
Check the network printers currently installed on a PC (enumPrinterConnections)
against a list of print queues that will be moved to the new server
If the PC has a queue that will be moved, delete the current queue and install the new queue
If the PC does not have the queue that will be moved, do nothing and continue to check the next printer (without invoking an error message.) There are 9 queues that will be moved but not all PCs have every queue installed. There is a logon script which is a .bat file but I think a .vbs script can be called from it.

Adding and removing is simple enough:
'Remove a specific printer
WSHNetwork.RemovePrinterConnection PrinterPathDel
'Install A Printer
WSHNetwork.AddWindowsPrinterConnection PrinterPathAdd

but looping through both lists (currently installed and new queues to add)
is a little beyond me. I not sure how to use IF statements in this situation either.
0
Comment
Question by:bstillion
  • 5
  • 2
8 Comments
 
LVL 65

Accepted Solution

by:
RobSampson earned 500 total points
ID: 34935528
Hi, I have used the script shown here:
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_22955704.html

to remap printers from one server to another.  The arrPrinterShares array is where you place your oldprintername and your newprintername, and it should map those, and log the results.

Regards,

Rob.
0
 
LVL 1

Expert Comment

by:MarkThomasLee
ID: 34935949
I've had pretty good luck using snip its of the code from the following site:
Connecting Drive Letters:
http://computerperformance.co.uk/Logon/Logon_HomeDirAdv.htm

Connecting, setting defaults and removing printers
http://computerperformance.co.uk/Logon/LogonScript_Printer.htm

Good luck!
m
0
 

Author Comment

by:bstillion
ID: 34944836
I adapting your suggestion Rob. I'll know by the end of the day and will respond back.

Brad
0
 

Author Comment

by:bstillion
ID: 34945090
Thanks Rob!
As always, your script is exactly what I needed.

I used the 2nd version without IP Filtering. The log it creates is great for monitoring
what happens and when.
During testing I discovered 7 queues that were duplicated on another server so it
also helped me clean up the newly acquired organization that has not had dedicated
IT support for too long.

Thanks again for your excellent (and fast!) solution!

Brad
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Author Closing Comment

by:bstillion
ID: 34945097
Your VBScripts are great and get me motivated to learn more.
Thanks!

Brad
0
 

Author Comment

by:bstillion
ID: 34945303
Note:
In the array with old and new printer queues, I had to identify the
printers by display name rather than share name.
Took me some time to discover that so I wanted to save future users of this script some time.

Brad
0
 
LVL 65

Expert Comment

by:RobSampson
ID: 34946600
Hi, thanks for that, I'm glad it helped.  Yeah, I think I noticed that it was display name after someone else tried it out.  The reason I didn't pick up on it was because we always have the display and share name identical.

Regards,

Rob.
0
 

Author Comment

by:bstillion
ID: 34953794
...It maintains the default printer too!

Brad
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

The question has been asked on multiple occasions as to how best to do printing in a remote desktop or terminal services environment.   It seems that this particular question has plagued several people and most especially as Terminal Services, as…
I hope you'll find this tutorial useful and interesting. So let's try to extend Tcl with a new package.  For anyone more deeply interested please check out the book "Practical Programming in Tcl and Tk". It's really one of the best written books abo…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now