<div dir="ltr">I was able to piece together a SQL query:<div><br></div><div>
<p class=""><font face="courier new, monospace">SELECT u.username, u.first_name, </font><span style="font-family:'courier new',monospace">u.last_name, <a href="http://role.name">role.name</a> AS role </span></p><p class=""><span style="font-family:'courier new',monospace">FROM keycloak_role role </span></p><p class=""><span style="font-family:'courier new',monospace">INNER JOIN realm ON role.realm = <a href="http://realm.id">realm.id</a> </span></p><p class=""><span style="font-family:'courier new',monospace">INNER JOIN user_role_mapping rm ON <a href="http://role.id">role.id</a> = rm.role_id </span></p><p class=""><span style="font-family:'courier new',monospace">INNER JOIN user_entity u ON rm.user_id = <a href="http://u.id">u.id</a> </span></p><p class=""><span style="font-family:'courier new',monospace">WHERE <a href="http://realm.name">realm.name</a>=:1 AND <a href="http://role.name">role.name</a> = :2</span></p><p class="">It might be nice to do this in the web console though...</p></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Nov 18, 2014 at 12:28 PM, Alarik Myrin <span dir="ltr"><<a href="mailto:alarik@zwift.com" target="_blank">alarik@zwift.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Is there any easy way to see which users have been assigned a given role?</div>
</blockquote></div><br></div>