List of solutions

[CityOfOrlando]

Can someone provide me with a SQL statement to retrieve a list of all the solutions in SourceGear vault?

[Beth]

Do you mean a list of the VS solution files?
Or list of project files?
Or list of folders?

I want to make sure we are both thinking the same thing.

[CityOfOrlando]

Solution files or Project Files. Actually, it would be nice to know how to query for any specific file type. Right now, I need to report to management how many projects are in SourceGear.

[jclausius]

There is no real tree on the Vault server so a query is not really practical.

The easiest way to get this would be through the Vault client. Have you tried a filename search within the Vault client for *.sln, *.vbproj, or *.csproj? You can find this functionality on the Vault GUI Client's Search tab.

[CityOfOrlando]

That works, however I have to go into each repository individually and then tally the results myself.

Slightly off topic, I can find everything checked out across all repositories by using the following:

SELECT * FROM sgvault.dbo.tblcheckoutlistitems WHERE colistid In
(SELECT currentcolistid FROM sgvault.dbo.tblrepositories)

I thought maybe someone might be able to point me in the direction of finding all files of a type across all repositories.

[jclausius]

I didn't think about the checkout list.

This is not really practical, and would be more of a pain than searching from the client, but if you checked out all project files across all repositories, and then query the checkout list table that would be one way to do it from a SQL point of view.

[jclausius]

Another option:

You could use a cursor that retrieves every repository's id. Then using the repid and the SQL code from this post -

http://support.sourcegear.com/viewtopic ... c&start=30

build a tree and place it into a temp table. Then from the temp table query for the files you are looking for.