TFS & Visual Studio ALM – by Neno Loje

(formerly Team System, VSTS)

Who created that TFS event subscription?

March 23rd, 2011 · No Comments · TFS Project Portal and Team Communication, Troubleshooting TFS

In TFS you can use Project Alerts or Alerts Explorer to edit your subscriptions. You will not see subscriptions created by others.

To see all subscriptions you could have a look at the tbl_EventSubscription table in the collection database (Caution: Do not make any changes to the TFS DBs!).

I am getting mails from TFS - who created that subscriptions?

To find out which user identity is hidden behind the GUID in the "SubscriberId" column, you can use the following SQL statement

SELECT  es.Id,
FROM    tbl_EventSubscription es
JOIN    [Tfs_Configuration].[dbo].tbl_security_identity_cache sic
ON      sic.tf_id = es.SubscriberId
WHERE   es.Id = 123

where 123 is the Subscription ID (see "Id" column in the screenshot above).

(Thanks to Patrick Carnahan from Microsoft for helping me out with this and providing the SQL statement above)


No Comments so far ↓

There are no comments yet...Kick things off by filling out the form below.

Leave a Comment