Powershell - Collecting and Reporting on SQL Instances
Generate a list of every SQL Instance on your Servers
To be successful as a Systems Administrator, you need to be able to collect information about your environment. This little guide will show you a simple and effective way to collect and report on every SQL Instance that is installed on a server in your domain. Overview I like to write functions and automated collection scripts, so I can have up to date reports. Sometimes it makes more sense to take someone else's code if for no reason other than saving time and effort.
I have been using Boe Prox's useful Get-SQLInstance for several years and thought I would share how I use it. Get-SQLInstance supports SQL versions 2000 - 2016. PrereqsYou need an account with Administrative permissions on every server you want to run the script againstThe account must have the ability to query AD for server namesDownload Get-SQLInstance from https://gallery.technet.microsoft.com/scriptcenter/Get-SQLInstance-9a3245a0 Create a script folder a…
To be successful as a Systems Administrator, you need to be able to collect information about your environment. This little guide will show you a simple and effective way to collect and report on every SQL Instance that is installed on a server in your domain. Overview I like to write functions and automated collection scripts, so I can have up to date reports. Sometimes it makes more sense to take someone else's code if for no reason other than saving time and effort.
I have been using Boe Prox's useful Get-SQLInstance for several years and thought I would share how I use it. Get-SQLInstance supports SQL versions 2000 - 2016. PrereqsYou need an account with Administrative permissions on every server you want to run the script againstThe account must have the ability to query AD for server namesDownload Get-SQLInstance from https://gallery.technet.microsoft.com/scriptcenter/Get-SQLInstance-9a3245a0 Create a script folder a…