Using powershell get the discussion topics in SharePoint 2010

In this you will see how to get only the discussion topics using Powershell.

I have a Discussion list named "Team Discussion" in which i have created two topics and each topic has few replies.

I want to retrieve only the two topics using Powershell.


Powershell Script:

 

$site=Get-SPSite "http://serverName/sites/VJTesting/"

$web=$site.OpenWeb()

$list=$web.Lists.TryGetList("Team Discussion")

if($list -ne $null)

{

      $query=New-Object Microsoft.SharePoint.SPQuery

      $itemColl = $list.GetItems($query)

      foreach($item in $itemColl)

      {

            Write-Host -ForegroundColor Green $item["Title"]

            Write-Host -ForegroundColor Green $item["Replies"]

      }  

}

else

{

      Write-Host -ForegroundColor Yellow "List does not exists." 

}

Ebook Download
View all
Learn
View all