This is a query that I use to replicate the Active Alerts resource in a NOC view. (The original resource limits results to 5 rows by default)
Example Output:
Please vote on this Feature Request to have this functionality added to the native Active Alerts resource:
Enjoy!