Sharepoint: How do i find a mail enabled list, if i only have the email?

I know the email from a mail开发者_开发技巧 enabled list, with I have no idea where the list lies. How do i find the list to which the email belongs to?

The code below works if you know the site collection of the list. If you don't know that, you can easily modify the code to loop a complete web application (or even a complete farm):

using System;
using Microsoft.SharePoint;

namespace FindListByEmail
{
    class Program
    {
        static void Main(string[] args)
        {
            string siteUrl = "[complete this]";
            string email = "[complete this]"; // only the part before the @

            using (SPSite site = new SPSite(siteUrl))
            {
                foreach (SPWeb web in site.AllWebs)
                {
                    try
                    {
                        foreach (SPList list in web.Lists)
                        {
                            if (list.CanReceiveEmail)
                            {
                                if (list.EmailAlias != null && list.EmailAlias.Equals(email, StringComparison.InvariantCultureIgnoreCase))
                                {
                                    Console.WriteLine("The email belongs to list {0} in web {1}", list.Title, web.Url);
                                    Console.ReadLine();
                                    return;
                                }
                            }
                        }
                    }
                    finally
                    {
                        if (web != null)
                        {
                            web.Dispose();
                        }
                    }
                }
            }
        }
    }
}

To find All Incoming E-Mail Enabled Lists and Libraries in SharePoint, You can use PowerShell , C# code or SQL Server Query!

Find the PowerShell Script, SQL Query and C# code here: http://www.sharepointdiary.com/2011/06/find-all-incoming-email-enabled-lists.html#ixzz2aKvhRTDN