Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue$SPWebApp = Get-SPWebApplication "<a class="vglnk" href="http://sharepoint.com" rel="nofollow"><span>http</span><span>://</span><span>sharepoint</span><span>.</span><span>com</span></a>" <# If it is MOSS 2007, You can use:$SPWebApp = [Microsoft.SharePoint.Administration.SPWebApplication]::Lookup(<a class="vglnk" href="http://sharepoint.com" rel="nofollow"><span>http</span><span>://</span><span>sharepoint</span><span>.</span><span>com</span></a>) To get SPWebApplication Object#> #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 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 } } }}
1
2
3
4
5
6
7
8
9
10
11
| #Variables$TaskName = "Audit Large Lists"$username ="Crescent\SP13_FarmAdmin"$password ="Password Here"#Create Scheduled Task$Action = New-ScheduledTaskAction -Execute "PowerShell.exe" -Argument "E:\Scripts\AuditLists.ps1"$Trigger = New-ScheduledTaskTrigger -Daily -At 1am$ScheduledTask = New-ScheduledTask -Action $action -Trigger $trigger Register-ScheduledTask -TaskName $TaskName -InputObject $ScheduledTask -User $username -Password $password |
