No Users Showing For System Permissions – OnSemble Support Center

Bug has been reintroduced into System Permissions that if there is a deleted user in system permissions, no users show

This Script will find the deleted users: (Must be run from Assignments table in System Permissions DB)

SELECT *
FROM Assignments
WHERE (AssignedFor NOT IN
 (SELECT UserID
 FROM Production_Portal_PortalFx.dbo.PWUser))

Then

DELETE
FROM Assignments
WHERE (AssignedFor NOT IN
 (SELECT UserID
 FROM Production_Portal_PortalFx.dbo.PWUser))

Then run this one on the Requests table in System Permissions

SELECT *
FROM Requests
WHERE (UserID NOT IN
 (SELECT UserID
 FROM Production_Portal_PortalFx.dbo.PWUser))

Then

DELETE
FROM Requests
WHERE (UserID NOT IN
 (SELECT UserID
 FROM Production_Portal_PortalFx.dbo.PWUser))

Our Support Site Is Moving!