Report on Folder Security

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

Moderator: SourceGear


Posts: 1
Joined: Thu Jun 20, 2019 2:56 pm
PostPosted: Thu Jun 20, 2019 3:17 pm
We are using Vault Standard 10.0

I have been pulling report of folder security by running the following query on database sgmaster:

SELECT b.name as [Group Name], b.description as [Group Description], c.authdomain + '\' + c.login as [Domain User], c.name as [Full Name], c.email, c.active as [User is Active]
FROM [sgmaster].[dbo].[groupmembers] a, [sgmaster].[dbo].[groups] b, [sgmaster].[dbo].[users] c
where a.groupid = b.groupid and a.userid = c.userid

This query serves the purpose when we only have one repository and global groups. However, we have created two more repositories, and started defining groups within these repositories. The query is no longer adequate as a result.

How can I generate a folder security report that contains multiple repositories and the non-global groups within those repositories?

Posts: 475
Joined: Thu Jan 20, 2005 1:47 pm
Location: SourceGear
PostPosted: Fri Jun 21, 2019 7:56 am
Hello,

The developer that I need to speak to for assistance in regards to your request is not in the office today. I will make this a priority for Monday morning. Thank you for your patience.

Thanks,

Tonya

Posts: 3599
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
PostPosted: Mon Jun 24, 2019 8:20 am
Take a look at the the rows in the view "[sgvault].[dbo].[userrepositoryaccessgroup]". This is a view which presents all users and their selected groups. The view has a repid (repository id) column which you can use for filtering / sorting. The "xid" (when not null) will be the "group" from [sgmaster].[dbo].[groups].

Hopefully using that view will allow you to create a query that meets your needs.

wtc301 wrote:We are using Vault Standard 10.0

I have been pulling report of folder security by running the following query on database sgmaster:

SELECT b.name as [Group Name], b.description as [Group Description], c.authdomain + '\' + c.login as [Domain User], c.name as [Full Name], c.email, c.active as [User is Active]
FROM [sgmaster].[dbo].[groupmembers] a, [sgmaster].[dbo].[groups] b, [sgmaster].[dbo].[users] c
where a.groupid = b.groupid and a.userid = c.userid

This query serves the purpose when we only have one repository and global groups. However, we have created two more repositories, and started defining groups within these repositories. The query is no longer adequate as a result.

How can I generate a folder security report that contains multiple repositories and the non-global groups within those repositories?
Jeff Clausius
SourceGear

Return to Support (Vault)

Who is online

Users browsing this forum: No registered users and 7 guests

cron