Created On:  05 October 2011

Problem:

Is there a way to create a report which shows all the fields and their values within StarTeam based on a specific item type?

Resolution:

This can be achieved in MS SQL Server by running a SQL query against the StarTeam database.

1.  Download the attached SQL file, "ReturnFields.SQL"
2.  Open the file and edit according to the item type the fields you wish to return. See included comments for further instruction.
3.  Open SQL Management Studio
4.  Right click on the StarTeam database
5.  Select "New Query"
6.  Copy the contents of the edited SQL script into the query pane
7.  Execute the query

The results will display all of the fields for the specified item type.
Incident #2437659