Search found 59 matches

by tjruska
Tue Mar 27, 2012 11:39 am
Forum: Support (Vault)
Topic: Admin rights does not allow one to edit comments?
Replies: 1
Views: 1273

Admin rights does not allow one to edit comments?

We had a situation in where a developer accidentally checked in code and used quotes in the comments. While this doesn't case an issue with Vault, it caused fits with CCNet. So when I tried to edit the other person's comments to correct it (I am the Admin) imagine my surprise when I couldn't! Is thi...
by tjruska
Wed Mar 02, 2011 10:13 am
Forum: Support (Vault)
Topic: Turning off SQL 2000 compatibility mode in SQL 2005
Replies: 1
Views: 1374

Turning off SQL 2000 compatibility mode in SQL 2005

Our DBA is asking me this question: "We have an SGVault and sgmaster databases in SQL 2000 compatibility mode on a SQL 2005 instance. We would like to switch the databases to 2005 mode - are there any special considerations to undertake prior to switching?" They want to ensure this is supported, tha...
by tjruska
Mon Jul 12, 2010 5:55 am
Forum: Support (Vault)
Topic: Report to show id's that have no access?
Replies: 1
Views: 1034

Report to show id's that have no access?

I am trying to free up some licenses by identifying any id that has no access to any repository at all and thus make them inactive. Is there any easier way (outside of manually checking each id's access in Vault) or SQL query available that would provide this? We are on Version 4.1.4.18402. Thanks, ...
by tjruska
Mon Jun 14, 2010 9:40 am
Forum: Support (Vault)
Topic: Vault security power tool for v4.x?
Replies: 1
Views: 1150

Vault security power tool for v4.x?

Is there any possibility that the power tool that was written for v5 of Vault has a version that works on v4? We won't be upgrading to v5 soon (to my dismay) and we have been doing audit reports manually via SQL, Excel, etc. which I don't believe are 100% correct. I would rather have something direc...
by tjruska
Tue Mar 09, 2010 7:11 am
Forum: Support (Vault)
Topic: Anyway to get Data directly from db
Replies: 10
Views: 3243

Re: Anyway to get Data directly from db

Fair enough. Here is the SQL that works for version 4.1.4 with no guarantees but provided to the community as a courtesy and a guide. Fire up your favorite SQL tool and run the attached SQL. It only reports user and repository access with access rights. I didn't drill down to folder level as our aud...
by tjruska
Fri Mar 05, 2010 6:51 am
Forum: Support (Vault)
Topic: Anyway to get Data directly from db
Replies: 10
Views: 3243

Re: Anyway to get Data directly from db

I also have had this need previously and couldn't wait. So I have developed some SQL that provides this information for v4.1.4. However, I will wait for permission to post it from either Beth or Jeremy as I don't want to violate anything or get them mad in case I need help from them in the future :w...
by tjruska
Tue Jan 05, 2010 6:30 am
Forum: Support (Vault)
Topic: VaultAppPool : Memory leak ?
Replies: 7
Views: 2075

Re: VaultAppPool : Memory leak ?

I have our vault app pool set to recycle every day at 4am. This has no adverse effect and in doing this I have noticed that I haven't had to manually do an iisreset in months. The load on our vault server is approximately 250 developers at any given time and six CCNet build servers constantly doing ...
by tjruska
Fri Dec 11, 2009 8:48 pm
Forum: Support (Vault)
Topic: Error message in log - Failed to bubble folder name?
Replies: 7
Views: 3386

Re: Error message in log - Failed to bubble folder name?

Since the iisreset seemed to resolve the issue I think there was some sort of Vault inconsistency rather then a database inconsistency :)
by tjruska
Fri Dec 11, 2009 8:16 am
Forum: Support (Vault)
Topic: Error message in log - Failed to bubble folder name?
Replies: 7
Views: 3386

Error message in log - Failed to bubble folder name?

We have begun seeing this error on our production Vault server and it was causing numerous developers issues. I did an iisreset and things cleared up. I am trying to understand the cause/nature of this error as I have never seen this before. Is it an artifact of network connectivity, SQL issue, Vaul...
by tjruska
Mon Oct 19, 2009 1:18 pm
Forum: Support (Vault)
Topic: Global search
Replies: 3
Views: 1323

Re: Global search

I am guessing I will be dusting off my coding skills (or lack of) and using the Vault 4.1.4 client API's! Any code snippets out there that I could leverage to show how to connect, traverse, etc?

Thanks, Tom
by tjruska
Mon Oct 19, 2009 9:41 am
Forum: Support (Vault)
Topic: Global search
Replies: 3
Views: 1323

Global search

We are on v4.1.4 and I already know that there isn't a global search feature available. However I was wondering what there is (API) or some sample code that someone has written or the actual Vault development team has i.e., powertoy, to do this? Our database has over 100 repositories and I need to i...
by tjruska
Wed Jul 29, 2009 5:46 am
Forum: Support (Vault)
Topic: Help on user repository access on upgrade
Replies: 5
Views: 1331

Re: Help on user repository access on upgrade

Great. i did find that under "Repository Access - Default Repository Settings"-->"Repository Default"-->"Default rights to the repository for all users", i f set it to No Access and hit the "Apply to other Repositories" did the trick. Please confirm that this is the correct procedure to reset all ex...
by tjruska
Tue Jul 28, 2009 5:54 am
Forum: Support (Vault)
Topic: Help on user repository access on upgrade
Replies: 5
Views: 1331

Re: Help on user repository access on upgrade

The "Default rights to the repository for all users" is set to "Access". I guess it should be "No Access"? "Folder Security was not enabled either. So I would need to ensure that the "Default rights to the repository for all users" is set to "No Access" for all existing repositories and that "Folder...
by tjruska
Mon Jul 27, 2009 1:22 pm
Forum: Support (Vault)
Topic: Help on user repository access on upgrade
Replies: 5
Views: 1331

Help on user repository access on upgrade

I just converted in a non-prod environment from version 3.5.3 to 4.1.4. All seems well until I started looking at how user security will work and noticed something that I need help on. We have build user accounts that have access to one repository for the purposes of running CCNet. So when I use tha...
by tjruska
Thu Jul 23, 2009 5:35 am
Forum: Support (Vault)
Topic: Vault Client for 2 versions of Vault on same PC?
Replies: 3
Views: 1249

Re: Vault Client for 2 versions of Vault on same PC?

Thanks for the heads up! So going forwards, is using the Enhanced Client the preferred or recommended way to use with VS 2008? Or is it a matter or personal preference? If so, that would dictate our testing approach to limit it to those developers with access to multiple machines on their desks. One...