Upgrade to 5.1 Fallout tblUsers No Longer Exists

If you are having a problem using Vault, post a message here.
Post Reply
btd
Posts: 324
Joined: Fri May 13, 2005 1:50 pm

Upgrade to 5.1 Fallout tblUsers No Longer Exists

Post by btd » Tue Feb 08, 2011 11:46 am

We were on 3.16S and now we are on 5.1 which is good.

Our custom report that accessed SQL directly no longer works as the table tblUsers has been changed to something else.

Here is my querty that worked in 3.16.

Can you tell me what table replaced tblUsers? Or is there a web service call I can make which will prvide the data like before.

This is the SQL that worked prior to upgrade to 5.1.

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

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: Upgrade to 5.1 Fallout tblUsers No Longer Exists

Post by Beth » Tue Feb 08, 2011 2:27 pm

You will find tblusers in the sgmaster database now. Vault split into two databases.

You will also want to adjust your backups to now backup sgmaster as well.
Beth Kieler
SourceGear Technical Support

Post Reply