Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Analytics not fetching records older than 3 months

Debankita
New Contributor III
New Contributor III

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?.

8 REPLIES 8

rushikeshvartak
All-Star
All-Star

Please share query/configuration


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

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 ('','');

Its seems you have enabled default archival of job logs hence you are not able to fetch logs. Validate jobs for archival


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Hi @rushikeshvartak ,

 

Can you please elaborate what changes do I need to do for getting the records

This details should exists under archive table

rushikeshvartak_0-1721674025148.png

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 ('','');

 

 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Is below job running in your system:

 

dgandhi_0-1721675866224.png

 

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.

kumarv
New Contributor III
New Contributor III

The Default Archival job is running fine.

hence old data is archived please use query share in previous response


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.