visual studio 2012 - TFS Queries - How to determine who created a shared query and when -

visual studio 2012 - TFS Queries - How to determine who created a shared query and when -

we using tfs 2012 , have hundreds of shared queries have been created on time due poor oversight. in order clean these , provide mutual set of shared queries, we'd determine created queries , when, similar work item type history.

is there way find info in tfs ux, using extension or querying db?

you can find owner of query in team web looking @ security of query, doesn't show create date.

the info need stored in queryitemstable of each collection db.

so, should able info sql query below, alter out db names collection db.

select t.name 'projectname' ,qi.[name] 'query name' ,[text] ,[createtime] ,[lastwritetime] ,c.displaypart 'owner' [tfs_defaultcollection].[dbo].[queryitems]qi left bring together [tfs_defaultcollection].[dbo].[constants] c on c.teamfoundationid=qi.owneridentifier left bring together [tfs_defaultcollection].[dbo].[treenodes] t on t.id=qi.projectid fpublic=1 , ffolder=0

visual-studio-2012 tfs tfs2012