Message Email Extract

The Yale Messaging service needs a list of users in the ITIL group. They intend to pull this using web services, so a view was created (called email) and an URL constructed:

https://yaledevelopment.service-now.com/sys_user_grmember_list.do?CSV&sysparm_query=group%3D43c17e2a0164244094adf4b82250a69f%5Euser.email!%3DNULL&sysparm_view=email

...this provides one email per line (with a single header row) for everyone in the ITIL group, and strips out (empty) records. Ultimately they would use a prod url.