How do I find all alert details stored in TFS?

by Xavier Dilip Kumar 31. October 2015 07:17

Explanation:

Alert details are stored in tbl_EventSubscription table in the collection databases.

Following query will list all alert details

USE Tfs_DefaultCollection
SELECT subuser.AccountName,subuser.DisplayName,MailAddress,alert.EventType,alert.Expression,alert.Address 
FROM    tbl_EventSubscription alert
JOIN    Tfs_Configuration.dbo.tbl_identity subuser
ON      subuser.Id = alert.SubscriberId

Tags:

TFS 2012 | TFS 2013 | TFS 2015

How to resolve TFS item not found conflict type during source code migration / sync?

by Xavier Dilip Kumar 29. October 2015 09:44

Exception:

  • Conflict Type: TFS item not found conflict type
  • Description: This is possible if the item is destroyed or the user does not have read access

Explanation: 

I encountered the above conflict while syncing the team project source code folders\files using migration tools such as Timely Migration and TFS integration platform tools. The sync failed for specific folders and files.

Solution:

After debugging sync issue, found the read permission for the project collection service account was explicitly set to deny on specific project folders which was blocking the sync.

Make sure the account you use for sync don’t have any permissions set to DENY related to source control activities

Tags:

TFS | TFS 2012 | TFS 2013 | TFS 2015

How do I associate work item with check-in using TF.exe command line utility?

by Xavier Dilip Kumar 22. October 2015 13:25

Explanation:

You cannot associate work item with the check-in using tf.exe command line utility from Visual Studio command tools.

Workaround:

You can use the tf.exe from Team Explorer Everywhere to associate work item with the check-in.

tf checkin ItemSpec -associate:WorkItemIds

Tags:

TFS | TFS 2010 | TFS 2012 | TFS 2013 | TFS 2015

How to redirect command output to file and to console window?

by Xavier Dilip Kumar 22. October 2015 09:57

Workaround:

Execute the command in the following format

Your Command > file name | type file name

Example

C:\ dir > dump.txt | type dump.txt

Tags:

General

How to find the TFS scheduled jobs detail?

by Xavier Dilip Kumar 22. October 2015 09:23

Solution: 

You can query the Job details tables in Tfs_Configuration

Query:

SELECT tbl_JobSchedule.JobId, tbl_JobSchedule.ScheduledTime, tbl_JobSchedule.Interval,
tbl_JobSchedule.TimeZoneId, tbl_JobDefinition.JobName FROM tbl_JobDefinition
RIGHT OUTER JOIN tbl_JobSchedule ON tbl_JobDefinition.JobId = tbl_JobSchedule.JobId

Output:
JobId ScheduledTime Interval (Sec) TimeZoneId JobName
C03C29A7-00AE-4E02-94BC-18ACA80E2EA2 7/16/08 3:00 AM 86400 UTC Team Foundation Server Image Cleanup
DD7629E4-66BB-45F9-AD42-2651BD7E56B8 7/3/11 8:00 AM 86400 UTC Team Foundation Server Send Email Confirmation Job
3C601170-8080-4A7D-B8E7-48E991F80C4A 7/16/08 3:00 AM 86400 UTC Team Foundation Server Application Tier Maintanence Job
B1516502-4633-432B-BDB3-74C802C5F2B7 7/3/11 9:00 AM 86400 UTC Team Foundation Server Send Mail Job
544DD581-F72A-45A9-8DE0-8CD3A5F29DFE 7/16/08 3:00 AM 3600 UTC Team Foundation Server Periodic Identity Synchronization
B19DDD28-9A95-42E2-9697-966FD822F1CD 7/3/11 10:08 PM 604800 UTC Prune Registry Audit Log
2ABF4FAB-5E36-4731-9E9F-9694C3CF0592 8/23/12 10:08 PM 86400 UTC File Container Cleanup
63A78C70-8FE0-4743-BA2D-A00CF8C20FDF 7/16/08 3:00 AM 86400 UTC Security Identity Cleanup Job
7A3E559E-8EB7-4E90-A4F7-B7A2515D52B9 7/3/11 9:00 AM 86400 UTC Team Foundation Server Framework File Service Cleanup
AF87E4CD-D421-4A24-BF16-D3A68371703E 7/20/08 3:00 AM 604800 UTC Team Foundation Server Database Optimization
8FC76967-DA5D-4D53-937B-E3EFC6AF0FCB 7/16/08 3:00 AM 86400 UTC Job History Cleanup Job
A4804DCF-4BB6-4109-B61C-E59C2E8A9FF7 7/3/11 8:00 AM 86400 UTC Team Foundation Server Event Processing
AD9C60AE-5BF0-4AC0-BE56-F2988088859A 7/16/08 3:00 AM 86400 UTC Team Foundation Server Activity Logging Administration
81A90003-CA23-4E55-9320-F956F62A2477 7/16/08 3:00 AM 86400 UTC Team Foundation Server Data Maintanence

 

Tags:

TFS | TFS 2012 | TFS 2013 | TFS 2015

Send button remained disabled in TFS request feedback form.

by Xavier Dilip Kumar 21. October 2015 20:47

Solution:

You need to fill all the required fields in the feedback form to enable the activity buttons such as Back,Preview and Send. 

The required fields in the form are marked in yellow

Tags:

TFS | TFS 2012 | TFS 2013 | TFS 2015

How do I request feedback in TFS team project?

by Xavier Dilip Kumar 21. October 2015 20:39

Solution:

  • Open TFS team project's web access
  • On the Home page click on Request feedback under Activities

 

Tags:

TFS | TFS 2012 | TFS 2013 | TFS 2015

How do I perform full backup of a TFS database without affecting the scheduled backups?

by Xavier Dilip Kumar 20. October 2015 13:48

Solution:

You can perform a Copy-Only backup in SQL Server. A Copy-Only is a SQL Server backup that is independent of the sequence of conventional SQL Server backups.

  • Open SQL Server Management Studio
  • Right Click on the TFS database you want to backup
  • Select Tasks --> Back Up... menu

 

  • On the General page of the Back Up Database dialog box, select the Copy Only Backup option.

 

  • Click OK

Tags:

SQL Server

How to recall or replace an email message sent in outlook?

by Xavier Dilip Kumar 19. October 2015 11:13

Solution:

  • Click Sent Items.
  • Open the message that you want to recall and replace.
  • Click on the Message tab

          

  • Click Actions, and then click Recall the Message.          

          

Tags:

General

How do I manage multiple remote desktop connections to the TFS Servers in a complex environment?

by Xavier Dilip Kumar 15. October 2015 09:43

Solution:

Download and manage multiple remote desktop connections using Remote Desktop Connection Manager

About "Remote Desktop Connection Manager"

Tags:

General

About the author

My name is Xavier Dilip Kumar Jayaraj and I am a Software Configuration Management Engineer with a background in application development, Build & packaging using Install Shield.

Profile in LinkedIn

  

Quotes I Like

"Failure will never overtake me if my determination to succeed is strong enough."  - Dr. APJ. Abdul Kalam

"Always be yourself, express yourself, have faith in yourself, do not go out and look for a successful personality and duplicate it." - Bruce Lee

"Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is the most important." - Bill Gates

"Innovation distinguishes between a leader and a follower." - Steve Jobs

Disclaimer

The information provided here is based on my expreriences, troubleshooting and online/offline findings. It can be used as is on your own risk without any warranties and I impose no rights.

Month List