Use this dialog to define a dynamic address list. A dynamic address list is an SQL query designed to generate a list of e-mail addresses. They are primarily used to generate lists of recipients when an administrator sends a notification message.
Name
Type a descriptive name for the new address list, for example, 'warning message refusers'.
This name will be listed in the iConsole Address Selector dialog when an administrator sends an e-mail from the iConsole (for example, a notification message or reminder e-mail).
SQL Query
Type an SQL query to retrieve the users you want. These queries access the Wgn3User table in the CMS database for user e-mail addresses.
We recommend that you always use the Wgn_V_User_1 database view to access the Wgn3User database table; do not access the table directly. This ensures that dynamic address lists can always be generated, even if row level security is enabled.
For query guidelines and sample queries, contact CA Technical Support: http://ca.com/support.
Test
You can iteratively test your SQL query to ensure that it retrieves users as intended. Click Test to test your query. Any users found by the test are appended to the Address List dialog.
|
Copyright © 2012 CA.
All rights reserved.
|
|