ssusage

Purpose

This tool analyzes the SourceSafe transaction log.

For the twelve months starting from and including the specified month, the program totals the number of accesses made by each user in each month, and in total for the year.

The analysis highlights the range of users from power users, light users, to inactive users.

SourceSafe Version 6.0 is priced on a named user basis, at $375.00 per user, so this is valuable information when assessing the number of licenses required.

The report can be imported into Excel as a fixed field length text file for sorting and presentation.

SS

Tested with SourceSafe V5.0 V6.0.

OS

Windows NT/2K/XP Command line utility.

Usage

  ssusage -Ummccyy PathToVssDataDirectory PathToTransactionLogDirectory
            :
            :.. Start month and Year for analysis
  Example:
  ssusage -U012000 s:\vss\data "e:\program files\devstudio\vss"
  Output : ssusage.txt

Outputs

System Usage by User

  ssusage v1.5   SourceSafe Usage Analysis   Thu Mar 11 22:03:21 2001
  For the period starting : Feb 2000
  This analysis counts Checkins, File additions, deletions, purges etc.
  USER LOGIN ID        TOTAL : Feb-00  Mar-00  Apr-00  May-00  Jun-00  Jul-00  Aug-00  Sep-00  Oct-00  Nov-00  Dec-00  Jan-01
  Admin                    0 :      0       0       0       0       0       0       0       0       0       0       0       0
  GVadja                  11 :      0       0       0       0       0       0       6       0       5       0       0       0
  Zandara                  9 :      0       0       0       0       0       0       9       0       0       0       0       0
  Total Active Users      20 :      0       0       0       0       0       0       15      0       5       0       0       0
  Bbye                     2 :      0       0       2       0       0       0       0       0       0       0       0       0
  Lgone                    9 :      0       0       3       6       0       0       0       0       0       0       0       0
  Total Unlisted Users    11 :      0       0       5       6       0       0       0       0       0       0       0       0
  Total All Users         31 :      0       0       5       6       0       0      15       0       5       0       0       0
  Active Users:    3
  All Users   :    2
  Users prefixed [N] are not listed in the current um.dat file but accessed the system during the period.

The report is ouput to ssusage.txt

Installation

Copy the program into the directory where you want to run it. It's stand-alone and requires no configuration or support.

Credits

Thanks to Kenneth Sloan of Intergraph.com who reported a bug where the start month requested was less than the calender month.
This has been fixed in version 1.5.

Download

ssusage 1.5 (57 KB)