network users sort by role

  • Resolved majahjemmesider

    (@majahjemmesider)


    4 years ago

    Hi,

    I would like to hear if there are a possibility in the list of all subsites users on:
    /wp-admin/network/users.php to get listed/sorted according to the different user roles the users have.

    In the top, I can sort on Superadmins or a all users, but I would like to get an overview of all the administrators connected to all the sites in the multisite setup.

    Does anyone know a way to achieve this?

    Looking forward to your answers.

    Brgds,
    Maja

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator bcworkz

    (@bcworkz)

    Because the same user’s roles can vary from site to site, it’s not a simple list to compile because of how user roles are saved in the DB. I don’t think it’s possible using the filtering links at the top of the table. It would be possible to query for all distinct user IDs that have the administrator role by way of a raw mySQL query on the usermeta table where meta_key is like %capabilities and meta_value is like %administrator%.

    The query can be made and results presented from a separate custom admin page. I don’t know how one would get the default list table to behave as you want though.

    Thread Starter majahjemmesider

    (@majahjemmesider)

    Thank you @bcworkz – I guess I will have to make another page, showing the administrators of all sites. Do you by any chance know what the value and key would be, if I would like to get the following information on the administrators:

    Username
    Name
    Site dependency (Administrator on which site)
    Email

    If possibly with a link to the users.

    Brgds,
    Maja

    Thread Starter majahjemmesider

    (@majahjemmesider)

    I found my way, by making a Custom admin page as suggested by @bcworkz – Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘network users sort by role’ is closed to new replies.