Home / server / Questions / 365329
In Process
Matt B
Asked: 2012-03-02 07:46:14 +0800 CST

Schedule a bug export from TFS

  • 772

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?

team-foundation-server schedule task

2 Answers

  1. 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)

    • 1

  2. 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
    • 1