Support #13263
[SCP ID :##6464##] : Audit Findings - IBAM Users with NULL Staff ID
| Status: | Work Completed-End life cycle | Start date: | October 14, 2022 | ||
|---|---|---|---|---|---|
| Priority: | Normal | Due date: | |||
| Assignee: |  Zahir Abd Latif | % Done: | 90% | ||
| Category: | Others | Spent time: | - | ||
| Target version: | - |
Description
Hi,
Kindly attend below request:-
Request to extract IBAM user with null Staff ID in excel. Staff ID should be mandatory as per audit finding.
History
#1
Updated by Binti Marobi Athirah Umairah almost 2 years ago
- Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin
#2
Updated by Najmi Pasarudin almost 2 years ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- % Done changed from 0 to 90
Replied email:
Salam Azyan,
Please use this email for tracking purposes.
Please use the following script. The missing STAFF_ID may be caused by the migrated user from the legacy database.
select * from DBO.ADMIN_USER_PROFILE where STAFF_ID is null OR STAFF_ID = '';
#3
Updated by Najmi Pasarudin almost 2 years ago
- Assignee changed from Najmi Pasarudin to Binti Marobi Athirah Umairah
Requested script was emailed to Azyan. No fixes at BSNeBiz code.
#4
Updated by Najmi Pasarudin almost 2 years ago
- Status changed from Pending Customer Feedback to Pending Review
#5
Updated by Najmi Pasarudin almost 2 years ago
- Status changed from Pending Review to Pending Customer Feedback
#6
Updated by Binti Marobi Athirah Umairah almost 2 years ago
- Category set to Others
#7
Updated by Binti Marobi Athirah Umairah over 1 year ago
- Status changed from Pending Customer Feedback to Work Completed-End life cycle
- Assignee changed from Binti Marobi Athirah Umairah to Zahir Abd Latif