I am trying to build a monthly report that will display information about the health and performance of Orion as a whole. In the report I would like to see the Polling Engine Status (I know this is a snapshot and I know you can get this already by using the "Polling Engine Status" resource name in reports), the Overall Health of the Polling Engine Servers, Database Status (Basically the output of Orion/Admin/Details/DatabaseDetails.aspx), and maybe some information regarding the health of the database servers as well as the number of alerts triggered which are specific to Solarwinds services.
Does anyone have any idea on where I could get started with some SQL queries to get some of the data?
