Enumerating the # and names of files in a VSS folder

A customer asked me this question via email today. Unable to remember how to do this (I've been off VSS for over a year), I pinged one of the VSS team's awesome developers, Alin, who promptly responded with this gem:

"You can use VSS Automation to find out the number of files in a folder and their names. Here is the function for doing that:

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        Dim db As New SourceSafeTypeLib.VSSDatabase

        db.Open("\\alinc00\vss$\", "Guest", "")

        Dim item As SourceSafeTypeLib.VSSItem

        item = db.VSSItem("$/")

        MsgBox("Total number of files and subfolders = " + item.Items.Count.ToString)

        Dim files As Integer

        Dim child As SourceSafeTypeLib.VSSItem

        files = 0

        For Each child In item.Items

            If child.Type = SourceSafeTypeLib.VSSItemType.VSSITEM_FILE Then

                files = files + 1

            End If

        Next

        MsgBox("Total number of files = " + files.ToString)

    End Sub

The command line SS.exe alone cannot be used, but combined with other utilities it can provide the answer.

ss dir $/ | findstr /R "^[^\$]" | wc –l

(ss dir lists the files and folders, findstr filters out files, wc counts the lines)

Subtract 1 from the answer to find the number of files (because the last line displayed by ss.exe contains the total number of files and folders)  or use something like

@for /F %I in ('ss dir $/ ^| findstr /R "^[^\$]" ^| wc -l') do set /a FILES=%I-1 > NUL

@echo There are %FILES% files in this folder

Comments

  • Anonymous
    October 20, 2005
    I am trying to calculate the size of folders placed under VSS.
    While I am able to calculate the folder sizes recursively for Directories & SubDirectories placed in local drive, if I try to use the same approach to calculate folder sizes in VSS I get the following error:

    Exception :An unhandled exception of type 'System.IO.DirectoryNotFoundException' occurred in mscorlib.dll
    Additional information: Could not find a part of the path "\SourceProject1Testing".


    Following is the code:

    Imports SourceSafeTypeLib
    Imports System.IO
    Form Load()
    Dim db As New SourceSafeTypeLib.VSSDatabase
    db.Open("\SourceProject1", "ani", "abc12$$")

    Dim item As SourceSafeTypeLib.VSSItem

    item = db.VSSItem("$/Testing")

    MsgBox("Total number of files and subfolders = " + item.Items.Count.ToString)



    Dim size As Long

    Dim d As New DirectoryInfo("\SourceProject1" & "" & item.Name)

    size = DirSize(d)



    End Sub


    Public Shared Function DirSize(ByVal d As DirectoryInfo) As Long
    Dim Size As Long = 0
    ' Add file sizes.
    Dim fis As FileInfo() = d.GetFiles() 'Throws Exception
    Dim fi As FileInfo
    For Each fi In fis
    Size += fi.Length
    Next fi
    ' Add subdirectory sizes.
    Dim dis As DirectoryInfo() = d.GetDirectories()
    Dim di As DirectoryInfo
    For Each di In dis
    Size += DirSize(di) 'To get direstories/files under current directory
    Next di
    Return Size
    End Function 'DirSize





    The VSS is on the local machine.Is there any API through which I can get the physical path to VSS database..so that I can access all the working folders under it, and thereby calulate the folder size.

    Your help in this regard would be highly appreciated.

    Thanking in advance.