Dynamic Query-Based Distribution Lists

There are three types of distribution lists created through dynamic query of the Banner database. This page explains how these lists are created, how users can request a list, and what lists are currently in use.

All email communication should follow the policies outlined in Op12.02-4 Email Communications and Email Communications Policy and Procedures

The list of currently used dynamic/query-based distribution lists. (MSU login required)

Dynamic Distribution Lists

What is it and how is membership determined: A Dynamic Distribution Lists is a special object in Active Directory/Office 365 that is generated anew each time an email is sent to it. There is an Active Directory query that runs in the background whenever the list receives an email that looks for certain attributes like “title”, “location”, or a custom attribute from Banner, such as on which campus a person is located, or if they are faculty, staff, student, or any combination thereof. 

How can users request to have one created: Dynamic Distribution Lists are not created on request. These lists are usually just used for very large groups of people using attributes that don’t often change, such as whether someone is faculty or staff. 

Query-based Distribution Lists

What is it and how is membership determined: Query-based Distribution Lists are updated periodically by a CAMS process that runs a Banner query to see if any changes are needed. The majority of our dynamic/query-based lists are this kind. When someone’s information in Banner is changed, it is updated by HR, then each night (or other time period if specified), CAMS pushes the resulting changes to the lists.

How can users request to have one created:  Send an email with a request for a permanent, query-based list, to EnterpriseSystems@Missouristate.edu specifying what you want queried for, and which mailboxes/users should be able to send to it. Operations and systems will coordinate with Management Information Systems for the proper queries, and then create the list and the proper configuration in CAMS.

Temporary Query-based Distribution Lists 

What is it and how is membership determined: ODL Lists are created from a Banner query by Management Information Systems which are not updated after they are created. They are created with an expiration date after which they are deleted by a CAMS process. Departments have these made for one-time mailings and then when the group expires, the list is removed.

How can users have one created: Send an email with a request for a temporary, query-based list, to EnterpriseSystems@Missouristate.edu specifying what attributes you want queried, and which mailboxes/users should be able to send to it. Operations and systems will coordinate with Management Information Systems for the proper queries, and then create the list and the proper configuration in CAMS.

 

Details

Article ID: 94418
Created
Fri 12/13/19 10:39 AM
Modified
Wed 8/23/23 7:26 PM