Support #6788
[SCP ID :##3471##] : BNM/Details Required for Audit Purposes.
Status: | Work Completed-End life cycle | Start date: | November 15, 2016 | |
---|---|---|---|---|
Priority: | Normal | Due 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.