Pull up historical reports for audit. I was told this can be pulled from the database but can it be pulled from UMP as well?
Looking for this I think
NAS_TRANSACTION_LOG and NAS_TRANSACTION_SUMMARY
You should be able to run a query from the SLM portlet the same way you run against DB but that's not really a good idea.
Better option would be to create and run the Alarm reports from CABI/Jasper (provided you are using it), you don't really have a simple way to extracting the Alarm Reports from UMP
Alternatively you can create a basic report in a UMP custom dashboard using a SQL query as the source.