Sending Notifications to Non-SBM Users.

[Mduduzi1]

I would like to know if there is a way to send notifications or broadcasts to non-SBM users. The requirement is to send automatic notification to the external client's email address which is stored in a sub-relational field. At this point we can only send it using the manual sending on SBM emails and we would like to automate it.

[d_berner]

We implemented this using a notification that would run an app script. Within the app script we send the email using native Windows commands

[Mduduzi1]

Thank you David, I'll try something like that.

[Mduduzi1]

Do you mind sharing that app script that you used for this solution?

[lmattie]

External or occasional users might help you get around this issue.

You can also just use AppScript to place a message in the TS_NOTIFICATIONMESSAGES table and let the notification server send the message for you.

[d_berner]

I am attaching a zip with our solution:
[list=1]

Screenshot of the notification confiiguration

appscript

powershell

html template used


Please note that I did not take the time to simplfy the code. Both appscript and posershell are more complex than need be since we wrote them to cover several different cases.

In any case this allows to send emails to someone who is not even known by serena or who does not have any license.

[David_J_Easter]

You also may want to check out the latest Virtual User Group webcast. It covered lots of tips and tricks about using notifications and e-mail responses.

http://www.serena.com/index.php/en/products/it-process-portal-management/sbm/user-group/

[lmattie]

I make my living doing this for people, but since this one is fairly simple I have attached it. :)

Cheers,
Lynn

[Mduduzi1]

Thank you for all your help.:)

[hcho]

Hello,

How would we execute this by adding a new entry in the TS_NOTIFICATIONMESSAGES table? I have added a new entry but am unsure what needs to be done to "trigger" the notification to be sent and leave the TS_NOTIFICATIONMESSAGES table.

[jimmywscott2]

I may be over simplifying the request, but if the email address in question is a single address, or perhaps a few, you may consider just creating a user (or users) and assign the email address to that user and subscribe it to the notification you created. The user does not need to have any access to projects per say so you shouldn't have any security/access concerns with that approach.

[Vickie Ortega]

This is great David! Thanks for sharing.