How to retrieve the number of Email Enabled List in a SharePoint Farm

Does anyone know how to get the number of email enabled lists in a MOSS Farm?
snazaireSharePoint AdminAsked:
Who is Participating?
liebrandConnect With a Mentor Commented:
You can run this query in the Content DB you want to see:

select RootWeb.FullUrl,
	   l.tp_Title as [List Name],
  from AllLists l
  join Webs w
    on l.tp_WebId = w.Id
  join Sites s
    on w.SiteId = s.Id
  join Webs RootWeb
    on s.RootWebId = RootWeb.Id 
 where (l.tp_EmailAlias is not null
    AND l.tp_EmailAlias <> '')

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.