I had a task with a company some weeks back where I needed design, a new printning solution. The task was to create a print server and to install 150 printers on the server. The users should be able to find the printers through Actice Directory Search.

I ended up adding all the printers by using a Excel sheet with all the printer information and used that to create the powershell commandline to install all the printers at once.


– Before using the excel sheet commands you need to have a running server 2012 or 2012R2 where you have installed the printer driver for your printers.

– Create a reference printer named _Printer_Reference that will be used copy settings from to new printers being added. Set the settings that needs to be the same on all printers.

– The Excel sheet which can be downloaded here -> Printer Queues and Ports

Using the Excel

You have to sheets:

One called Print Ports which is used to add printer ports. Another called Print Queue to add printer queues.

Print Ports sheet In the Print Port sheet add the IP address of the printer in column B. And copy the entire command from column F. This will create the printer port for the printer. If more printers is being added you can copy row 3 multiple time and just change the IP address in column B.

Print Queue sheet In the Printer Queue sheet change the values in the bold columns.

The Printer Location Column needs to match a site in Active Directory Sites and Services. It’s used so that it’s easier for the users to find the printers when adding the printer and searching through Active Directory.  When finished adding the information in bold. You can copy the entire command from column F. Again as in Print Port sheet, you can copy the line multiple times when adding multiple printers.


Hans Christian Andersen Twitter: @dk_hcandersen LinkedIn: http://dk.linkedin.com/pub/hans-chr-andersen/5/1a5/a30/