Break it, fix it

If you ever need to retrieve the parameters (and respective values) of a test case (for reporting purposes for example), the database table to read is Tfs_<CollectionName>.dbo.WorkItemLongTexts . It contains the HTML/XML field values for each workitem. The only missing part is the ID of the actual field you want to retrieve : FldId 10018 contains the definition of the parameters FldId 10029 contains the values of the parameters

If you need to create reports for TFS, most of the time it is much easier to create them by copying an existing report. As I need to do this frequently, I decided to create a template to minimize the amount of work. Here is a link to the TFS report template.