Has anyone attempted to do this?  My DBAs would like a “dashboard” showing the status (green = running, red = stopped) of the “SQL Server Windows Service Name” and the “SQL Server Agent Windows Service Name” for each SQL server.

For the life of me I cannot come up with a solution.

Any help would be GREATLY appreciated.  Been stuck on tihs.

scottbanyas selected answer