Is it possible to find the total number of files and the total file size for all files added to my entire StarTeam server configuration?

0 Likes

Problem:

Is it possible to find the total number of files and the total file size for all files added to my entire StarTeam server configuration?

Resolution:


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

Yes, this is possible via a direct query to the StarTeam Database.

The query below will output

  • Total number of files added to all projects
  • Total file size (in bytes) of all the files added to all projects
SELECT SUM(FileSize) AS [Total File Size],
COUNT(ProjectID) AS [Total Amount Of Files]
FROM syn_File
WHERE (ProjectID >0)

To output the total file size in Kbytes use

SELECT SUM(FileSize / 1024) AS [Total File Size],
COUNT(ProjectID) AS [Total Amount Of Files]
FROM syn_File WHERE (ProjectID >0)

Old KB# 28656
Comment List
Related
Recommended