web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / SysClientSession status
Microsoft Dynamics AX (Archived)

SysClientSession status

(0) ShareShare
ReportReport
Posted on by Community Member

Hello ,

 Can anyone tell me how is the value of status field in SysClientSession Table been  updated?

I didnt understand for how long it checks for idle time and does it even consider batch process been run before setting the status?

*This post is locked for comments

I have the same question (0)
  • Mazherullah Profile Picture
    Mazherullah 345 on at
    RE: SysClientSession status

    Hi Rustem,

    Thanks for prompt reply.

    SysClientSessions also shows data of last year with status 1 and 0.

    When i check for Jan 2020 at different times, it shows records with user for example User A and User B showing he logged in at 1:30 PM,

    When I run the query again at 4:30, User B records not shown and User A details shows  that too old records as it was shown at 1:30 but not showing for user b.

    I checked, no records under Sysuserlog.

  • Suggested answer
    Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at
    RE: SysClientSession status

    Hi Mazherullah!

    The SysClientSessions contains the data for the client sessions that are currently active in the system.

    I think SysUserLog is the table you're needed.

  • Mazherullah Profile Picture
    Mazherullah 345 on at
    RE: SysClientSession status

    Hi Rustem,

    1. For how many days/months records does sysclientsession table retain.

    2. Does it record even if the client open AX client or does it records if the user do any operation like opening GL vouchers etc.

    In my case, I am trying to find users who access the dynamics AX database in this sysclientsession but it has not capture all records.  

    Pls. help me understand this sysclientsession.

    At present i am looking for users who access Microsoft Database in this month.   FYI, the database log option NOT enabled/configured in AX.

    Is there any way i can get the details.

  • Verified answer
    Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at
    RE: SysClientSession status

    Hi!

    AX DB has a few stored procedure. One of these is CREATEUSERSESSIONS stored procedure.

    This stored procedure is used to populate the SysClientSessions table. This stored procedure is invoked each time a client is launched.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
KP-31070522-0 Profile Picture

KP-31070522-0 3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans