Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Powershell - Document your environment

By Justin Manning,

This script is an improvement from my original script entitled "Powershell - Query SQL Servers Operating system details" (http://www.sqlservercentral.com/scripts/powershell/96809/). I have since changed the script to query AD instead of a central management server. I have also included a few noted on setting up your Powershell environment to work with additional modules required for the script to run.

This script searches through AD, based on a filter you have specified (The filter is based on the naming standard you use for your server names).

Documentation: Computer System information, applications installed and services running on service accounts. If applicable, version of SQL Server installed as well as databases being hosted by the particular SQL Server. Server memory as well as logical disk allocation and sizes.

Please let me know your thoughts on this script. I have recently started playing around with Powershell and think it is an amazing tool for all administrators in an environment and extremely beneficial to organizaation.

Total article views: 1837 | Views in the last 30 days: 24
 
Related Articles
SCRIPT

SQL Powershell Script to check Server Uptime Remotely

SQL Powershell Script to check Server Uptime Remotely

ARTICLE

Powershell Database Backup Script

Learn how to write a script for regular database backups using Powershell and SMO.

SCRIPT

PowerShell - Restart Services

A PowerShell script which restarts any service running on a server.

BLOG

Performing an INSERT from a PowerShell script

This code demonstrates how to do an INSERT into SQL Server from a PowerShell script using an ADO.NET...

SCRIPT

SQL Powershell Script to check Server's disk space Remotely

SQL Powershell Script to check Server's disk space Remotely

 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones