I need to collect certain data from TFS that is not configured as reportable by the TFS administrators using the TFS SQL DB. For example, if I need to query for the dates on which a set of work items was closed, I can do so within TFS, but when I write a SQL query (SELECT microsoft_vsts_common_closeddate FROM table WHERE ), the value for the closed date in every one of the items is NULL (the administrator has confirmed that this data is not provided to the TFS DB, only through queries written in TFS).
Because it's a shared server, hosting multiple TFS projects, they cannot make these fields reportable. Can I capture this data by creating custom fields, with all of the field configurations being the same as the default field except for the reportable value, which I would set to something other than NONE?