8 august 2012 20:13
I need to add the creation date to a report that I'm generating with VS 2010 / C#. I query the project collections, then projects for the names of the projects.
What code would I use to get the 'date created' on a given project?
10 august 2012 07:13Moderator
Thanks for your post!
Do you want to query the creation date of a team project? If yes, please perform the following SQL query:
SELECT [project_name],[last_update] FROM [Tfs_DefaultCollection].[dbo].[tbl_projects]
WHERE [project_name]= 'ProjectName'
TFS store Date Time as the UTC time in DB. TFS Server can works across the regions, the UTC time as the standard time for different areas. You should covert the UTC time back to the local time in your report code. Pleaser refer to this blog for it:
Hope it helps!
Cathy Kong [MSFT]
MSDN Community Support | Feedback to us
- Editat de Cathy KongMicrosoft Contingent Staff, Moderator 10 august 2012 07:14
17 august 2012 21:09
What additional code is needed to connect to the DB? I haven't used this before. Does this require LINQ or a DataReader?
19 august 2012 14:50Would this be easier to do by querying the WorkItems for the first item in a project's history?