Category Archives: Powershell

PowerShell – Get All SQL Instances On Server

This script will return all SQL instances running on a server or list of servers. cls Import-Module -Name SQLPS -DisableNameChecking $servers = “SERVER_NAME”, “SERVER_NAME_2”, “ETC”; foreach($server in $servers) { $path = “SQLServer:\SQL\” + $server; $instances = Get-ChildItem -Path $path; $instances; }

PowerShell – Get “Logon As” Information From Remote (or local) Server

This was made possible by the Scripting Guy.  I have boiled it down to the answer. If you want to use PowerShell to query for the log on account that normally is displayed in the services.msc service properties window:   Here is the PowerShell script:   $server_name = "name_of_server"; $services = Get-WmiObject win32_service -ComputerName $server_name… Read More »

PowerShell – Getting All Running SQL Services

Getting all SQL Server services running on a server using PowerShell: Get-WmiObject -Class sqlservice -Namespace “ROOT\Microsoft\SqlServer\ComputerManagement11” | Select ServiceName Additionally, this can be set to an array and worked with as such. $services = Get-WmiObject -Class sqlservice -Namespace “ROOT\Microsoft\SqlServer\ComputerManagement11” | Select ServiceName foreach($service in $services) { $service.ServiceName } $services[0].ServiceName >> MSSQLSERVER $services[1].ServiceName >> SQLBrowser $services[2].ServiceName… Read More »