SELECT u.displayname AS 'Employee_Name', uh.updatedate AS 'Updated_ON', r.displayname AS 'Role_Owned', ev.entitlement_value AS 'Entitlement_Owned', CASE WHEN r.displayname IS NOT NULL THEN 'Role_Owner' ELSE 'Not_Role_Owner' END AS RoleOwnershipStatus, CASE WHEN ev.entitlement_value IS NOT NULL THEN 'Entitlement_Owner' ELSE 'Not_Entitlement_Owner' END AS EntitlementOwnershipStatus FROM usershistory uh JOIN users u ON u.userkey = uh.userkey LEFT JOIN role_owners ro ON u.userkey = ro.userkey LEFT JOIN roles r ON ro.rolekey = r.rolekey LEFT JOIN entitlement_owners eo ON u.userkey = eo.userkey LEFT JOIN entitlement_values ev ON eo.entitlement_valuekey = ev.entitlement_valuekey WHERE uh.ruleruns LIKE '%mover%' AND uh.updatedate >= CURDATE() - INTERVAL 30 DAY
tried almost everything, deleted, created new analytics, adjusted query etc, any insight or help appreciated.
