Created On:  13 December 2010

Problem:

To assist with administratiion is it possible to report on the private queries and filters that have been created and the users who created them?

Resolution:

The following solution is for SQL Server databases only.  Open SQL Query analyser and execute the following against the StarTeam database as a single query:

select Name as FilterName, (select Full_Name from syn_user WHERE ID=F.userid)as [User Name] from syn_files_filters2 F WHERE f.userid <> -1
select Name as QueryName, (select Full_Name from syn_user WHERE ID=F.userid)as [User Name] from syn_files_queries2 F WHERE f.userid <> -1


This will show a list of filters and their owners and a list of queries and their owners:



It is not possible to report on the ownership of public queries or filters.
Incident #2481167