Cannot see TFS2010 alerts in the Alerts Explorer

PROBLEM:
You cannot see your TFS2010 alerts in the Alerts Explorer

SOLUTION:
This problem can occur after you move your TFS server from one hardware to another.
The following solution removes the old alerts that not configured correctly.
After removing the old alerts, you should create new alerts using the Alerts Explorer

1. Connect to your TFS database and run the following query to get the list of alerts and their ID

select *
from Tfs_DefaultCollection.dbo.tbl_EventSubscription
order by id

2. Open the command prompt in your TFS server, change directory to TFS tools and run the bissubscribe.exe tool with IDs you found in the above select (in this example it 762)

CD "C:\Program Files\Microsoft Team Foundation Server 2010\Tools"
bissubscribe.exe /unsubscribe /collection http://localhost:8080/Tfs/DefaultCollection /id 762

3. Open Alerts Explorer and configure your new alerts

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!