BPM, Workflow, and Case

BPM, Workflow, and Case

Come for answers. Stay for best practices. All we’re missing is you.

 View Only
  • 1.  BAW Workflow - User Last Login Date Report

    Posted Fri December 15, 2023 10:19 AM

    Hello

    I'm here using BAW 22.x. It has some Workflow solutions (Case Manager/Builder) running on it. 

    I had been request to get a report of the "Last login date" of each user that access the BAW server or solution.

    Any idea where I can get that information from the datbase or any other source?

    Regards



    ------------------------------
    Martin Iturbide
    Consultant
    Next Step C.A.
    Quito
    ------------------------------


  • 2.  RE: BAW Workflow - User Last Login Date Report

    Posted Fri December 15, 2023 11:03 AM

    Hello Martin,

    I don't exactly remember but can you check the LSW_USR, LSW_USR_XREF and BPM_USR_RUNTIME_PROPS tables. I think one of these table contains the last login timestamp recorded.

    Thanks!



    ------------------------------
    Atanu Roy
    Lead Engineer
    London Stock Exchange Group
    ------------------------------



  • 3.  RE: BAW Workflow - User Last Login Date Report

    Posted Tue December 26, 2023 10:26 AM

    Thanks for the reply Atanu

    It was not exactly on those tables, but we found a Users table on the Target of the Case Manager solution that gave us that information. 

    Now I'm trying to find if there is a log to know the username and date of when a  user was assigned to an specific role in a Case Manager solution.


    Regards



    ------------------------------
    Martin Iturbide
    Consultant
    Next Step C.A.
    Quito
    ------------------------------