Upgrade to 5.1 Fallout tblUsers No Longer Exists

[btd]

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]

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.