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
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.
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.
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (