2) Generate data and import details for CLIENT EVENTS

select ce.clientid, ce.duedate, ce.completedflag, ce.statusflag, u.userid as existinguserid, u.userlogin as existinguserlogin, unew.userid as newuserid, unew.userlogin as newuserlogin
, '--->' as 'fmclienteventsimport', ce.clienteventid, unew.useridfrom fmclientevents as ce
inner join gbusers as u on u.userid = ce.useridedit and u.userlogin = 'CURRENTUSER'
inner join gbusers as unew on unew.userlogin = 'NEWUSER'where ce.statusflag = 'active' and ce.completed_flag = 'no'
;

3) Generate data and import details for DRIVER EVENTS

select ce.driverid, ce.duedate, ce.completedflag, ce.statusflag, u.userid as existinguserid, u.userlogin as existinguserlogin, unew.userid as newuserid, unew.userlogin as newuserlogin
, '--->' as 'fmclienteventsimport', ce.drivereventid, unew.userid
from fmdriverevents as ce
inner join gbusers as u on u.userid = ce.useridedit and u.userlogin = 'CURRENTUSER'
inner join gbusers as unew on unew.userlogin = 'NEWUSER'where ce.statusflag = 'active' and ce.completed_flag = 'no'
;

### Scheduler Jobs'CURRENT_USER' - replace with the *user_login* of the exit user to target their records only.

1) Scheduler Jobs - Mail Queue

SELECT sj.schedulerjobid as jobid, sj.description, sj.sendmailflag, sj.statusflag
, sjr.name as recipientname, sjr.address as recipientaddress
,u.userlogin, u.statusflag AS userstatusflag
FROM gbschedulerjobs AS sj
INNER JOIN gbschedulerjobrecipients AS sjr ON sj.schedulerjobid = sjr.schedulerjobid and sjr.address NOT LIKE '%@catch-e.com.au'LEFT JOIN (select u.userid, u.userlogin, u.fullname, u.email, u.statusflagfrom gbusers as u
inner join gbroles as r on r.roleid = u.roleid and r.accesstype = 'internal'
) AS u ON u.email = sjr.address
WHERE sj.statusflag = 'active' and sj.sendmailflag = 'yes' and sjr.statusflag = 'active'

and u.userlogin = 'CURRENTUSER'

group by sj.schedulerjobid, sjr.recipientnoorder by u.statusflag desc, sjr.address, sjr.name, sj.schedulerjobid
;

2) Scheduler Jobs - Report Queue

SELECT sj.schedulerjobid as jobid, sj.description, sj.reportqueueflag, sj.statusflag
, sjr.name as recipientname, sjr.address as recipientaddress
, u.userlogin, u.statusflag AS userstatusflag
FROM gbschedulerjobs AS sj
INNER JOIN gbschedulerjobrecipients AS sjr ON sj.schedulerjobid = sjr.schedulerjobidINNER JOIN gbusers AS u ON u.userid = sjr.userid
WHERE sj.statusflag = 'active' and sj.reportqueueflag = 'yes' and sjr.statusflag = 'active'

and u.userlogin = 'CURRENTUSER'

group by sj.schedulerjobid, sjr.recipientnoorder by u.statusflag desc, sjr.address, sjr.name, sj.schedulerjobid
;

3) Scheduler Jobs - Sender

SELECT sj.schedulerjobid as jobid, sj.description, sj.sendmailflag, sj.statusflag
,u.userlogin, u.statusflag AS userstatusflag
FROM gbschedulerjobs AS sj
INNER JOIN gbusers AS u ON u.userid = sj.useridsender and u.status_flag != 'active'

WHERE u.userlogin = 'CURRENTUSER'

;
```

System Administration

| **** | | |
| :Send pending emails :Re-send a sent email :Edit an email :Delete pending emails :Restore deleted emails | | |
| **** | | |
| :Download a report from the report queue | | |
| **** | | |
| :Find a job :Run a job :Create an executeQuery job :Make a job active :Make a job inactive :Update a job run time :Update the output format of a query :UAT an executeQuery job Report Queue :Update a job to deliver reports to the report queue :Add or remove report queue recipients Email :Update a job to deliver reports via email :Add or remove email recipients | | |
| **** | | |
| : Create a new user : Update user KPIs : Issue a temporary password : Unlock a user's login : Apply button for MacLease : Apply button for Angle Auto Finance : Mapping Updates : Unenroll a user from 2 Factor Authentication : Suspend a user : User exit checklist | | |
| **** | | |
| :Update role KPIs :Update a role timeout | | |
| ** ** | | **** |
| :Edit API permissions :Create a user to access APIs | | |
| **** | | |
| :Whitelist an IP address | | |
| **** | | |
| :Data archiving :Deidentify Driver Data | | |