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.
This has been FABULOUS for me to get the information I need; however, I also need to export the information under Profile Settings --> Security , but don't know the table command.
Work fabulously - how do I get the security info? Thanks!
Please sign in to leave a comment.