Get external lists

Add-PSSnapin Microsoft.SharePoint.PowerShell

$CurrentDirectory =  Split-Path -parent $MyInvocation.MyCommand.Definition

$Sites= Get-content "$CurrentDirectory\webapp.txt"

$csvPath = "$CurrentDirectory\ExternalList.csv"

foreach ($site in $Sites)

  {

    

      write-host " WebApplication :  $($site)" ;

$SPWebApp =  Get-SPWebApplication $site

 

#then we can pipe the web application object to get all Site collection   

   

$SCall = $SPWebApp | Get-SPsite -Limit All   

 

#this command will get all site collection present in the web application and storing it in a PS object so that we can loop it to get all subsite present in site collection   

   

foreach($sitecollection in $SCall )   

{   

    write-host " Site Collectioin : $($sitecollection.Url)" ;

    $SCwithSubsite = $sitecollection.AllWebs    

      foreach($site in $SCwithSubsite )   

       {   

          write-host "Subsite url : $($site.Url)"

           foreach($list in $site.Lists)   

          {   

            write-host "list  Name: $($list.Title)" -ForegroundColor Yellow

          

              if($list.hasexternaldatasource )   

                {   

                 write-host "list  Name: $($list.Title)" -ForegroundColor Red

          

                    

                      add-content $csvPath "  $($site.Url), $($list.Title),$($list.DataSource.GetEntity().Name)"

                }

             

            } 

         } 

} 

}