Is it possible to find the total number of files and the total file size for all files added to my project?

0 Likes

Problem:

Is it possible to find the total number of files and the total file size for all files added to my project?

Resolution:


  • Product Name: StarTeam
  • Product Version: All
  • Product Component: Database
  • Platform/OS Version: All

Yes. This is possible by querying the StarTeam database. Running the SQL code below will return the desired information:

SELECT SUM(FileSize) AS [Total File Size],
COUNT(ProjectID) AS [Total Amount Of Files]
FROM syn_FileWHERE (ProjectID = 1)


The above query will output two results:

Total File Size for all files for ProjectID = 1
Total Amount Of Files for ProjectID = 1

The ProjectID is stored in the database in the syn_View table . This table assigns a unique Id to each StarTeam project you create.


Old KB# 28655
Comment List
Related
Recommended