Hi having trouble finding this if it was asked before.

What I'm looking to do is create report via sql to find all my monitored systems and show what is monitored and who is emailed when alert is generated. We had some employes changed and need to change them. Going manual is not practical. I tried vmonitoralarm tables and others but these only seem to pull the ones that had alerts generated. Is this possible? Thanks!