Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

2 Answers

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
add comment

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
add comment

Your Answer

 
discard

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.