Querying Labels from the Vault SQL Database

[BA]

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]

I'll check with our database specialist to see if this would be possible.

[drmccue]

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]

Dan,

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

Thanks,
Bong