Find mail enabled lists in SharePoint

Open SQL Query Analyzer and run the following query against your WSS_Content database. This works in SharePoint 2007 and 2010. SELECT Webs.FullUrl, AllLists.tp_Title, AllLists.tp_EmailAlias FROM AllLists Inner join webs on AllLists.tp_WebID = Webs.Id where AllLists.tp_EmailAlias is not null

Why Blog?

I’m a IT professional that has been working in the field for 10 years. The purpose of this blog is to help others as they come aross technical challenges and to share my experiences. Keep in tune for the first post of upgrading SharePoint 2010 using the database attach method.

Categorized as Other