Hi all,

  I am wanting to find out what users are in a specific role. Now I know I can just open that role up via Security Roles however this doesn't give me the information I need. This is what I need to do:

Search to find out what members are in the Guild Members group
Return the results with a list of users displaying the name they use to log on to the site with

Please can someone help me with this, I don't know if an SQL query could be written or if there is a module out there that can do this already (Preferable a free one as the site is a hobby)

Thanks in advance.

You can download DNN module that supports table joins from http://components.init.si , then go to the table settings and check import/export checkbox on the bottom. After that copy/paste settings below to import/export window and click import button and then update. After that you can browse/filter users and roles. You can also add other columns, tables, edit data etc.

Module is not free, but you can try it for month or two. If you don't want to pay for it, then download new version when trial period is over.

Hope this helps,

Primoz

Table settings for your situation:

<?xml version="1.0" encoding="utf-8"?>
<NewDataSet>
  <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
      <xs:complexType>
        <xs:choice minOccurs="0" maxOccurs="unbounded">
          <xs:element name="properties_live">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="name" type="xs:string" minOccurs="0" />
                <xs:element name="value" type="xs:string" minOccurs="0" />
              </xs:sequence>
            </xs:complexType>
          </xs:element>
          <xs:element name="properties">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="name" type="xs:string" minOccurs="0" />
                <xs:element name="value" type="xs:string" minOccurs="0" />
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:choice>
      </xs:complexType>
    </xs:element>
  </xs:schema>
  <properties_live>
    <name>gridView.recordcount</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>connectionType</name>
    <value>0</value>
  </properties_live>
  <properties_live>
    <name>connectionString</name>
    <value />
  </properties_live>
  <properties_live>
    <name>tablename</name>
    <value>UserRoles</value>
  </properties_live>
  <properties_live>
    <name>tableKeyColumn</name>
    <value>UserRoleID</value>
  </properties_live>
  <properties_live>
    <name>gridView.pagerecord</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridview.bulkimport</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridview.bulkexport</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridview.bulkdelete</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridview.editrecord</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridview.deleterecord</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridview.viewrecord</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridview.insertrecord</name>
    <value />
  </properties_live>
  <properties_live>
    <name>hidegridviewonedit</name>
    <value />
  </properties_live>
  <properties_live>
    <name>editbuttonsinlastcoulumns</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridedit.captionposition</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridEdit.TextboxWidth</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridEdit.redirectURL</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridEdit.isBinary</name>
    <value />
  </properties_live>
  <properties_live>
    <name>binaryData.fileSytemDBPath</name>
    <value />
  </properties_live>
  <properties_live>
    <name>networkCredential.userName</name>
    <value />
  </properties_live>
  <properties_live>
    <name>networkCredential.passWord</name>
    <value />
  </properties_live>
  <properties_live>
    <name>htmlHeadBlock</name>
    <value />
  </properties_live>
  <properties_live>
    <name>startupScriptBlock</name>
    <value />
  </properties_live>
  <properties_live>
    <name>onSubmitScriptBlock</name>
    <value />
  </properties_live>
  <properties_live>
    <name>sqldeveloperwindowcb</name>
    <value />
  </properties_live>
  <properties_live>
    <name>importexportcb</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.columnName</name>
    <value>UserID</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.caption</name>
    <value>User name</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.width</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.defaultContent</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.allowExport</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.allowFilter</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.allowSort</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.visible</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.isBoolean</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.isLink</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.isOther</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.isBinary</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.isJoin</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.isHtmlAttributes</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.navigateUrlTarget</name>
    <value>_blank</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.joinTableName</name>
    <value>Users</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.joinTableIdColumnName</name>
    <value>UserID</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.0.joinTableColumnName</name>
    <value>Username</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.columnName</name>
    <value>RoleID</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.caption</name>
    <value>Role name</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.width</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.defaultContent</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.allowExport</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.allowFilter</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.allowSort</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.visible</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.isBoolean</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.isLink</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.isOther</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.isBinary</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.isJoin</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.isHtmlAttributes</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.navigateUrlTarget</name>
    <value>_blank</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.joinTableName</name>
    <value>Roles</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.joinTableIdColumnName</name>
    <value>RoleID</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.1.joinTableColumnName</name>
    <value>RoleName</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.2.columnName</name>
    <value>RoleID</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.2.caption</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.2.width</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.2.defaultContent</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.2.allowExport</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.2.allowFilter</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.2.allowSort</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.2.visible</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.2.isBoolean</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.2.isLink</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.2.isOther</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.2.isBinary</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.2.isJoin</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.2.isHtmlAttributes</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.columnName</name>
    <value>UserID</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.caption</name>
    <value>UserID-Join</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.width</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.defaultContent</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.allowExport</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.allowFilter</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.allowSort</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.visible</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.isBoolean</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.isLink</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.isOther</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.isBinary</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.isJoin</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.isHtmlAttributes</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.navigateUrlTarget</name>
    <value>_blank</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.joinTableName</name>
    <value>Users</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.joinTableIdColumnName</name>
    <value>UserID</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.3.joinTableColumnName</name>
    <value>UserID</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.4.columnName</name>
    <value>UserID</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.4.caption</name>
    <value>UserID_direct</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.4.width</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.4.defaultContent</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.4.allowExport</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.4.allowFilter</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.4.allowSort</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.4.visible</name>
    <value>on</value>
  </properties_live>
  <properties_live>
    <name>gridViewColumn.4.isBoolean</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.4.isLink</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.4.isOther</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.4.isBinary</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.4.isJoin</name>
    <value />
  </properties_live>
  <properties_live>
    <name>gridViewColumn.4.isHtmlAttributes</name>
    <value />
  </properties_live>
  <properties>
    <name>gridView.recordcount</name>
    <value>on</value>
  </properties>
  <properties>
    <name>connectionType</name>
    <value>0</value>
  </properties>
  <properties>
    <name>connectionString</name>
    <value />
  </properties>
  <properties>
    <name>tablename</name>
    <value>UserRoles</value>
  </properties>
  <properties>
    <name>tableKeyColumn</name>
    <value>UserRoleID</value>
  </properties>
  <properties>
    <name>gridView.pagerecord</name>
    <value />
  </properties>
  <properties>
    <name>gridview.bulkimport</name>
    <value />
  </properties>
  <properties>
    <name>gridview.bulkexport</name>
    <value />
  </properties>
  <properties>
    <name>gridview.bulkdelete</name>
    <value />
  </properties>
  <properties>
    <name>gridview.editrecord</name>
    <value />
  </properties>
  <properties>
    <name>gridview.deleterecord</name>
    <value />
  </properties>
  <properties>
    <name>gridview.viewrecord</name>
    <value />
  </properties>
  <properties>
    <name>gridview.insertrecord</name>
    <value />
  </properties>
  <properties>
    <name>hidegridviewonedit</name>
    <value />
  </properties>
  <properties>
    <name>editbuttonsinlastcoulumns</name>
    <value />
  </properties>
  <properties>
    <name>gridedit.captionposition</name>
    <value />
  </properties>
  <properties>
    <name>gridEdit.TextboxWidth</name>
    <value />
  </properties>
  <properties>
    <name>gridEdit.redirectURL</name>
    <value />
  </properties>
  <properties>
    <name>gridEdit.isBinary</name>
    <value />
  </properties>
  <properties>
    <name>binaryData.fileSytemDBPath</name>
    <value />
  </properties>
  <properties>
    <name>networkCredential.userName</name>
    <value />
  </properties>
  <properties>
    <name>networkCredential.passWord</name>
    <value />
  </properties>
  <properties>
    <name>htmlHeadBlock</name>
    <value />
  </properties>
  <properties>
    <name>startupScriptBlock</name>
    <value />
  </properties>
  <properties>
    <name>onSubmitScriptBlock</name>
    <value />
  </properties>
  <properties>
    <name>sqldeveloperwindowcb</name>
    <value />
  </properties>
  <properties>
    <name>importexportcb</name>
    <value>on</value>
  </properties>
  <properties>
    <name>gridViewColumn.0.columnName</name>
    <value>UserID</value>
  </properties>
  <properties>
    <name>gridViewColumn.0.caption</name>
    <value>User name</value>
  </properties>
  <properties>
    <name>gridViewColumn.0.width</name>
    <value />
  </properties>
  <properties>
    <name>gridViewColumn.0.defaultContent</name>
    <value />
  </properties>
  <properties>
    <name>gridViewColumn.0.allowExport</name>
    <value>on</value>
  </properties>
  <properties>
    <name>gridViewColumn.0.allowFilter</name>
    <value>on</value>
  </properties>
  <properties>
    <name>gridViewColumn.0.allowSort</name>
    <value>on</value>
  </properties>
  <properties>
    <name>gridViewColumn.0.visible</name>
    <value>on</value>
  </properties>
  <properties>
    <name>gridViewColumn.0.isBoolean</name>
    <value />
  </properties>
  <properties>
    <name>gridViewColumn.0.isLink</name>
    <value />
  </properties>
  <properties>
    <name>gridViewColumn.0.isOther</name>
    <value />
  </properties>
  <properties>
    <name>gridViewColumn.0.isBinary</name>
    <value />
  </properties>
  <properties>
    <name>gridViewColumn.0.isJoin</name>
    <value>on</value>
  </properties>
  <properties>
    <name>gridViewColumn.0.isHtmlAttributes</name>
    <value />
  </properties>
  <properties>
    <name>gridViewColumn.0.navigateUrlTarget</name>
    <value>_blank</value>
  </properties>
  <properties>
    <name>gridViewColumn.0.joinTableName</name>
    <value>Users</value>
  </properties>
  <properties>
    <name>gridViewColumn.0.joinTableIdColumnName</name>
    <value>UserID</value>
  </properties>
  <properties>
    <name>gridViewColumn.0.joinTableColumnName</name>
    <value>Username</value>
  </properties>
  <properties>
    <name>gridViewColumn.1.columnName</name>
    <value>RoleID</value>
  </properties>
  <properties>
    <name>gridViewColumn.1.caption</name>
    <value>Role name</value>
  </properties>
  <properties>
    <name>gridViewColumn.1.width</name>
    <value />
  </properties>
  <properties>
    <name>gridViewColumn.1.defaultContent</name>
    <value />
  </properties>
  <properties>
    <name>gridViewColumn.1.allowExport</name>
    <value>on</value>
  </properties>
  <properties>
    <name>gridViewColumn.1.allowFilter</name>
    <value>on</value>
  </properties>
  <properties>
    <name>gridViewColumn.1.allowSort</name>
    <value>on</value>
  </properties>
  <properties>
    <name>gridViewColumn.1.visible</name>
    <value>on</value>
  </properties>
  <properties>
    <name>gridViewColumn.1.isBoolean</name>
    <value />
  </properties>
  <properties>
    <name>gridViewColumn.1.isLink</name>
    <value />
  </properties>
  <properties>
    <name>gridViewColumn.1.isOther</name>
    <value />
  </properties>
  <properties>
    <name>gridViewColumn.1.isBinary</name>
    <value />
  </properties>
  <properties>
    <name>gridViewColumn.1.isJoin</name>
    <value>on</value>
  </properties>
  <properties>
    <name>gridViewColumn.1.isHtmlAttributes</name>
    <value />
  </properties>
  <properties>
    <name>gridViewColumn.1.navigateUrlTarget</name>
    <value>_blank</value>
  </properties>
  <properties>
    <name>gridViewColumn.1.joinTableName</name>
    <value>Roles</value>
  </properties>
  <properties>
    <name>gridViewColumn.1.joinTableIdColumnName</name>
    <value>RoleID</value>
  </properties>
  <properties>
    <name>gridViewColumn.1.joinTableColumnName</name>
    <value>RoleName</value>
  </properties>
</NewDataSet>