ssphysical

Purpose

ssphysical is replaced by ssxphysical which is simpler to use and provides enhanced reporting capabilities.

This page has been left as a reference for users who have not yet downloaded the latest sstools.zip distribution and upgraded to the new tool.

Microsoft's ss physical command-line command generates a list of active projects or files for all or selected projects in the database, showing the physical log file names for each project or file.

The format of this report is a mess.

Ssphysical produces a easy to read list, with one line per project or file, the type of the file identified, and the project/file path fully expanded. The information is in columns so it can easily be sorted.

You can request an additional list of just projects only with file counts for each project.

Ssphysical appends a date-time stamped record with active project and file counts to a 'physical.tot' file which is useful for tracking database growth.

SS

Tested with SourceSafe V5.0 V6.0.

OS

Windows NT/2K/XP Command line utility.

Usage

First execute the native Microsoft command line command to generate physical.txt:

ss physical $/ -r -ophysical.txt -i-

Then the ssphysical tool:

ssphysical v1.7 syntax
ssphysical

Outputs

ssphysical.Sat sample:

SourceSafe Physical to Logical file name concordance   Sat Mar 03 11:32:17 2001
T Physical   Logical Name
P  aaaaaaaa   $/
P  AGFJAAAA   $/Access/Docs/amp.txt
P  XQLJAAAA   $/Bajor
etc
P  WPJKAAAA   $/Test
F  MBMKAAAA   $/Test/alpha.txt
P  ACMKAAAA   $/Test/Project3
P  QBMKAAAA   $/Zeta
Files:    12340  Projects:     3020   Total:     15360
[End Report]

Physical.tot sample:

Thu Mar 01 01:30:00 2001 Files:    12011  Projects:    2945   Total:    14956
Fri Mar 02 01:30:00 2001 Files:    12246  Projects:    2972   Total:    15218
Sat Mar 03 01:30:00 2001 Files:    12340  Projects:    3020   Total:    15360

Action

Ssphysical can be run stand-alone but you should normally set up to run it under the nightly audit.bat file

Installation

Copy the program into the directory where you want to run it. The path environment variable should include a path to the ...vss\win32 directory.

Download

ssphysical 1.7 (46 KB)