Generate list of users and groups from database in AppXtender

Generate list of users and groups from database in AppXtender

The following query will generate a list of all users and the groups they are part of in ApplicationXtender:

select a.usrnam, c.aliasname from ae_login a, ae_amap b, ae_als c 
where
a.usrid=b.usrid and
c.aliasid=b.aliasid
order by c.aliasname, a.usrnam

    • Related Articles

    • Modifying User Settings in AppXtender Web

      Changing User Settings To change the user's User Settings in ApplicationXtender Administrator:   1.  Go to Application Management 2. Expand the data source by clicking on it 3. Choose Web Access User Settings 3. Click the X next to Default user ...
    • How to add item to user defined list field in ApplicationXtender

      Here are the steps to add a new value to a user-defined list field in ApplicationXtender: 1. Open Application Administrator and log in as a user with Modify Application privileges 2. Go to Application Management and click on the Data Source 3. Click ...
    • Keyboard Shortcuts available in AppXtender Web Access

      Here is a list of the available Keyboard Shortcuts in AppXtender Web Access: Open shortcut help ? Print ctrl + alt + p Previous Document alt + p Next Document alt + n Next Page alt + pagedown Previous Page alt + pageup Next Page Version alt + ⇧ + ...
    • Fix Database Collision condition in AppXtender in version 8x or above

      ApplicationXtender Administrator web application does not include a feature to fix a database collision that was present in the Application Generator in earlier releases. The AE_SEQ table has to be modified directly to fix a database collision. ...
    • AppXtender Audit Trail Events

      Below is the full list of Audit Trail Event ID codes for table ae_audit Audit Event Id IDL Event Id Description 0 axAuditID_LOGIN Login in 1 axAuditID_LOGOUT Logout ApplicationXtender 2 axAuditID_APPCREATE Create an AX Application 3 ...