Cyril_Delplanque_2297

Audit - user request

Discussion created by Cyril_Delplanque_2297 on Jul 22, 2016
Latest reply on May 31, 2017 by Cyril_Delplanque_2297
Hello,

in the case of an audit, those requests could be usefull.

  • Account idle
select USR_FIRSTNAME, USR_LASTNAME
from USR
where USR_ACTIVE=0;
  • List of user accounts (Name and Firstname) with creation date and last session date
select USR_FIRSTNAME, USR_LASTNAME, USR_LastSession,OH_CrDate, USR_LastSession from USR order by USR_LastSession Asc
from USR,OH
where OH_Idnr = USR_OH_Idnr;

Is there another request you used during your audit ?

Cyril

Outcomes