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
In the AMC, navigate to Security Administration > Resources.
Click the Variables tab.
Click the + (New) icon.
In the Name field, enter a name for your variable. For example,
In the Type list, select User attribute.
Select the appropriate realm from the list: it should point to the AD/LDAP store that you will query.
- In the Attribute list, select msExchHomeServerName.
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
Modify the query results by clicking the + (New) icon in the Editing options area:
In the Search field, enter:
/o=Your Company, Inc./ou=UK/cn=Configuration/cn=Servers/cn=
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
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
Was This Article Helpful?
Help us to improve our support portal