Post reply

Query Work Items in TFS from SQL

  • February 15, 2012 at 2:23 am

    #268430

    Hi All

    Just wondering if anyone knows of a way to get Work Item names from the TFSWarehouse database?

    They are inserted with what I can only really describe as a TFS GUID which I cant seem to translate to a table to get the WI name.

    Trying to do this via T-SQK direct on the database rather than using WIQL via Visual Studio as its not really that clued up for the information that the people want on the reports.

    Any help is appreciated.

    Thanks

    Ant

  • February 15, 2012 at 3:43 am

    #1447228

    Not sure if this is what you are looking for - did you check the System_Title column in the DimWorkItem table?

    http://blogs.msdn.com/b/nericson/archive/2010/03/08/tfs-2010-method-to-get-work-items-as-of-a-date.aspx

  • February 15, 2012 at 3:53 am

    #1447236

    Thanks alot, thats the one, I only did a TOP 1000 and they where all NULL so I skipt over that column.

    Much appreciated.

  • February 17, 2012 at 3:13 am

    #1448367

    just wondering, do you know where iteration capacity and individual capacity is stored in the warehouse so we can see if a iteration or person is over or under estimate etc

    does it in SSAS I believe but having trouble with SSAS at the moment so trying to get it from the DB.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply