Saviynt Solutions

 SELECT     U.USERNAME,            U.FIRSTNAME,            U.LASTNAME,            U.EMAIL,            U.EMPLOYEETYPE,            U.CUSTOMPROPERTY9  AS 'JOINER DAT',            U.CUSTOMPROPERTY10 AS 'LOA START DAT',            U.CUSTOMPROPERTY8  AS 'MOVER DAT',            U.CUSTOMPROPERTY13 AS 'TERMINATION DAT',            U.CUSTOMPROPERTY17 AS 'CORPORATE ID',            E.DISPLAYNAME      AS 'APPLICATION NAME',            AT.ACCOUNTNAME,            AT.TASKKEY tasks,            AT.TASKDATE 'TASK CREATED ON',            CASE   ...

 SELECT EP.DISPLAYNAME AS APPLICATION, ACC.NAME AS 'ACCOUNT NAME', ACC.ACCOUNTTYPE AS 'ACCOUNT TYPE', CASE WHEN ACC.STATUS IS NULL THEN '' WHEN ACC.STATUS = 1 THEN 'Active' WHEN ACC.STATUS = 2 THEN 'Inactive' ELSE ACC.STATUS END 'ACCOUNT STATUS', EV.ENTITLEMENT_VALUE AS 'ACCESS', EV.DISPLAYNAME AS 'ACCESS DISPLAY NAME', ET.DISPLAYNAME AS 'ACCESS TYPE', CASE WHEN EV.STATUS IS NULL THEN '' WHEN EV.STATUS = 1 THEN 'Active' WHEN EV.STATUS = 2 THEN 'Inactive' WHEN EV.STATUS = 3 THEN 'Decomission Active' WHEN EV.STATUS = 4 THEN 'Decommission Inactive' ELSE EV.STATUS END 'ACCESS STATUS', U.USERNAME AS USERNAME, U.FIRSTNAME AS 'USER FIRSTNAME', U.LASTNAME AS 'USER LASTNAME', U.EMAIL AS 'USER EMAIL', U.EMPLOYEETYPE AS 'USER TYPE', CASE WHEN U.STATUSKEY IS NULL THEN 'Not Available' WHEN U.STATUSKEY = 0 THEN 'Inactive' WHEN U.STATU...

 SELECT     U.USERNAME,            U.FIRSTNAME,            U.LASTNAME,            U.EMAIL,            U.EMPLOYEETYPE,            U.CUSTOMPROPERTY9  AS 'JOINER DAT',            U.CUSTOMPROPERTY10 AS 'LOA START DAT',            U.CUSTOMPROPERTY8  AS 'MOVER DAT',            U.CUSTOMPROPERTY13 AS 'TERMINATION DAT',            U.CUSTOMPROPERTY17 AS 'CORPORATE ID',            E.DISPLAYNAME      AS 'APPLICATION NAME',            AT.ACCOUNTNAME,            AT.TASKKEY,            AT.TASKDATE 'TASK CREATED ON',            CASE    ...

 SELECT    U.USERNAME,           U.FIRSTNAME,           U.LASTNAME,           U.EMPLOYEETYPE,           U.CUSTOMPROPERTY9  AS 'JOINER DAT',           U.CUSTOMPROPERTY8  AS 'MOVER DAT',           U.CUSTOMPROPERTY10 AS 'LOA START DAT',           U.CUSTOMPROPERTY11 AS 'TRANSFER DAT',           U.CUSTOMPROPERTY12 AS 'TERMINATION EVENT DAT' ,           U.CUSTOMPROPERTY13 AS 'TERMINATION DAT',           U.CUSTOMPROPERTY17 AS 'Corporate ID',           U.OWNER            AS SUPERVISOR,           MANAGER.EMAIL      AS 'MANAGER EMAIL',           CASE                 ...

 SELECT    `REQUEST ID`,           `REQUEST TYPE`,           `REQUEST SUBMIT DATE`,           `REQUESTED FOR`,           `REQUESTEE NAME`,           `REQUESTED FOR EMAIL`,           IFNULL(           (                  SELECT ENDPOINTNAME                  FROM   ENDPOINTS E1                  WHERE  E1.ENDPOINTKEY = T2.ENDPOINT),ENDPOINTASCSV) AS APPLICATION,           `REQUESTED ENTITY`,           `REQUESTED ENTITY TYPE`,           SOD_EXCEPTION,           MITIGATINGCONTROL,           `RISK TYPE`,         ...

 Select UserData.GroupName, CASE WHEN (UserData.OldOwnerUsername!='' or UserData.OldOwnerUsername is not NULL) THEN UserData.OldOwnerUsername ELSE 'Not Present' END as 'OldOwnerUsername', CASE WHEN (NewAccountData.NewOwnerUserName!='' or NewAccountData.NewOwnerUserName is not NULL) THEN NewAccountData.NewOwnerUserName ELSE 'Not Present' END as 'NewOwnerUserName', CASE WHEN (OldAccountData.OldOwnerObjectID!='' or OldAccountData.OldOwnerObjectID is not NULL) THEN OldAccountData.OldOwnerObjectID ELSE 'Not Present' END  as 'OldOwnerObjectID', CASE WHEN (NewAccountData.NewOwnerObjectID!='' or NewAccountData.NewOwnerObjectID is not NULL) THEN NewAccountData.NewOwnerObjectID ELSE 'Not Present' END  as 'NewOwnerObjectID', UserData.GroupObjectID, UserData.EntitlementKey, UserData.EndpointName FROM (Select u1.username as 'OldOwnerUsername', u2.userkey as 'NewOwner_Userkey', u2.username...