by Todd Galuska, eCapital Advisors
One request I often get from clients is to have email notifications for TI Processes so administrators are notified when an error occurs. With the introduction of PowerShell, email notifications can be completed with a minimal amount of time and effort. To setup email notifications on your TI Processes you will need the name of your SMTP Server and the ExecuteCommand function in TM1.
First verify the TM1 server can talk to the SMTP Server by pinging the SMTP Server from a PowerShell command line. If you do not receive packets from your SMTP server, work with your IT department to expose the SMTP server to your TM1 Server. Next make a policy change on the TM1 Server to change your execution policy to unrestricted.
Command Line Example of Policy Change
Lastly, in the Epilog tab of your TI Process use the ExecuteCommand function to run a powershell.exe –command SendMailMessage that will email the administrators of your TM1 model with any TI Process errors that occur.
TI Process Epilog Tab Including Command To Email Process Error
Two other considerations to keep in mind are the SMTP server name and the ExecuteCommand function wait parameter. Your SMTP Server cannot be the IP Address of the SMTP Server, it has to be the physical server name. Example: webmail.ecapitaladvisors.com, not 918.104.22.168. When you are running the ExecuteCommand in your TI Process make sure to have the wait parameter set to “0”. If you leave this set to “1” the email may not be sent or possibly sent much delayed with no attachment.