THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Allen White

Use PowerShell to Retrieve your Server Inventory

I've recently completed a chapter for Paul Nielsen's SQL Server 2008 Bible on Scripting with PowerShell. While writing the chapter I created a short script to do a quick inventory of SQL Server information.

Right after I wrote the chapter I was on a consulting assignment where I needed a much more complete inventory of servers, so I expanded the script. I felt it would be useful to others, so I wrote an article and it's now available.

Let PowerShell do an Inventory of your Servers


Published Wednesday, February 18, 2009 1:49 PM by AllenMWhite



Ranga Narasimhan said:

Good article to gather server inventory...Thanks for sharing.

February 19, 2009 9:50 AM

Grant Fritchey said:

I was suddenly given the assignment to verify server status after a network change this weekend. I remembered your script. I stripped out some of the functionality in the interest of speed. I'm able to check connectivity to 24 servers in 15 seconds. Thanks!

Oh, and my team lead suggested that maybe I delay reporting the results rather than make all the other teams look bad! Ha! Thanks again.

March 27, 2009 2:44 PM

The Danish Dynamo said:

How much time would it take to make a 2005 version?

January 3, 2011 3:16 PM

AllenMWhite said:

It already works against SQL 2005 and SQL 2000.

January 3, 2011 3:58 PM
New Comments to this post are disabled

About AllenMWhite

Allen White is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He has worked as a Database Administrator, Architect and Developer for over 30 years, supporting both the Sybase and Microsoft SQL Server platforms over that period.

This Blog


Privacy Statement