TFS Activity in the past X minutes

If you ever need to see if there’s any activity on your TFS Server in the past few minutes (maybe you are planning to take down the server or you are just troubleshooting a connectivity issue), you can run this query in SQL Server, on your collection database:

SELECT IdentityName, StartTime, [Application], Command
FROM tbl_Command with (nolock)
where StartTime > DATEADD(MINUTE, -10, GETUTCDATE())

The table tbl_Command has a few interesting pieces of data.  This query brings back all the commands that were executed in the past 10 minutes.  Remember that TFS keeps saves data in UTC time.

10 thoughts on “TFS Activity in the past X minutes

  1. crorkserv

    Every Saturday this year, our managing editor reviewed thelarge Outsports stories of the week and ranked them as winners or losers.

  2. click here

    Asking questions are actually nice thing if you are not understanding anything fully, but this piece of writing offers nice understanding even.

  3. Bounce House Rentals St. Louis

    An interesting discussion is definitely worth comment. I believe that you need to publish more about this issue, it might not be a taboo subject but usually people don’t speak about these topics. To the next! Many thanks!!

  4. Merchant Services Business

    I really like and appreciate your blog post. Really Great.

  5. Audio visual rentals

    Hello my loved one! I wish to say that this article is awesome, great written and come with approximately all vital infos. I would like to see more posts like this .

  6. new sex positions

    I am so grateful for your post.Thanks Again. Much obliged.

  7. Where to find new crypto projects before listing

    Fantastic post.Really thank you! Cool.

  8. metallicheckie lestnici

    Rattling nice design and style and excellent written content , practically nothing else we need : D.

  9. 2 Dads Bounce Houses Peoria

    This post truly made my day. You can not imagine just how much time I had spent

Leave a Reply

Your email address will not be published. Required fields are marked *