A place to learn about PowerShell and share stories of automation
June 30, 2007Jun 30, 200706/30/07Hey, Scripting Guy! We have a lot of users who let unread email messages pile up in their Outlook Inboxes; after awhile, that causes their Inboxes to fill up. How can I write a script users could run that would delete any unread messages that are more than 6 months old?—
June 29, 2007Jun 29, 200706/29/07Hey, Scripting Guy! How can I write a script that prompts the user for a computer name, then goes out and deletes that computer account from Active Directory?— PH
Hey, PH. As a general rule, technical writers never experience writer’s block.
June 28, 2007Jun 28, 200706/28/07Hey, Scripting Guy! How can I remap network drives so they point to the IP address of the remote computer rather than the computer name?— YM
Hey, YM. You know, yesterday we started off this column by saying, “Never mind,” referring to the fact that,
June 27, 2007Jun 27, 200706/27/07Hey, Scripting Guy! I have a huge document that features occasional lines printed in red. How can I extract just the lines that are printed in red?— GH
Hey, GH. To begin with, the Scripting Guy who writes this column would like to say just one thing: never mind.
June 26, 2007Jun 26, 200706/26/07Hey, Scripting Guy! How can I create a folder for each user in my domain? I’d like the folder name to consist of the user’s first initial and their last name (for example, KMyer).— GN
Hey, GN. You know, this has been an interesting week for the Scripting Guys.
June 23, 2007Jun 23, 200706/23/07Hey, Scripting Guy! How can I delete a row in an Excel spreadsheet if there is a specific value in column A of that row?— OI
Hey, OI. Before we get rolling on today’s column, have we mentioned that time is beginning to run out on the Scripting Guys TechEd Challenge?
June 22, 2007Jun 22, 200706/22/07Hey, Scripting Guy! How can I open a window to a UNC location? You’ve given many examples that involve opening a web page. I have been unable to get a similar result trying to get a script to open \\server\share.— CY
Hey,
June 21, 2007Jun 21, 200706/21/07Hey, Scripting Guy! When I create a new Excel spreadsheet, I’d like to color every other row in that spreadsheet. How can I do that?— TM
Hey, TM. We know a lot of you have been wondering, “Gee, what’s the matter with the Scripting Guy who writes that column?
June 20, 2007Jun 20, 200706/20/07Hey, Scripting Guy! How can I insert commas at specified locations in each line in a text file?— MM
Hey, MM. Seeing as how Father’s Day has just come and gone we couldn’t talk about inserting commas into text files without first relating a heartwarming Father’s Day tale of our own.
June 19, 2007Jun 19, 200706/19/07Hey, Scripting Guy! How can I delete all the users whose name starts with GER/ad_ from the local Administrators group on a computer?— ID
Hey, ID. It’s a Friday as the Scripting Guy who writes this column writes this column. Usually Fridays are a very sad day for this Scripting Guy: after all,
