• 0
Clint St. Romain

Exporting Users

Question

Would it be possible in the future to export users into a PDF or Excel spreadsheet. Also, when we sort the user table it doesn't seem to actually sort by any of the columns correctly. If we try to sort by 'Roles' it sorts by 'Usernames' first then 'Roles'. We would like the ability to be able to sort by the specific column we choose.

If we look at the properties of a group, you can't see who is attached to the groups either. We would like to be able to go into a group and see what users are in that group.

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

The new UI does this better.

Its sorting works correctly, so sorting by Roles (or other columns) in the users table does what you'd expect.

The users table also has a filter, so you can limit it to people in certain roles or statuses.

There is not a direct export to Excel - but you could make one from the getAccounts RPC call and a little scripting. What's the use case for that?

Share this post


Link to post
Share on other sites
  • 0

This would be very helpful for us. We have SOC II reporting we do annually and need to run reports for users and permission levels for all of our tool sets.

Right now we have to take screenshots to get the reporting necessary.

Share this post


Link to post
Share on other sites
  • 0

There's a built in report that will give you user to role mapping (could combine with a user report). You can output it to CSV. It's difficult to sort by role since the user to role relationship is one to many. One user can have multiple roles. If a user has both Administrator and ZeeBot roles, which one is used for sorting?

Also, I hate to be the guy to bring up the API, but...You could pretty easily script this to output a nice CSV, then you could build in some logic to sort by role the way you want. https://www.logicmonitor.com/swagger-ui-master/dist/#/Roles/getRoleList

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.