We have a system in use where developers will log a support ticket using a new 'Support Ticket' work item in TFS 2010. If there's a code change as a result they will link the changeset to this work item type. Alternatively if there's a related Bug in the system that requires a code change they will link the Support ticket to the bug and then check in the changeset linked to the bug.
I'm trying to pull out a report either in TFS or preferably using SQL that gives me:
- the number of support tickets created in a month.
- the number of support tickets with linked bugs that have a changeset logged against them
- the number of support tickets with a change set directly linked to the support ticket.
Is there a way to do this in SQL