Is there an SQL query or built in function I can use to export all of my currently assigned SAM/NPM monitors to a spreadsheet or CSV?
You can add essentially whatever information you desire to a report within the report writer and export that date to Excel, CSV, PDF, etc.
Well I'm looking for a list of all assigned application monitors for example and their status (i.e. enabled, disabled, node name, etc). Can I get that through the report writer?
Yes. Everything you listed is available in the Report Writer .Below is an example of what that report might look like, grouped by node, then by application name.