Ask a questionAsk a question
 

AnswerCreating a User Activity Report in TFS

  • Wednesday, November 04, 2009 6:29 PMpenguinjay Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I have recently taken over as TFS admin, and my boss asked for a complete user activity report for a specific user across multiple projects.  The old TFS admin showed me a GUI option before he left.  I thought this was a power toy, but I cannot seem to find it now.  Can someone point me in the right direction?  Or if the only way to do this is through a SQL query please let me know that too.

    Thank you,

Answers

  • Monday, November 09, 2009 6:14 AMRuiz YiModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Hi,

    I did not notice such application before.
    1 As TFS use Window Authentication, so there is no explicit information about users' login time.
    2 For workitem tracking and version control activitiesm  you can search  TfsActivityLogging.tbl_Command in data tier.

    If you know the application from old TFS admin , could you share with us?

    Best Regards,
    Ruiz

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Sincerely, Ruiz Yi

All Replies

  • Friday, November 06, 2009 9:10 AMRuiz YiModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hi,

    Which kind activity do you want to get?

    Best Regards,
    Ruiz
    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Sincerely, Ruiz Yi
  • Friday, November 06, 2009 2:31 PMpenguinjay Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I am looking for all user activity including; login, creation of work items, modification of work items, check in/check out of code.

    Thank you!
  • Monday, November 09, 2009 6:14 AMRuiz YiModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Hi,

    I did not notice such application before.
    1 As TFS use Window Authentication, so there is no explicit information about users' login time.
    2 For workitem tracking and version control activitiesm  you can search  TfsActivityLogging.tbl_Command in data tier.

    If you know the application from old TFS admin , could you share with us?

    Best Regards,
    Ruiz

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Sincerely, Ruiz Yi