• State Suggested Answer
  • Replies 8 replies
  • Answers 1 answer
  • Subscribers 96 subscribers
  • Views 1957 views
  • Users 0 members are here
Options
Related

Regarding End time of the AD recon

pooja mulajkar
over 3 years ago

Hello All,

I am trying to fetch the end time for AD recon but in job history table but not able to do it as not getting correct information regarding it.

I have tried adding column in Jobqueue also but our project we don't have "Completed"  column .

So please help me as soon as possible as its very critical for our project

Parents
  • 0 over 3 years ago

    Hi Markus ,

    We are using 8.1.4 version of the One Identity Manager and when I am trying to fetch data for today's date .

    For Example : If I have mentioned the filter in Object Browser as Xdateinserted as today's result then its showing 0 jobs even if there were multiple jobs in the Jobqueue .

    I am not able to search the AD recon jobs with the task name as there are multiple process in the job history but not able to figure out which is the AD recon process .

  • 0 over 3 years ago in reply to pooja mulajkar

    Try something like this to analyze the JobHistory,

    select ad.ADSDomainName, q.StartAt, q.EndedAt, q.WasError, q.ErrorMessages, q.JobChainName, q.ComponentAssembly, q.TaskName, q.UID_Tree
from jobhistory q
join DPRProjectionStartInfo dsi on q.BasisObjectKey = dsi.XObjectKey and q.TaskName = 'FullProjection'
Join DPRRootObjConnectionInfo dci on dsi.UID_DPRRootObjConnectionInfo = dci.UID_DPRRootObjConnectionInfo
Join ADSDomain ad on dci.ObjectKeyRoot = ad.XObjectKey
where
q.jobchainname = 'DPR_DPRProjectionStartInfo_Run_Synchronization'
order by ad.ADSDomainName, q.StartAt, q.UID_Tree

Reply Children
No Data