Alerts not working in sharepoint 2010 after migration

Here is the one issue we will face post migration from 2007 to 2010 or 2010 to 2013

Issue : In SQL database the alerts still refer to old URL's post migration. You can find this from SQL instance by executing the below SQL query


select WebUrl,Properties from immedsubscriptions

This can be fixed by executing a PowerShell script from Kirk stark msdn artcle

NOTE : Save the file, naming it Invoke-AlertFixup.ps1.You must use the provided name or the script will fail, and you must save the file as an ANSI-encoded text file.

Execute the Script report before Actual Replacement :

Invoke-AlertFixup -site "http://teams/sites/newteam"  -Oldurl 

"http://teams/sites/oldteam" -whatif

Actual URL replacement : 

Invoke-AlertFixup -site "http://teams/sites/newteam"  -Oldurl 

"http://teams" 

After executing this script you can check the SQL server data you will find with the updated URL.

Thank you !!