Allow Notification Rules to be Created by Administrators
Today in order to create notifications, I have to create one per user under my user account. There is no way to create a rule for notifications, such as when a work item gets changed, notify the assigned to user, no matter who that user is. Today we have to create a rule like this for every user. And, this rule is not shared, so if another admin wants to tweak the rule, he can't because its under my account.
2 comments
-
Anonymous
commented
For our TFS we are using nice script that creates an automatic subscription on work item changes for every active user in project collection. Of course, would be nice to integrate this into TFS as a standart feature for admins.
use [Tfs_DefaultCollection]
delete from dbo.tbl_EventSubscription where EventType = 'WorkItemChangedEvent' and DeliveryType=0
and Classification in ( 'AutoGenerated:WorkItemChangedEvent', 'AutoGenerated-Fallback:WorkItemChangedEvent' )INSERT INTO [dbo].[tbl_EventSubscription]
([EventType]
,[Expression]
,[SubscriberId]
,[Schedule]
,[DeliveryType]
,[Address]
,[Classification])
SELECT
'WorkItemChangedEvent'
,'("CoreFields/StringFields/Field[ReferenceName=''System.AssignedTo.$SID'']/OldValue" = '''
+ ObjectSID
+ ''' OR "CoreFields/StringFields/Field[ReferenceName=''System.AssignedTo.$SID'']/NewValue" = '''
+ ObjectSID
+ ''') AND "CoreFields/StringFields/Field[ReferenceName=''System.AuthorizedAs'']/NewValue" <> '''
+ DisplayName
+ ''''
,TeamFoundationId
,0
,0
,MailNickName
,'AutoGenerated:WorkItemChangedEvent'
FROM dbo.ADObjects
WHERE fDeleted = 0 and ObjectCategory in (2,3)
select * from dbo.tbl_EventSubscription
-
Anonymous
commented
Couldn't agree more. Ms is king of pushing policies out to all users. TFS has no ability to do this.