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. ...
    • Thumbnails missing in ApplicationXtender WebAccess

      On the Web Access.Net IIS server, navigate to the following directory and perform the following steps. 1. Find file C:\inetpub\wwwroot\AppXtender\App\Controllers\thumbnail.js and copy to another directory as a backup, leaving the original present. 2. ...