10/10/2022 11:05 AM
We found an issue in Analytics, when we are trying to run the reports in DRY Run we can see "records found" if we try to run the Reports in RUN Now "No record found"
Attaching the screen shot for reference.
10/10/2022 11:49 AM
10/10/2022 12:21 PM
Please find the attached query.
SELECT USERNAME as 'Saviynt Username', case when customproperty3 ='89' then 'AITS' when customproperty3='65' then 'AMS' end AS 'BU in Saviynt',FIRSTNAME,LASTNAME,EMPLOYEETYPE,CASE WHEN STATUSKEY=1 then 'Active' else 'Inactive' end as 'Saviynt Identity Status',STARTDATE as 'Contract Start Date',ENDDATE as 'Contract End Date',CUSTOMPROPERTY4 AS 'MANAGER EMPLOYEE ID' FROM USERS WHERE (DATEDIFF(CURDATE(), DATE(CREATEDATE)) < 30 AND DATEDIFF(CURDATE(), DATE(CREATEDATE)) > 0 OR CURDATE()=DATE(CREATEDATE) OR CREATEDATE IS NULL) AND STATUSKEY=1 AND customproperty3 in ('65','89') AND (CUSTOMPROPERTY6 IS NULL AND CUSTOMPROPERTY36 IS NULL)
10/10/2022 07:31 PM
10/10/2022 11:14 PM
Okay, but not only one reports most of the reports are behaving same before these reports are running correctly.
10/11/2022 04:09 AM
10/12/2022 04:45 AM
10/12/2022 05:20 AM
Does Elastic Server is running ?
Also please point to log time from above file.