Vault 5.1.1: RepositoryPermission

[kha]

I am trying to find the repository creation date from the database back end, don't know if that is possible. If so, can you guide me which table I should look at?

I also looked at this dbo.tblrepositoryaccess and the column RepositoryPermissions has code N, U. Can you explain to me what each letter indicates?

[Beth]

The date for when a repository is created is not tracked. I can put in a feature request for this functionality if you'd like.

You could open a Vault GUI client and perform a show history on $. On the first window of the filter results window, select the option to "View folder history by version." Then click the Dates & Labels tab. Enter in a dates filter so that you are closer to the time period when the repository was created. Then click OK. When you get the results, you should be able to scroll to version 1 and see the date on which version 1 happened.

I will have to do some digging on the repository access. It's better to set repository access from the Vault admin web page rather than in the database. I can't guarantee that you won't get some unexpected results if you make a change there.

[Beth]

'N' is no access and 'U' is access (as in use).

Again, only make changes using the Vault admin web page.

[Beth]

If you'd like a SQL query for the same information send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread.