How To Get Task Id,feature Id,complete Hrs By Accessing Tfs Warehouse By Date In Vs 2017?

how to get Task,Feature id,completed hours by date SQL SERVER QUERY.lets say there is a task 123 in which was created on a sprint which start date is 1st July(1.1.2018) and end at

Solution 1:

Usually, we don't recommend query database directly, you could run TFS query or use TFS api to get the information you want:

Or you could try the extension mentioned in this UserVoice.