Project

General

Profile

Production Ticket(ST) #11705

NIBOU - checking all the active users for Nibou

Added by Rashdan Hussin 4 months ago. Updated 4 months ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Rashdan Hussin
Start date:
14/05/2024
Due date:
16/05/2024
% Done:

100%

Estimated time:
Spent time:
1.00 h
Job Remark:
Ticket Logged Date:
14/05/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
14/05/2024
SLA Delivery:
16/05/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
14/05/2024
Resolution:

1) Query all Nibou users.
2) Query users who have perform transaction.

Root cause: Client request.

Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:

None

Description

Dear Arif,

Following up on our previous discussion, could you please help by checking all the active users for Nibou since July of last year?

We require this information to provide an accurate renewal quote for their system this year.

Many thanks,

Best regards,
Louise Lim

History

#1 Updated by Rashdan Hussin 4 months ago

  • Status changed from Assigned To to Support In Progress

#2 Updated by Rashdan Hussin 4 months ago

  • Status changed from Support In Progress to Pending Client Verification
  • % Done changed from 0 to 90
  • Actual Initial Response set to 14/05/2024
  • Resolution updated (diff)

--mobile login
select distinct a.member_id, b.member_cd from sync_mobile_token a
inner join member b on a.member_id = b.member_id
where a.org_id = 'nibou' and a.created_date >= '2023-07-01 00:00:00.000'

--mobile activity
select distinct a.member_id, b.member_cd from sync_mobile_activity_log (nolock) a
inner join member b on a.member_id = b.member_id
where a.org_id = 'nibou' and a.created_date >= '2023-07-01 00:00:00.000' and a.action_type ='Upload'

--sales order
select distinct a.updated_by, b.member_cd from txn_sales_order_header a
inner join member b on a.updated_by = b.member_id
where a.org_id = 'nibou' and a.updated_date >= '2023-07-01 00:00:00.000'

--collection
select distinct a.updated_by, b.member_cd from txn_mobile_collection_header a
inner join member b on a.updated_by = b.member_id
where a.org_id = 'nibou' and a.updated_date >= '2023-07-01 00:00:00.000'

--goods return
select distinct a.updated_by, b.member_cd from txn_return_header a
inner join member b on a.updated_by = b.member_id
where a.org_id = 'nibou' and a.updated_date >= '2023-07-01 00:00:00.000'

select member_cd, status, * from member where org_id = 'nibou'

#3 Updated by Rashdan Hussin 4 months ago

  • Status changed from Pending Client Verification to Ticket Resolved
  • % Done changed from 90 to 100

Dear @Louise Lim,

Kindly refer below information as requested:

AIDAH

Mar-24

FOO

Feb-24

JUSTIN

Mar-24

NURAIN

Apr-24

ZHAO

Mar-24

Admin

Jul-23

Arif Ibrahim

Also available in: Atom PDF