Support #7029

[SCP ID :##3597##] : query admin log for update status non fin to fin from MSS

Added by Zahir Abd Latif over 7 years ago. Updated over 7 years ago.

Status:Closed - End of life cycleStart date:January 12, 2017
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:-Spent time:0.50 hour
Target version:-

Description

Hi,
Kindly attend below request:

please help to provide query admin log for update status non fin to fin from MSS

History

#1 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian over 7 years ago

  • Status changed from New - Begin Life Cycle to Development / Work In Progress
  • % Done changed from 0 to 100

Dear all,

As per my reply to bank:

Dear Pak Wahyu,

Below is suggested select query:

SELECT * FROM DBO.ADMIN_AUDIT_LOG where log_before_state like '%groupId=2%' and log_after_state like '%groupId=1%' and log_status = 1;

Result in SIT would be something like this:
Screen Shot 2017-01-12 at 18.06.36.png

Thank you.

#2 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian over 7 years ago

  • Status changed from Development / Work In Progress to Pending Customer Feedback
  • Assignee changed from Rayvandy Gabbytian to Zahir Abd Latif
  • % Done changed from 100 to 0

#3 Updated by Zahir Abd Latif over 7 years ago

  • Status changed from Pending Customer Feedback to Closed - End of life cycle
  • % Done changed from 0 to 100

Issue closed in SCP.

Also available in: Atom PDF