How can we identify the active sessions in app through Pyxis database ?

We want to identify all the orphan open session in application. How can we achieve it using Pyxis application database...

Have more questions? Submit a request

2 Comments

  • 0
    Avatar
    smilliken

    Hi Uday,

     

    If you query your dbo.tmpsys_UserSession table you can find all of the open sessions for each of your applications. If you order by LastActivityDTM you can see your oldest active sessions.

     

    Thanks,
    Scott

  • 0
    Avatar
    Uday Ganeshwadi

    Thanks Scott. But how it will tel me whether the session is active or orphan ?

Please sign in to leave a comment.
Powered by Zendesk