Querying Labels from the Vault SQL Database

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
BA
Posts: 32
Joined: Tue Mar 15, 2005 12:27 pm

Querying Labels from the Vault SQL Database

Post by BA » Wed Aug 05, 2009 12:18 pm

I have a query to select all labeled files from the Vault database as follows: SELECT * FROM tblfsobjectlabels WITH(NOLOCK) where label = 'PX-3045-1'. Now the files labeled with PX-3045-1 are shared in another hive within Vault.

The query above returns all files where the label was created (only).

I am looking for a SQL query that will returning not only a list of files where the label was created, but including all shared files and their paths in Vault.

Do you have a query like this available?

Thanks

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: Querying Labels from the Vault SQL Database

Post by lbauer » Thu Aug 06, 2009 2:48 pm

I'll check with our database specialist to see if this would be possible.
Linda Bauer
SourceGear
Technical Support Manager

drmccue
Posts: 24
Joined: Thu Jun 21, 2007 3:21 pm

Re: Querying Labels from the Vault SQL Database

Post by drmccue » Thu Aug 06, 2009 3:04 pm

BA,

In your example, were the files shared individually, or was an ancestor (parent, grandparent, etc.) folder shared, or is it a combination of the two (some of the labeled files were shared individually, some are shared as a result of an ancestor folder being shared)? Your proposed query could range from straightforward to very complex.

Thanks,
Dan McCue
SourceGear

BA
Posts: 32
Joined: Tue Mar 15, 2005 12:27 pm

Re: Querying Labels from the Vault SQL Database

Post by BA » Thu Sep 03, 2009 6:17 pm

Dan,

I believe most of the file shares are done at the (individual) file level.

Thanks,
Bong

Post Reply