Export list of users and their sites

  • Resolved moose123

    (@moose123)


    9 years, 3 months ago

    Similar to how you can display all multisite users and their associated sites in Network Admin > Users, I’m looking for a way to export the same listing.

    I just need users’ email address and the sites that they’re have access to.

    I tried to piece together a SQL query to run from class-wp-users-list-table.php but I’m out of my depth in that area.

    Thanks for any assistance.

Viewing 3 replies - 1 through 3 (of 3 total)

  • What I do is this:
    Select the table which contains the email addresses and export it to a cvs file.
    Open the cvs file with Excel (or similar software) and edit out everything that I don’t need.

    Thread Starter moose123

    (@moose123)

    Thanks Cloudy. The problem is that the table that contains the email addresses does not also contain the site URLs that those users are associated with. What I want to do is send out a mail merge to all users that tells them (reminds them) of which sites they have access to. Trying to work on a query that will join the table with the email addresses and the one with the site URLs to tease out these two bits of information.

    Thread Starter moose123

    (@moose123)

    All set.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Export list of users and their sites’ is closed to new replies.