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
    Uday Ganeshwadi

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

  • 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

Please sign in to leave a comment.
Powered by Zendesk