topic Re: Send E-mail notification to SAS users whenever a new SAS Report object is made available to them in Administration and Deployment

Send E-mail notification to SAS users whenever a new SAS Report object is made available to them.

Alok_Pal — Tue, 02 Jan 2018 16:48:35 GMT

Hi Folks,

Happy New Year to all. I hope everyone had a great break.

So, here's my first post for this new year.

Our leadership and developers want us to be able to send an email notification to all the SAS users whenever there is a new report object made available to them. I have been researching around this requirement but didn't find any relevant documentation or post. Any help with this requirement would be greatly appreciated.

Thank you.

Re: Send E-mail notification to SAS users whenever a new SAS Report object is made available to them

Kurt_Bremser — Tue, 02 Jan 2018 20:36:27 GMT

Define "all users". How do you keep your list of users?

Re: Send E-mail notification to SAS users whenever a new SAS Report object is made available to them

Alok_Pal — Tue, 02 Jan 2018 20:41:09 GMT

Hi @Kurt_Bremser,

Thanks for your response. Well, we have a all the SAS report consumer users grouped in a user group. We want to send notification to all the users within that group.
Please let me know if any further information is required.

Thank you.

Re: Send E-mail notification to SAS users whenever a new SAS Report object is made available to them

Kurt_Bremser — Tue, 02 Jan 2018 22:57:00 GMT

@Alok_Pal wrote:

Well, we have a all the SAS report consumer users grouped in a user group.

In SAS metadata, in LDAP, in the system, in a SAS dataset ....?

Re: Send E-mail notification to SAS users whenever a new SAS Report object is made available to them

Alok_Pal — Wed, 03 Jan 2018 14:28:31 GMT

KurtBremser,

These are all external user accounts in LDAP, and their group is defined in SAS metadata. I hope that answers your question, let me know otherwise.

Re: Send E-mail notification to SAS users whenever a new SAS Report object is made available to them

Kurt_Bremser — Wed, 03 Jan 2018 14:40:31 GMT

See this note: http://support.sas.com/kb/30/682.html how to extract user data and their group relationships from the metadata repository.

A google search for "sas extract users from metadata" will reveal lots of other resources dealing with user metadata.

Unless you have stored your email adresses in SAS metadata, you will have to query your LDAP base to retrieve them there.

Re: Send E-mail notification to SAS users whenever a new SAS Report object is made available to them

Alok_Pal — Wed, 03 Jan 2018 17:29:33 GMT

@Kurt_Bremser,

Thanks and I appreciate that. I can extract the email addresses of the users but how will I automate the process of sending them notification about new report object being made available to them? Any thoughts?

Thank you.

Re: Send E-mail notification to SAS users whenever a new SAS Report object is made available to them

SASKiwi — Wed, 03 Jan 2018 19:44:13 GMT

You can send email from a SAS DATA step based on a SAS data set containing email addresses. This link should help explain:

http://support.sas.com/documentation/cdl/en/hostunx/63053/HTML/default/viewer.htm#p1hl3t66coao7bn18vrmhx2gte1q.htm

Re: Send E-mail notification to SAS users whenever a new SAS Report object is made available to them

Alok_Pal — Wed, 03 Jan 2018 20:24:04 GMT

@SASKiwi, it seems the link you've shared is not available anymore. I totally agree with the concept of sending the emails via SAS DATA step but my question is how would I trigger that emailing event. Is there's a way to trigger the event either via SAS program or SAS MC or maybe something else?

Re: Send E-mail notification to SAS users whenever a new SAS Report object is made available to them

SASKiwi — Wed, 03 Jan 2018 21:13:27 GMT

That link works fine for me. If not just google: SAS filename email statement 9.4. You could use the scheduler in SAS Management Console to run a job on a regular basis or just run it manually when the developer has published a new report.

Re: Send E-mail notification to SAS users whenever a new SAS Report object is made available to them

Kurt_Bremser — Thu, 04 Jan 2018 08:09:34 GMT

@Alok_Pal wrote:
@SASKiwi, it seems the link you've shared is not available anymore. I totally agree with the concept of sending the emails via SAS DATA step but my question is how would I trigger that emailing event. Is there's a way to trigger the event either via SAS program or SAS MC or maybe something else?

I've found that the new SAS documentation website seems to have issues with specific configurations of Firefox or PaleMoon. Try Chrome or another browser.

Re: Send E-mail notification to SAS users whenever a new SAS Report object is made available to them

Kurt_Bremser — Thu, 04 Jan 2018 08:12:42 GMT

Try this link instead:

http://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.2&docsetId=lestmtsglobal&docsetTarget=n0ig2krarrz6vtn1aw9zzvtez4qo.htm&locale=en