Alert List for Servers

I have a list of systems that I would like to show if they are up and online or inaccessible. This information is stored in a SQL server database. Using a TSQL query is it possible to display a list when green/red icons like the alert list plugin for the servers?