T-SQL get mail profile and mail accounts from MSDB

Again one of the simple things, maby because I'm to leasy to remember of that I don't like to start profiler each time, or maby because you who did find this blog was just needing it.

SELECT  [profile_id]
, [name]
, [description]
FROM
 msdb.dbo.sysmail_profile
     

SELECT  [a].[account_id]
, [a].[name]
, [a].[description]
, [a].[email_address]
, [a].[display_name]
, [a].[replyto_address]
, [s].[servertype]
, [s].[servername]
, [s].[port]
, [s].[username]
, [s].[use_default_credentials]
, [s].[enable_ssl]
FROM
 msdb.dbo.sysmail_account a
INNER JOIN msdb.dbo.sysmail_server s
ON  a.account_id = s.account_id

Hope you enjoy this blog! When you have comments, better solution and recommendation I like to hear from you. Dynamic Intelligence | LinkedIn | Blog | Twitter