Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

May 2009 - Page 2 of 4 - Scripting Blog [archived]

Hey, Scripting Guy! Why Should I Use Windows PowerShell with SQL Server 2008?

May 26, 2009 May 26, 2009 05/26/09
ScriptingGuy1
(image) Hey, Scripting Guy! I recently saw that SQL Server 2008 has Windows PowerShell built into it. I looked at, but I am not really impressed. Why should I be interested in using Windows PowerShell with SQL Server 2008?- JJ (image) (image) Hi JJ, For some unknown reason, it has turned cool down here in Charlotte, North Carolina, in the ...

Hey, Scripting Guy! How Can I Perform More Than One Action with the Win32_Printer WMI Class?

May 21, 2009 May 21, 2009 05/21/09
ScriptingGuy1
(image) Hey, Scripting Guy! The Win32_Printer WMI class has several methods that are listed in it. But I am not sure how to best use these methods from inside a Windows PowerShell script. I do not want to create four different scripts to send a test page, clean out print jobs, and to cycle the print queue. Do you have an example of how I ...

Hey, Scripting Guy! How Can I Use Windows PowerShell to Remove Old Printer Connections, List Printers, and Set New Default Printers?

May 20, 2009 May 20, 2009 05/20/09
ScriptingGuy1
(image) Hey, Scripting Guy! Well it finally happened. Our budget request for new printers was approved. We have gotten them unboxed, distributed, and hooked up to the LAN. We have even downloaded the latest drivers from the Internet, and updated the firmware on several of the printers. The drivers are installed on the print servers, and the ...

Hey, Scripting Guy! How Can I Use WMI to Add a Printer Connection by Using Windows PowerShell?

May 19, 2009 May 19, 2009 05/19/09
ScriptingGuy1
(image) Hey, Scripting Guy! I am trying to determine how to use WMI to add a printer connection by using Windows PowerShell. I have found this script, but it uses VBScript and not WMI. This means that it is not very close at all, I am afraid. Do you have a WMI script I can use?- CM(image) (image) Hi CM,Ed looked around, but he did not find ...

Hey, Scripting Guy! How Can I Document Printer Usage on Client Workstations?

May 18, 2009 May 18, 2009 05/18/09
ScriptingGuy1
(image) Hey, Scripting Guy! I am tasked with the problem of documenting printer use on our client workstations. I must be able to determine whether someone prints directly to a printer, or if they are printing through our print servers. This is important because we have purchased a print monitoring software package that is used to back-charge...