web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

User login history in database tables

(0) ShareShare
ReportReport
Posted on by 5

Hi, 

I have access to Microsoft Dynamics 365 Business Central database only.

And I need to pull data which user and when has logged on to the Microsoft Dynamics 365.

Are there any tables that has such a information?


Thanks, 

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    15,529 on at

    Hi

    You need to use Session Even table (2000000111) for this purpose. See idea below. In addition you may need to access User table to get the ID to match this table with name. 

    Try this link to access the table or use configuration package  https://businesscentral.dynamics.com/?table=2000000111 

       

    Or for last login see

    https://yzhums.com/9571/

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,226

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,047 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,257 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans