confluence user list question -2

[Anderson Hsu]

Dear partners, 

Would it be possible to find how many unknown user by space as shown as below ? Probably can we use sql to find them ? Thanks a lot.

[Brant Schroeder]

@Anderson Hsu I am assuming you have access to the SQL DB for your data center.  You should be able to use this to find them https://confluence.atlassian.com/confkb/how-to-display-the-user-profile-information-in-confluence-via-sql-query-792635895.html