If you would like to get a list of users who had logins for the site, you can export all users on your site using a simple SQL query run through the SQL Console.
- Log in to a SuperUser Account.
- Go to Persona Bar > Settings > SQL Console
- Run the following SQL query, replacing the # with your desired PortalId:
SELECT users.userid ,users.username ,users.email ,roles.rolename FROM userportals INNER JOIN users ON userportals.userid = users.userid INNER JOIN userroles ON userportals.userid = userroles.userid INNER JOIN roles ON userroles.roleid = roles.roleid WHERE userportals.portalid = #
- When the results are displayed, you can press the Export button (see attached image) and select which type of file you want the results exported to.