This site uses cookies for analytics, personalized content. By continuing to browse this site, you agree to this use. Learn More
A place to learn about PowerShell and share stories of automation
May 30, 2010May 30, 201005/30/10
Microsoft Scripting Guy Ed Wilson here. One of the cool things about using Windows PowerShell is the different objects with which you can interact. Windows Search is an example of this. By using ADO, you can query the Windows Search index and retrieve information about files.
August 13, 2009Aug 13, 200908/13/09
Hey Scripting Guy! I have a Microsoft Access database that I need to query from a Windows PowerShell script. I have seen a number of VBScript examples, but I cannot find any Windows PowerShell samples. Can you point me in the right direction?
April 4, 2009Apr 4, 200904/4/09Troubleshooting the Application of Two WMI Classes
Hey, Scripting Guy! The examples produced from the “Scriptomatic Version 2.0 by The Microsoft Scripting Guys” for the entries Win32_ServiceSpecification and Win32_ServiceControl both return error 0x80041002 under Windows Server 2003. I can’t find another WMI class that exposes the recovery options for services,
September 16, 2008Sep 16, 200809/16/08Hey, Scripting Guy! I need to be able to write information to an Excel file. I do not want to install Microsoft Office Excel on my server, but the spreadsheet format is a nice way to store information. I can then give it to my pointy-headed boss,
September 12, 2008Sep 12, 200809/12/08Hey, Scripting Guy! I have an Microsoft Office Excel spreadsheet with server names in it, and I would like to be able to use this in a Windows PowerShell script. The thing is, I do not have Microsoft Office or Excel installed on the server.
May 20, 2008May 20, 200805/20/08Hey, Scripting Guy! I read your article on renaming image files so that the pictures could then be sorted in chronological order. When I ran your script, however, it didn’t quite work for me: the files were renamed, but the pictures weren’t sorted the way I had hoped they would be.
February 15, 2008Feb 15, 200802/15/08Hey, Scripting Guy! How can I use a disconnected recordset in Windows PowerShell? I’m able to create the recordset without any problem, but I can’t figure out how to reference the fields and values in that recordset.
— JVDL
Hey, JVDL.
January 15, 2008Jan 15, 200801/15/08Hey, Scripting Guy! Awhile back you showed us how we could use Windows PowerShell to retrieve data from a Microsoft Access database. I’m now trying to add data to a database using PowerShell, but I can’t get the script to work.
August 28, 2007Aug 28, 200708/28/07Hey, Scripting Guy! How can I find all the files in a directory tree that contain a specified phrase?— PB
Hey, PB. OK, so picture this: for the first time in a couple of months, the Scripting Guy who writes this column and the Scripting Son are playing basketball.
July 10, 2007Jul 10, 200707/10/07Hey, Scripting Guy! In a previous column you showed us how to list all the tables in an Access database. How can I list all the fields in those tables, along with the data type of each field?— MF
Hey, MF.
