I'm looking for a way to run a dataview on a scheduled basis and have the results sent to several users in an email.
Greetings;
I run a scheduled Data Lake Query, format it in a Python Script, and then use the output of the Python Script to generate an email in IDM with an Excel attachment. Of course this is only valid for static SQL you can run in a Data Lake Query function.
I need a way to do this as well…send a mail from FactoryTrack Dataviews to Supervisors who only have Syteline Licenses.
It's possible to do in Syteline using AES.
Summary of steps
1.) Create a background task definition to reference the dataview
2.) create an event handler to execute the dataview (referencing the background task definiton)
3.) Create a TaskPostPerform event handler that will attach the report and send it an email
4.) setup an event trigger that will execute the event on a schedule.
Thanks kwballard. I will definitely test trhis out.
