Support #6788

[SCP ID :##3471##] : BNM/Details Required for Audit Purposes.

Added by Zahir Abd Latif almost 8 years ago. Updated almost 8 years ago.

Status:Work Completed-End life cycleStart date:November 15, 2016
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

0%

Category:-Spent time:-
Target version:-

Description

Hi,
Kindly attend below request:

Do you know how to obtain last password changes date?

Existing SQL
select b.e_user_alias as "User ID",
b.e_user_name as "User Name",
decode(a.u_user_state, '0', 'Active', '1', 'Temporary Locked', '2', 'Locked', '3', 'Inactive', '4', 'Deleted', '5', 'New', '6', 'Disabled') as "status",
a.u_date_last_used as "Last Login Date",
a.u_date_created as "Creation Date",
decode(c.a_app_serv_id, '100', 'CAS Administration System', '101', 'eCustody', '102', 'TradeConnex', '103', 'CMS') as "Application"
from tb_am_user a, tb_am_user_ext b, tb_am_appserv c
where b.e_user_id = a.u_user_id and a.u_user_id = c.a_user_id and a_app_serv_id = '103' and b.e_company_id = 'BNM'

History

#1 Updated by Ong Wei Kuan almost 8 years ago

  • Status changed from New - Begin Life Cycle to Work Completed-End life cycle
  • Assignee changed from Ong Wei Kuan to Zahir Abd Latif

Case can be closed, last response on 25-11-2016.

Also available in: Atom PDF