I recently received a question asking about getting some of the information from a table in my health check script directly from SQL. So in response to that, here’s some SQL code that will pull out the Management Servers and the Gateways from the SCOM Database, along with some performance collection data about each server.