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
Query All Repositories for file extensions
Moderator: SourceGear
Re: Query All Repositories for file extensions
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?can you send me a SQL script that will return the following
user name
repository name
folder name
Linda Bauer
SourceGear
Technical Support Manager
SourceGear
Technical Support Manager
Re: Query All Repositories for file extensions
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
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
Re: Query All Repositories for file extensions
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.
Email me at support at sourcegear.com, ATTN: Linda.
Please include a link to this forum post.
Linda Bauer
SourceGear
Technical Support Manager
SourceGear
Technical Support Manager
Re: Query All Repositories for file extensions
Did you get my email I sent out at 7am EST today?
If Not, let me know and I can resend.
Thanks
Tom
If Not, let me know and I can resend.
Thanks
Tom
Re: Query All Repositories for file extensions
Just sent you the query info. I had to test it first.
Linda Bauer
SourceGear
Technical Support Manager
SourceGear
Technical Support Manager