SQL query

SQL query

I need to run a few sql queries to produce an audit report.  I need to list all the current monitor for all devices; all the monitors available (I know, a lot), maybe per manufacturer; all the alerts per current devices.  I can pull out all the devices via normal reporting and have tried to get the list of monitors and alerts the same way, but the reports weren't set up for that.  What table or tables am I looking for?

                New to ADSelfService Plus?