Report - developers who are not checking in their code regularly

Hot Topic

Team Build Failure on Tests
VSTS 4 DB : How about OLAP?
Work Item Submission?
list of fixes or improvements for VSTS from Beta 2 release to July CTP version
TFS not seeing all accounts properly
Empty results generated when code coverage is enabled
Restore a specific file
TF30177: Team Project Creation Failed
What's new in June CTP of VS 2005?
A branch has been deleted but tf get still gets files in the branch

VS Team System

Build server output folder
Verifying an image on the page
Project creation fails
Hierarchicaly linked work items
Unattended install of TFS Server
How can I make VS understand that a project is a test project?
From RUP to MSF???
Web Testing - When used in Load Test, nothing written to System
Error 32000 widbloc.exe - <servername> -d CurritukDB Returned a non-zero value:1
Why does CA1059 Members should not expose certain concrete types exist?

Report - developers who are not checking in their code regularly

I would like to create a report showing code that has been checked-out for longer than 2 weeks. I don't see this type of information contained in the BisDWDB, so I would assume I need to access the VSTeamSCC db instead. Is this correct If so, what tables would I need to select


Answer this question

Report - developers who are not checking in their code regularly

  • Gordon Smith

    So, that sounds like files checked out, per user, in at least one of their workspaces.

    Given that shelving is intended to (among other things) allow code to be saved but not checked in, I'm still not sure how you'd want to account for files that aren't checked out but are in shelvesets.

    I'll find out whether we record checkout time or not (we definitely record checkin time), and whether we can get this data exported to the warehouse or not if so. Stay tuned...

  • SHBEHM

    I don't know whether you can achieve this using the reports feature, but you can use the status command to get the information.  If you run "h status $/ /r /user:* /format:detailed" you'll see every pending change in the system and when each change was pended (you need /format:detailed to get the date).

    Buck

  • mikeb_

    I want to be able to run a report on all team projects and get a list of files that are still checked out and have been for over 2 weeks. (Currently we do this with vssreporter.) This lets us know two things: which developers are not checking in their code regularly (one of our development standards) and which files have been temporarily abandoned for higher priority work.

    I do hope that check-out/in times are recorded in VSTF.

  • james_m

    The VSTeamSCC database is not intended (or permissioned) to be queried directly.

    Tell me a little bit more about what you're trying to accomplish and I'll see how hard it would be to get the required data exported to the warehouse.

    Do you want code checked out in any (at least one) workspace or a specific workspace (or both)
    In one or more workspaces for a particular user
    Should items in shelvesets be considered checked out
    Checked out against the latest version or just checked out (As in, if there's been a checkin to the item, does the clock restart )

    I'm not actually 100% sure that the time the file was checked out is recorded - I'll find that out first.



  • TweezerMan

    Checkout time is what I am curious about.



  • melendez

    I'm sorry - does this mean run this command from the (VS 2005) command prompt "h" is not a valid command, nor is "status".

    This is exactly what I was looking for, but how do you run it (I'm running VS 2005 Team Developer)

    Thanks,

    John


  • Lew130

    Substitute "tf.exe" for "h.exe". When Buck wrote that post we hadn't removed codenames yet (Hatteras -> Team Foundation).
  • Report - developers who are not checking in their code regularly
Answer this question