Query All Repositories for file extensions

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

Moderator: SourceGear

Post Reply
btd
Posts: 324
Joined: Fri May 13, 2005 1:50 pm

Query All Repositories for file extensions

Post by btd » Wed Mar 20, 2013 8:31 am

As I am a Vault Administrator, can you send me a SQL script that will return the following
user name
repository name
folder name

WHERE Filename search wildcard *.dtsx (or any extension for that matter)


Note: I know we can do this within Vault but I'd like for this to iterate through ALL repositories

Thanks


BTD

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

Re: Query All Repositories for file extensions

Post by lbauer » Wed Mar 20, 2013 12:12 pm

can you send me a SQL script that will return the following
user name
repository name
folder name
I could use more information. Since you want the username, does this mean you want a list of all checked out files with a certain extension?
Linda Bauer
SourceGear
Technical Support Manager

btd
Posts: 324
Joined: Fri May 13, 2005 1:50 pm

Re: Query All Repositories for file extensions

Post by btd » Wed Mar 20, 2013 12:44 pm

No, I am not worried about if they are checked out or not.

I just want a list of files and what repository folder they reside. It would also be nice to know the last user who checked the files in.


Something like this. Note: I don't know your table definitions, so I just made these up.

select
Filename, repository name. folder name where file resides, last known user
from Vault
where file_extension = '*.dtsx'

Thanks

BTD

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

Re: Query All Repositories for file extensions

Post by lbauer » Wed Mar 20, 2013 3:27 pm

Contact me offline for queries that will provide the information you need.

Email me at support at sourcegear.com, ATTN: Linda.

Please include a link to this forum post.
Linda Bauer
SourceGear
Technical Support Manager

btd
Posts: 324
Joined: Fri May 13, 2005 1:50 pm

Re: Query All Repositories for file extensions

Post by btd » Thu Mar 21, 2013 10:51 am

Did you get my email I sent out at 7am EST today?

If Not, let me know and I can resend.

Thanks

Tom

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

Re: Query All Repositories for file extensions

Post by lbauer » Thu Mar 21, 2013 3:51 pm

Just sent you the query info. I had to test it first.
Linda Bauer
SourceGear
Technical Support Manager

Post Reply