and more in a single search tool across platforms. Read the announcement here. |
05/04/2023 01:08 AM
Hi Team,
I created one analytics by "using SQL Query".
Query code
select u.username, u.employeetype, u.customproperty36, u.firstname, u.lastname , u.email , u.employeeid, u.customproperty7 as StartDate, u.CREATEDATE from users u where u.CREATEDATE > DATE_SUB(CURDATE(), INTERVAL 15 DAY) and u.statuskey = 1 and u.USERKEY not in ( select userkey from user_accounts where accountkey in (select accountkey from accounts where endpointkey = (select endpointkey from endpoints where endpointname='ActiveDirectory')))
But while trying to execute the analytic it's giving me below error.
How I can fix this.
05/04/2023 02:11 AM
You can try scheduling the analytics to a time when least number of jobs are running.
And if you are still facing the issue please raise an support ticket.
05/04/2023 04:08 AM
Column name should not end with date keyword change column alias