Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there any way that I can schedule a bug export from TFS. I have my query all set up and can manually export to excel - ideally I want to be able to run this export every night to a csv file sat on a networked disk.

Is there any way of doing this, either within TFS or with Task Scheduler etc?

share|improve this question

To export the query to Excel, you need to initiate the command from Excel. Probably it is possible, but it is not easy.

Another option is to create a PowerShell script or Console application that reads the result of the query and writes the result in a csv file.

A last option is to use reporting services. You don't have a work item query then, but you create a new report that reads from the TFS warehouse and exports the results to CSV (there is in SSRS a scheduling engine you can leverage)

share|improve this answer

Maybe this help you

tfpt query /collection:https://myserver:8443/tfs/Default "Project\My Queries\Android Bug&Change Request List for Release Notes" /format:tsv >c:\test.txt
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.