Today I want to share one script that I use very frequently through Central Management Server to monitor the SQL services current running status.
This script will work from SQL Server 2008R2 SP1 onward as DMV dm_server_services was introduced from 2008R2 SP1.
Below is the script:
FROM sys.dm_server_services dss
WHERE dss.[servicename] LIKE N’SQL%’
Hopefully this will be useful for you in monitoring your inventory.