Scripting Blog

A place to learn about PowerShell and share stories of automation

February 2009 - Page 2 of 4 - Scripting Blog

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

February 21, 2009 Feb 21, 2009 02/21/09
ScriptingGuy1
How Do I Determine the Versions of Several Executable Files Not Registered in the Registry?   Hey, Scripting Guy! I need your help. I need to know the version of several executable files not registered in the registry. I can find the version of a single executable by using the following code. But I need to "scan” several directories (or...

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

February 19, 2009 Feb 19, 2009 02/19/09
ScriptingGuy1
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! How Can I Tell Which Tables and Columns Are in a Database Without Opening It?

February 18, 2009 Feb 18, 2009 02/18/09
ScriptingGuy1
Hey, Scripting Guy! Is there a way to figure out which tables and columns are in a database without having to open it up?- DT Hi DT, The Impressionists are back in Chicago! For the past six months, they were hibernating down in Ft. Worth, Texas, in the United States. But now they are back. In true Ferris Bueller style, I am standing here ...

Hey, Scripting Guy! How Can I Create a Database with More Than One Table?

February 17, 2009 Feb 17, 2009 02/17/09
ScriptingGuy1
Hey, Scripting Guy! Being able to create a database from a script is nice, and I appreciated your article yesterday. But I need to have a database with more than one table in it. Obviously this can be done, but I am at a loss as to how to go about it. I am not a real programmer; do you have any tips for me?.- GF Hi GF, You need to do what? ...

Hey, Scripting Guy! How Can I Use Windows PowerShell to Create an Office Access Database?

February 16, 2009 Feb 16, 2009 02/16/09
ScriptingGuy1
Hey, Scripting Guy! I have looked everywhere, and I cannot find a script that will create a new Microsoft Office Access database, and automatically add a new table and columns to it. If you had such a thing in Windows PowerShell it would be even better. I know it is probably too much to ask, but could you, would you write such a thing for me...