Email notification for rejected Review Activities
I am wanting to set up an email subscription targeting when a RA status changes from "In Progress" to "Failed" - the reviewer rejected the request. I want the user to be informed their request was rejected and include the comments from the reviewer. Sounds simple, but having trouble getting the email of the SR Affected User. I have looked at doing this in the SCSM console creating both subscriptions and workflows.
Surely I don't need an Orchestrator Runbook? I mocked up what I might need in a runbook (still missing the AU email) and it just seems overkill for what I want.
Has anyone achieved this? Please can you share what you did?
Answers
Surely I don't need an Orchestrator Runbook?
AFAIK you need SCORCH or using SDK (https://social.technet.microsoft.com/wiki/contents/articles/13472.system-center-2012-service-manager-developer-s-survival-guide.aspx#Workflows). In my setup, I have to read e-mail address from AD user object, because AD-connector doesn't sync email address for user objects by default.
I guess this answers my question. I have a solution set up and working now, I just found it odd I couldn't do this in the scsm console!
I guess this answers my question. I have a solution set up and working now, I just found it odd I couldn't do this in the scsm console!
How did u solved it?
I followed a solution similar to this:
However, I needed to add a Get User stage to get the Affected User email address as you mentioned. And also some of my RA's are nested in SA's, so I had to split it in 2 directions to get the SA and if that fails because it is not in an SA it takes the route to get RA & SR relationship. Probably not the best solution or slickest of Runbooks... but it works.
I recommend u to use powershell API and write a script instead using to much of spicific runbook activities. At the end u can develope complex workflows quite faster, because u have full controll on error handling, better maintenance and u can use the whole programming toolbox for solving problems.
Thank you for your input. I did try getting the runbook to execute a .ps of course like others we have but with a number of relationships between the RA,SA & SR I couldn't quite figure this out so maybe something I will come back to when I have time.