ssxphysical

Purpose

This tool replaces the Microsoft 'ss physical' command line command.

It generates a neatly formatted concordance between physical and logical file names.
The list is in logical project name sequence.

Summary Active (and optionally Deleted) totals are appended to a 'physical.tot' file>
so you can track the overall growth of the database.

ssxphysical is an extended version of ssphysical which it replaces.
If you are using ssphysical now, you should upgrade - see the Installation section below.

The differences are that :

ssxphysical runs directly against the specified SourceSafe database. It is no longer necessary to run the SourceSafe 'ss physical $/ -r -ophysical.txt' command first to generate a physical.txt input file.

The size in bytes is now listed for each Project and file, and totalled.

A new column indicates if a file is shared. An 'S' indicates the primary shared file, with a size associated with it. An 's' indicates a secondary shared file. The file size for secondary shared files is always zero as they are accounted for by the primary 'S' entry.

A new column indicates if a project or file is deleted, either directly or because it is in a Project that has been deleted.

A new column indicates if a file is pinned, and if so which version is pinned.

SS

Tested with SourceSafe V5.0 V6.0.

OS

Windows NT/2K/XP Command line utility.

ssxphysical v2.08
Syntax :
ssxphysical PathToVssDataDirectory -D -P
The PathToVssDataDirectory parameter is mandatory.
The -D parameter is optional.
If not supplied, only Active Projects and Files are listed.
If supplied Deleted Projects and Files are also listed.
The -P parameter is optional.
If supplied, only Pinned files are listed.

Example
ssxphysical j:\test\databases\minibase\data

Outputs

#1 : physical.ddd (mon...sun)

ssxphysical v2.08    Projects and Files for database j:\test\databases\minibase\data  Tue Jun 21 18:37:05 2005
T SD Pinv Physical Size-Bytes  Logical Name

P         aaaaaaaa       3492  $
P         DAAAAAAA       4453  $/New
F         GAAAAAAA       7765  $/New/readme.txt
F  D      HAAAAAAA      48641  $/New/ssxphysical.exe
F S       BAAAAAAA       2031  $/New/test.50
F  D      IAAAAAAA       4603  $/New/xphysical_day_gen.bat
P  D      EAAAAAAA       1313  $/New/new01
P  d      FAAAAAAA        837  $/New/new01/new02
P         CAAAAAAA       2677  $/Test
F  D      KAAAAAAA       9729  $/Test/r32_ssx.reg
F       4 JAAAAAAA       2762  $/Test/ssx.reg
F s       BAAAAAAA          0  $/Test/test.50
P         LAAAAAAA       3217  $/TildeFileName
F         OAAAAAAA      20681  $/TildeFileName/~APS7
F       1 MAAAAAAA       5141  $/TildeFileName/~DF3692.tmp
F         NAAAAAAA       1549  $/TildeFileName/a~bc.txt
F         PAAAAAAA       1545  $/TildeFileName/abcd~2.txt
F         QAAAAAAA       1543  $/TildeFileName/abcde~1.txt

P=Project
F=File
  S=Primary shared file
  s=Secondary shared file
   D=Primary deleted project or file (VSS Explorer Property | Deleted Items tab)
   d=Secondary deleted (project or file within a primary deleted project).
    nnnn = If the file is pinned, the pinned version is listed.

------------------------------------------------------------------------------------------
Date     : Tue Jun 21 18:37:05 2005
Database : j:\test\databases\minibase\data

Summary |    Files  Projects     Total  |   Files-Bytes   Projects-Bytes      Total-Bytes
Active  |        8         4        12  |         43017            13839            56856
Deleted |        3         2         5  |         62973             2150            65123
Total   |       11         6        17  |        105990            15989           121979

Shared files are included ONCE only in the Summary number and byte totals.

#2 : physical.tot

Date-Time                 Summary |    Files  Projects     Total  |   Files-Bytes   Projects-Bytes      Total-Bytes

Tue Sep 28 10:37:05 2004  Active  |        8         4        12  |         43017            13839            56856  | j:\test\databases\minibase\data
Tue Sep 28 10:37:05 2004  Deleted |        3         2         5  |         62973             2150            65123  | j:\test\databases\minibase\data
Tue Sep 28 10:37:05 2004  Total   |       11         6        17  |        105990            15989           121979  | j:\test\databases\minibase\data

Info

ssxphysical may be run directly from the dos prompt.

More usually it will be run nightly by 'xphysical_day_gen.bat' which is called from 'audit.bat'.

Installation

The program is stand-alone and requires no configuration or support.

User's upgrading from tbe older 'ssphysical' tool should :

Backup the old ssaudit.bat

Download the latest sstools.zip and unpack into Utilities : ssaudit.bat, xphysical_gen_day.bat, ssxphysical.exe

Credits

Thanks to Joerg Seidel who pointed out that project or file names with an embedded tilde were listed only up to the tilde.

From version 2.02 and up project-file names with embedded tilde character are listed in full.

I recommend SourceSafe administrators not to allow tilde characters in project names, something which is completely discretionary.

File names with embedded tildes are also something to avoid - they may be names truncated to the DOS 8.3 format.
I recommend you to change them over to long names if possible.

Download

ssxphysical 2.08 (41 KB)