@ProRPA
Possible Work flow could be :
1.Drag and drop Action for every step as mentioned below :
2.Connect to Blue prism SQL Server database with below Action
Action Name : Set Connection : ,
Business Object : Data- SQL Server ,Action : Set Connection
3.Once connected Get SQL Data of Stopped and Terminated Processes of last 1 week , with the Help of SQL Query , output as collection
Action Name : Get Collection :
Business Object : Data- SQL Server ,Action : Get SQL Server
4.Create Excel Instance :
Action Name : Create Instance ,
Business Object : MS Excel VBO ,Action : Create Instance
5.Create WorkBook
Action Name : Create WorkBook ,
Business Object : MS Excel VBO, Action : Create Workbook
6. Collection derived in step 3 write it into excel File
Action Name : Write Collection to workbok ,
Business Object : MS Excel VBO ,Action : Write Collection
7. Configure email to send this excel file
Action Name : Email Configuration ,
Business Object : Email-POP3/SMTP ,Action : Configure
7. Send Excel file as email Attachment
Action Name : Email Configuration ,
Business Object : Email-POP3/SMTP ,Action : Send Message.
Now publish this object and you will be able to see this inside process studio action .
Use it in new Process .
Save and publish this process so that this process can be visible in control room.
Now you can schedule this process for weekly frequency.
Hope this helps.