Catch: this lists any service that has “SQL” in it, so can potentially list MySQL services too
ListAll SQL services
#list stopped SQL Server services
$computername = "APHRODITE"
Get-WmiObject win32_service -computername $computername |
select name, state |
where {
($_.name -like "SQLAGENT*" -or $_.name -like "*SQL*") `
}
Another way to do this:
#note ComputerManagement works on SQL Server 2005 #on SQL Server 2008 this has to be ComputerManagement10 Get-WmiObject ` -namespace root\Microsoft\SqlServer\ComputerManagement ` -class SqlService | Select-Object ServiceName, DisplayName, SQLServiceType, State
List Stopped SQL services
#list stopped SQL Server services
$computername = "APHRODITE"
Get-WmiObject win32_service -computername $computername |
select name, state |
where {
($_.name -like "SQLAGENT*" -or $_.Name -like "*SQL*") `
-and $_.State -match "Stopped"
}
List Running SQL services
#list stopped SQL Server services
$computername = "APHRODITE"
Get-WmiObject win32_service -computername $computername |
select name, state |
where {
($_.name -like "SQLAGENT*" -or $_.Name -like "*SQL*") `
-and $_.State -match "Stopped"
}
Related posts:
- SQL Server PowerShell : Search for SQL Server Objects Using PowerShell ...
- Creating Reports From SharePoint Lists Using SQL Server Reporting Services (SSRS) ...
- SQL Server PowerShell : How to Audit Your SQL Server Instance Properties Using PowerShell and SMO ...
- List all ASCII characters ...
- SQL Server PowerShell : How to Backup SQL Server Databases Using SMO and PowerShell ...
- SQL Server PowerShell : How to Restore SQL Server Databases Using SMO and PowerShell ...
Filed under:
DBA Toolbox / T-SQL Scripts, Powershell











Leave a comment