June 8, 2017 at 2:31 am
Hi I´ve tried to create scripts in Powershell to list all the SQL servers in our enviroment but hasn´t really had any success. I´m a newbee in Powershell. We have SQL 2008 R2 , SQL 2012 R2 and SQL 2016 + some Express servers and I want to get a list of which servers is running SQL and which version. Do You DBA´s have some nice ones, or tip how to do it ? With Regards |
June 8, 2017 at 5:05 am
I trust Edwin to know what he's talking about, so here's a good article. I'd pay attention to the caveats because that's where the pain points may come from. Also, be sure you work with your network admin because you're basically acting like an attack on the network with this sort of approach.
The scripts are written using the older style syntax, so you might want to update to the latest commands however the concepts are the same.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply