Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/22/2024 10:15 AM
Hi Team,
We are not able to fetch data through analytics control which are prior to 3 months even when we are hardcoding the time frame in the query. Is it a Saviynt limitation or a bug?.
07/22/2024 10:17 AM
Please share query/configuration
07/22/2024 10:26 AM
Hi @rushikeshvartak ,
The analytics control is for capturing the jobs which failed in last few months:
select e.triggername as 'Job Name',e.jobstartdate,e.jobenddate,i.logdataasxml as 'Logs captured',e.SAVRESPONSE as 'Error message' from ecmimportjob e,importlog i where SAVRESPONSE != 'Success' and e.jobid=i.jobid and Substring(e.jobstartdate,1,10) >= "2024-01-01" and Substring(e.jobstartdate,1,10) <= "2024-07-12" and e.triggername in ('','');
07/22/2024 10:34 AM
Its seems you have enabled default archival of job logs hence you are not able to fetch logs. Validate jobs for archival
07/22/2024 11:15 AM
07/22/2024 11:23 AM - edited 07/22/2024 11:47 AM
This details should exists under archive table
select e.jobname as 'Job Name',e.jobstartdate,e.jobenddate,i.logdataasxml as 'Logs captured',e.SAVRESPONSE as 'Error message' from ecmimportjob_Arch e,importlog_arch i where SAVRESPONSE != 'Success' and e.jobid=i.jobid and Substring(e.jobstartdate,1,10) >= "2024-01-01" and Substring(e.jobstartdate,1,10) <= "2024-07-12" and e.jobname in ('','');
07/22/2024 12:17 PM
Is below job running in your system:
Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.
07/31/2024 10:32 AM
The Default Archival job is running fine.
07/31/2024 11:34 AM
hence old data is archived please use query share in previous response