Get all Email Enabled Lists in Farm via powershell

[Microsoft.SharePoint.Administration.SPWebApplication]::Lookup(“http://myspfarm”)

That fixed the issue for me. Here’s the full code below. It kicks out the report into a csv file that you can import into your favorite csv editor, and make the report pretty.

#Load SharePoint Asssemblies
[System.reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint”)
[System.Reflection.Assembly]::Load(“Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c”)
[System.Reflection.Assembly]::Load(“Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c”)

$SPwebapp = [Microsoft.SharePoint.Administration.SPWebApplication]::Lookup(“http://myspfarm”)

#create a CSV file
“E-Mail,List,Site” > “EMail-Enabled.txt” #Write the Headers in to a text file

foreach ($SPsite in $SPwebApp.Sites)  # get the collection of site collections
{
foreach($SPweb in $SPsite.AllWebs)  # get the collection of sub sites
{
foreach ($SPList list in $SPweb.Lists)
{
if ( ($splist.CanReceiveEmail) -and ($SPlist.EmailAlias) )
{
# WRITE-HOST “E-Mail -” $SPList.EmailAlias “is configured for the list “$SPlist.Title “in “$SPweb.Url
$SPList.EmailAlias + “,” + $SPlist.Title +”,” + $SPweb.Url >> EMail-Enabled.txt  #append the data
}
}
}
}