This script will create a report with the To/From email addresses and the SMTP server used for every alert.
Orion.Actions.Properties.PropertyValue contains the SMTP server ID but is blank in the cases where the alert uses the 'default' SMTP server. This results in a server lookup value of NULL. Someone with more SQL skills can probably figure out how to deal with that appropriately. In this version it is handled with a CASE statement that populates the value 'DEFAULT' rather than having it show as NULL.