AnsweredAssumed Answered

Creating a report to display rejected and missing users

Question asked by Philip Martinez on Aug 17, 2016
Latest reply on Aug 17, 2016 by Philip Martinez



I'd like to create a report that will display the missing and rejected users after my IDCs run. You can see this information, by manually going to each IDC, clicking on Raw Data, and then selecting the Missing or Rejected tabs. I can solve for existing users who get rejected or go missing by querying the pv_users view. However, I want to also report on identities where the identity record was never created because of an issue with the source file. Is there any public view or table that allows me to query what the Raw Data view displays?


select * from pv_users

where deletion_date >= to_date ('08/15/2016', 'MM/DD/YYYY')