How to send a periodic report to all manager to check for their externals collaborators

There are a few ways to do this.  But why not use UID_PersonHead and query the Person table that way?  And you'll have to query for the remaining information as well.  So it all comes down to writing the required SQL queries to gather the required info.  Then create a process to do the rest.  There are some existing processes that do something similar.  You just have to decide what would trigger this to be sent...

Trevor

There are a few ways to do this.  But why not use UID_PersonHead and query the Person table that way?  And you'll have to query for the remaining information as well.  So it all comes down to writing the required SQL queries to gather the required info.  Then create a process to do the rest.  There are some existing processes that do something similar.  You just have to decide what would trigger this to be sent...

Trevor

Good morning Trevor, thank you. Just to be sure, we are thinking about a VB script that finds the PersonHead that have external, and generate a loop that passes to the report process and sends emails to one uid_person at a time and triggers the process execution event. Is it right? Eventually, could you please give me an example? Really may thanks

The processes I'm referring to are those that send mail using SendRichMail.  Some of these exist for Attestation, for example.

But again, you need to determine what triggers the process to begin with, e.g. an update to the Person table.  Or perhaps a schedule that runs, something similar Attestations..

Trevor

thank you so much trevor!