Scripting Blog

A place to learn about PowerShell and share stories of automation

Hey, Scripting Guy! Weekend Scripter: Using the Windows Search Index to Find Specific Files

  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. This technique can have some very interesting possibilities...

Hey, Scripting Guy! Can I Query a Microsoft Access Database with a Windows PowerShell Script?

 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? I do not want you to write it for me, but I would like a hint.-- KS Hello KS, Microsoft ...

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

Troubleshooting 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 ...

Hey, Scripting Guy! How Can I Write to Excel Without Using Excel?

Hey, 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, and he can create pivot tables, charts, or whatever exactly it is he does all day. Basically, ...

Hey, Scripting Guy! How Can I Read from Excel Without Using Excel?

Hey, 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. How can I use this spread sheet without installing Office on my server (which I understand is ...

Feedback usabilla icon