THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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

Allen

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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

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

Leave a Comment

(required) 
(required) 
Submit

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

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement