Scripting Blog

A place to learn about PowerShell and share stories of automation

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (9/11/09)

Share this post: Hey Scripting Guy! I stumbled across the TechNet Script Center recently while trying to solve a problem I had at work. I had heard about scripting, of course, but had never taken the time to learn about it. I was able to find a script that resolved my issue at work, but now I am thinking I would like to learn...

Hey, Scripting Guy! Can I Sort a Tab-Separated Value File with Windows PowerShell 2.0?

  Hey Scripting Guy! I have a bunch of data in a tab-separated value (TSV) file that I need to sort based upon one of the columns. If you could help me it would be great. We are using Windows PowerShell 2.0 if that is of any importance to your solution. -- MLHello ML, Microsoft Scripting Guy Ed Wilson here. When your friends and family...

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (05/08/09)

How Can I List All Servers in a Domain That Have DHCP Installed?  Hey, Scripting Guy! How can I quickly produce a list of all servers in the domain that have the DHCP Service installed?- SC Hi SC,On Windows Server 2008 and ater, use the WIN32_ServerFeature WMI class. The GetDHCPServer.vbs script shows this process:GetDHCPServer.vbs ...

Hey, Scripting Guy! How Can I Import Data into Office Access from Office Excel?

Hey, Scripting Guy! I need to do hardware inventory on all our workstations and on all our servers. I know System Center Configuration Manager can do this and a whole lot more. We actually have it budgeted for deployment next year. However, that does not help me now. We had a summer intern that went around and typed a lot of information such...

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (01/23/09)

How Can I Return File Names of Files Created in Less Than an Hour from the Current Time?   Hey, Scripting Guy! I am attempting to write a script that looks at the creation dates of all files in a certain directory. If the files were created less than an hour from the current time, the script will return those file names. The script will ...