Creating a User Activity Report in TFS

Question

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,

Answer 1

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

Answer 2

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!

Answer 3

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