Is it possible to generate a list of all the locked files in the StarTeam database?
Yes, this can be done by querying the StarTeam database using custom SQL code. The code below will output all Locked files in the StarTeam database:
SELECT * FROM syn_file WHERE id IN
( SELECT id FROM syn_file WHERE rootobjectid in
( SELECT DISTINCT(rootobjectid) FROM syn_viewmember WHERE id IN
( SELECT itemvmid FROM syn_itemlock ) ) GROUP BY id ) AND endmodifiedtime = 0
The code above could be saved as a SQL file and executed from a
The following command from a batch file will execute the SQL and output to text file.
osql -U sa -P StarTeam123 -S .\SSE2005_ST -d starteam_stardraw100_db -n -i locked_files.sql > Report.txt
In order for this to be run , you need to do the