Create a PowerShell Scheduled Job

Summary: Learn how to create a Windows PowerShell scheduled job. Microsoft Scripting Guy, Ed Wilson, is here. Well, the Scripting Wife and I are about to straighten up the scripting house after the Windows PowerShell Saturday luau we had on Friday and the scripting slumber party we had over the weekend. Frankly, it is an…


Remoting the Implicit Way

Summary: Guest blogger, June Blender, talks about how to use Windows PowerShell implicit remoting. Today we welcome June Blender, senior programming writer for Windows Azure Active Directory. Take it away, June… Just about everyone knows how to run Windows PowerShell commands on a remote computer. You can use WMI or Windows PowerShell remoting, and the…


PowerTip: Customize How PowerShell Displays a Date

Summary: Easily customize the way Windows PowerShell displays a date.  How can I use Windows PowerShell to easily display the date as day-dash-month-dash-four-digit year?  Use the Get-Date cmdlet,specify a custom format by using the Format parameter, and use dd for the date, M for the month and yyyy for a four-digit year (this is case sensitive): Get-Date -Format “dd-M-yyyy”


How Can I Password-Protect an Excel Spreadsheet?

Hey, Scripting Guy! In a previous column, you told us a couple different ways to save Excel spreadsheets. In that column, you said that one of the things you could do with the SaveAs method was password-protect a spreadsheet. However, you didn’t show us an example of this. How can I use a script to…

8

Keep Your PowerShell Versions Straight and Avoid Errors

Summary: Learn how to keep your Windows PowerShell versions straight, and avoid errors while using a one-line command to add computers to domain. Microsoft Scripting Guy, Ed Wilson, is here. Earlier this week I wrote Use PowerShell to Replace netdom Commands to Join the Domain. It turned out to be a very popular post. To…


Use a PowerShell Hash Table to Simplify File Backups

Summary: Learn how to use a Windows PowerShell hash table to simplify backing up unique files.   Hey, Scripting Guy! Your series on hash tables has been pretty interesting. I am wondering if you have some practical uses for hash tables. Can you provide a few examples of how using a hash table would be…


PowerTip: Quickly Find System Updates via PowerShell

Summary: Use Windows PowerShell to identify updates applied to a computer system.  How can I find which updates are applied to my computer?   Use the Get-Hotfix cmdlet. To find updates, use the Description parameter and specify Update: Get-HotFix -Description Update To find a specific hotfix by ID number, use the Id parameter: Get-HotFix -id kb2741530 


PowerShell Workflow for Mere Mortals: Part 5

Summary: Microsoft Scripting Guy, Ed Wilson, concludes his five-part series about Windows PowerShell Workflow.    Hey, Scripting Guy! I have a number of commands that I want to run against several remote servers. The commands include stuff that must happen prior to something else happening. But then, there are also some things that I would…


PowerTip: Use PowerShell to Wait for a Key Press

Summary: Learn about the Windows PowerShell version of “Pause.”  How can I use Windows PowerShell to wait for a key in scripts like I used to use “Pause” in the command console?  Use the $Host variable in the console: $HOST.UI.RawUI.ReadKey(“NoEcho,IncludeKeyDown”) | OUT-NULL$HOST.UI.RawUI.Flushinputbuffer()


How Can I Insert a Symbol into a Word Document?

Hey, Scripting Guy! How can I insert a Wingding symbol into a Word document?– RC Hey, RC. In case you’re wondering, there were two reasons why we decided to answer your question. First, we just liked the phrase insert a Wingding symbol. (No, we don’t know why we liked it, we just did.) Second -…

8