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."  
}