Where did tblUsers go?

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

Where did tblUsers go?

Post by btd » Tue Feb 08, 2011 12:12 pm

I have a report (SQL code below) that now does not workbecuase we upgraded form v.316 to 5.1.

Can someone tell me what tblUsers got changed to?
Is there a web service that I can use that will retrieve the desired data (see SQL below).

Thanks

BTD


SELECT DISTINCT
tblusers.name, tblrepositories.name AS Repository, CASE WHEN tblsecurityassignments.securityrights = 1 OR
tblsecurityassignments.securityrights = 3 OR
tblsecurityassignments.securityrights = 7 THEN 'Y' ELSE 'N' END AS ReadRights, CASE WHEN tblsecurityassignments.securityrights = 3 OR
tblsecurityassignments.securityrights = 7 THEN 'Y' ELSE 'N' END AS CheckOutInRights,
CASE WHEN tblsecurityassignments.securityrights = 7 THEN 'Y' ELSE 'N' END AS AddRemoveDeleteRights
FROM tblsecurityassignments INNER JOIN
tblusers ON tblsecurityassignments.userid = tblusers.userid INNER JOIN
tblrepositories ON tblsecurityassignments.repid = tblrepositories.repid
WHERE tblusers.active = 1 AND (tblsecurityassignments.securityrights <> 0)
ORDER BY tblusers.name, Repository

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

Re: Where did tblUsers go?

Post by btd » Tue Feb 08, 2011 2:12 pm

I figured it out. tblUsers still exists. its in sgmaster. Once I figured this out the revised SQL was easy.

Post Reply