Architecting, installing and maintaining your SAS environment

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

Accepted Solution Solved
Reply
Contributor
Posts: 49
Accepted Solution

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

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.

 


Accepted Solutions
Solution
‎01-16-2018 04:33 PM
Super User
Posts: 9,925

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

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code

View solution in original post


All Replies
Super User
Posts: 9,925

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

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 49

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

Posted in reply to KurtBremser
Hi @KurtBremser,

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.
Super User
Posts: 9,925

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


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 ....?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 49

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

Posted in reply to KurtBremser
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.

Solution
‎01-16-2018 04:33 PM
Super User
Posts: 9,925

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

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 49

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

Posted in reply to KurtBremser
@KurtBremser,

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.
Super User
Posts: 3,866

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

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#p1hl3t66coao7bn18v...

Contributor
Posts: 49

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

@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?
Super User
Posts: 3,866

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

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.  

Super User
Posts: 9,925

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


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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super User
Posts: 9,925

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 11 replies
  • 270 views
  • 2 likes
  • 3 in conversation