I need help getting a list of alerts on a MOSS 07 server.

I'm trying to use STSADM.

I saw the getproperty command for STSADM so I tried.

STSADM -o getproperty -pv alerts-enabled -url http://intranet/

All it did was throw an error.

so it tried

STSADM -o getproperty -url http://intranet/

And found a list of property values.

I'm not sure what I should do to get a list of current alerts in the site collection.

  • what you want, to get all the alerts configured on list? or you want to make sure alerts are enabled?
    – Waqas Sarwar MVP
    Sep 30, 2014 at 17:50
  • @WaqasSarwarMCSE I want a list of all the alerts, in the site collection
    – zingwing
    Sep 30, 2014 at 18:09

1 Answer 1


You can use the pwoershell to get the alerts for a site collection.

  1. First you make sure powershell is properly configured.
  2. Now run the below script and you will get it.

    Add-PSSnapin microsoft.sharepoint.powershell

    $site = Get-SPSite "http://dlvrn2010.com/sites/spalerts/                    
    $alertResultsCollection = @()
    foreach ($web in $site.AllWebs) {  
          foreach ($alert in $web.Alerts){
          $alertURL = $web.URL + "/" + $alert.ListUrl
           $alertResult = New-Object PSObject
      $alertResult | Add-Member -type NoteProperty -name "List URL" -value $alertURL
       $alertResult | Add-Member -type NoteProperty -name "Alert Title" -value alert.Title
       $alertResult | Add-Member -type NoteProperty -name "Alert Type" -value $alert.AlertType
       $alertResult | Add-Member -type NoteProperty -name "Subscribed User" -value $alert.User
          $alertResultsCollection += $alertResult

    Export to CSV

    $alertResultsCollection | Export-CSV "Alerts.csv"

you can use the script from this [codeplex solution][3] also check this User on SharePoint 2007 getting alert that was/is not set up

  • Was PowerShell ever supported for 2007 though? Sep 30, 2014 at 18:50
  • I am not sure about it whether it is supported or not but i give the instruction how to configure powershell.
    – Waqas Sarwar MVP
    Sep 30, 2014 at 19:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.