Secure Mobile Access 12.4 Administration Guide

Modifying Query Results

You can create a variable by querying an external AD/LDAP store for a specific attribute or set of attributes. To make the query results more useful, you can automatically extract data from them: after the query is sent and the full variable string has been determined, you can perform search and replace operations on its value.

For example, let’s say you have a company with offices in multiple locations, and each office uses a different Exchange server for email. Using some editing options, you can define a single variable that represents both Exchange servers, regardless of location.

To define a variable by automatically editing the results of a query

  1. In the AMC, navigate to Security Administration > Resources.

  2. Click the Variables tab.

  3. Click the + (New) icon.

  4. In the Name field, enter a name for your variable. For example, Exchange_server.

  5. In the Type list, select User attribute.

  6. Select the appropriate realm from the list: it should point to the AD/LDAP store that you will query.

  7. In the Attribute list, select msExchHomeServerName.
  8. Query the directory server for two different employees—for example, one at headquarters in London, and one in California—by entering the user name and clicking Test for each one. In this example the only difference is in the server name at the end of the resulting strings:

    /o=Your Company, Inc./ou=UK/cn=Configuration/cn=Servers/cn=LN0EXL09

    /o=Your Company, Inc./ou=UK/cn=Configuration/cn=Servers/cn=CA0EXV08

  9. Modify the query results by clicking the + (New) icon in the Editing options area:

    1. In the Search field, enter:

      /o=Your Company, Inc./ou=UK/cn=Configuration/cn=Servers/cn=

    2. Leave the Replace field empty, and then click OK.

For an employee in the London office or one in California, the variable named Exchange_server will contain the appropriate name, either LN0EXL09 or CA0EXV08, depending on the user.

Using the same query, you can create an additional variable that indicates where an employee is based. For example, create a new variable named Location and replace the name of each directory server with its location.

The Location variable will resolve to London or California, depending on the user. For example, when you enter a London employee’s name in the User field and click Test, you’ll see the following results:

Was This Article Helpful?

Help us to improve our support portal

Techdocs Article Helpful form

  • Hidden
  • Hidden

Techdocs Article NOT Helpful form

  • Still can't find what you're looking for? Try our knowledge base or ask our community for more help.
  • Hidden
  • Hidden