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