Powershell Script to check sql services Status

PS script to check all sql services status installed on machine :

get-service -displayname sql* -comp DESKTOP-02JIB76 |select-object -p status,name,displayname

PS script to get only running status of sql services :

get-service -displayname *sql*server*|findstr -i Running

PS script to get only Stopped status of sql services :

get-service -displayname *sql*server*|findstr -i stopped

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.