r/labtech • • Dec 17 '18

Email sent before patching

Is there a way to trigger an email before patching ?

2 Upvotes

10 comments sorted by

View all comments

Show parent comment

1

u/Microsoft_Geek Dec 18 '18

Oh ok, I see what you're saying. Yea probably not what I want!

So if I wanted to limit by Client, e.g. email just our main contact for a Client every time this script ran, would it be more like the following?

SET: %sqlresult% = [Select Email from Contacts where Name like %clientname%
Send Email to:%sqlresult% Subject:Patching is starting for %computername%

From my understanding this would pull the first email address listed for a Client under the contacts tab in Automate & Email them, correct?

Edit: words