BUMP

No one can give me a tip?

Hi 24CG,

If you have host access, you can execute this SQL to obtain the data you're looking for:

SELECT PortalName, COUNT(*) AS UnauthorizedUsers
FROM Users
INNER JOIN UserPortals
 ON Users.UserId = UserPortals.UserId
INNER JOIN Portals
 ON UserPortals.PortalId = Portals.PortalId
WHERE Authorised = 0
GROUP BY PortalName

If you have a database table prefix, you may have to add this manually.  I know there is a token for this, but I have a pathological inability to remember what it is... {databasePrefix} or something.

Hope this helps!

Brandon