Have you ever had someone send you the name of a SQL Server and database to do some work, but when you try to connect to the server you can’t? Then,come to find out, there are four named instances on the box and you don’t know which one hosts the database? No? Just me?
Luckily, dbatools has a couple of commands that can help us out with this. Firstly, we can use
Get-DbaService to get a list of instances that are running on the server:
I went ahead and piped this to the Select-Object and built the SqlInstance property to be ‘ServerName\InstanceName’. We can now use this in any of the other dbatools commands. For my use case I wanted database information, so I went with
This made it easy for me to find the database in question without having to connect to each instance manually.
You could also use this if you had a list of servers by just passing in a comma separated list to the
-ComputerName parameter on
Just a short post today, but hopefully useful to somebody.