- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Define "all users". How do you keep your list of users?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@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 ....?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You can send email from a SAS DATA step based on a SAS data set containing email addresses. This link should help explain:
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Try this link instead: