Send synchronization editor log with a mail

Question

Hi, 
 I have a process with serveral steps. 
 One of this run Synchronization process with the process task Full projection. 
 Is possible to have a step after that tha send by email the log of the just finished Synchronization? 
 Where are stored synchronization editor log files? 
 
 Thanks 
 
 Mik

Markus Weiss-Ehlers · Accepted Answer

Hi Mik, 
 the logged Information of the synchronization runs are stored in the One Identity Manager database in the tables starting with DPRJournal ... 
 You can use the report DPR_Journal_Summary to export the complete log using the report component. 
 To generate the report the Parameter uidDPRJournal has to be set to the UID_DPRJournal of the synchronization journal you want to export. 
 But you have to fetch the UID_DPRJournal from the database using the Information about the start stratup configuration in your process chain.

Markus Weiss-Ehlers · Answer

As i said: 
 But you have to fetch the UID_DPRJournal from the database using the Information about the start stratup configuration in your process chain. 
 Means, use an Script or SQL Job after the sync step and before the Report step the fetches the UID_DPRJournal of the sync Journal by using a query similar to this 
 select TOP 1 UID_DPRJournal from DPRJournal where UID_DPRProjectionStartInfo = '$UID_DPRProjectionStartInfo$' order by DprJournal.CreationTime DESC 
 and return the UID_DPRJOunral as OUT-Parameter that you use in the Report step.