Small and medium business | Business Central, N...

How to Track User Login Hours and Records Created in Business Central

(9) Share

Report

Posted on by D365 Business Centr...

The IT administrator of a client organization needs to track the following information in Dynamics 365 Business Central:

The number of hours each user is logged into the system.
The number of records each user creates in the system (for example, sales orders, purchase orders, or other document types).

The objective is to monitor user activity and measure system usage.

Questions:

Does Business Central provide a built-in feature to capture login duration per user?
Is there a standard way to count the number of records created by each user across different tables?
If not available by default, what methods can be used to implement this functionality (e.g., through custom development, telemetry, or integration with Azure Active Directory logs)?
Are there existing reports or extensions that provide this information?

Looking for recommendations on how to achieve this with minimal overhead and in a supportable manner for Business Central (cloud or on-premises).

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Kamal Khakhkhar 1,202 on at

Like (3)

Report

How to Track User Login Hours and Records Created in Business Central

Hii There ,

as per your requirement You can get use last login details in Azure, through telemetry.

and you can create a report in that you can create functionality as per that you can get the details in Report ans you through Job Queue you can send to your Manager as per requirement.

If You found answer mark It Answered.

Thank You.

Kamal Khakhkhar.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,961 Super User 2025 Season 2 on at

Like (4)

Report

How to Track User Login Hours and Records Created in Business Central

You can enable "Register Time" field on General Ledger Setup page or User Setup page.

You can check the registers on "User Time Registers" page.

Was this reply helpful? Yes No

Suggested answer

Mohamed Amine Mahmoudi

26,316 Super User 2025 Season 2 on at

Like (3)

Report

How to Track User Login Hours and Records Created in Business Central

Hi @D365 Business Central Functional Consultant,

1. Track User Login Duration
Not natively tracked in Business Central.

Method	Description	Effort	Notes
Azure AD Sign-in Logs	Tracks login/logout time via Microsoft Entra (Azure AD)	Low	Best for accurate login session tracking
Application Insights	Logs BC telemetry like page views, sign-ins (if telemetry is enabled)	Medium	Requires telemetry setup and access
Custom Session Log (AL)	Custom table with `UserId`, `LoginTime`, `LogoutTime`	High	Needs extension development; limited by web session

2. Track Records Created Per User
Not automatically recorded across all tables.

Method	Description	Effort	Notes
Change Log	Built-in; logs Insert/Modify/Delete per user for selected tables	Low	Enable in `Change Log Setup`
Custom AL Logging	Use event subscribers to log user insert actions to a custom table	Medium	More control; ideal for critical tables
Telemetry (App Insights)	Logs actions (e.g., insert via pages) if telemetry is enabled	Medium	Requires Application Insights and setup

Existing Tools / Extensions

Tool or Extension	Purpose
Change Log	Track field-level changes by user
Insight Works – Time Tracking	AppSource extension for activity
Power BI (Custom Reports)	Combine AAD + BC logs
GitHub/DevOps Pipelines	Possible if telemetry is centralized

Best Practice Recommendation
To achieve this with minimal overhead and good supportability:

Use Azure AD Sign-In Logs to monitor login durations.
Enable Change Log on important tables (e.g., Sales Header, Purchase Header).
Combine logs in Power BI for activity dashboards.
Optionally, use telemetry or custom AL logging for more control.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No

Suggested answer

Holly Huffman 6,522 Super User 2025 Season 2 on at

Like (2)

Report
How to Track User Login Hours and Records Created in Business Central

Good morning, afternoon, or evening depending on your location :)
Hope you are well today!

Here’s a breakdown of how to track user login hours and records created in Dynamics 365 Business Central, both cloud and on-premises:

1. Tracking User Login Hours
Built-in Feature: Register Time
Business Central includes a native feature called Register Time, which tracks how long users are logged in each day.
Setup Steps:

Go to General Ledger Setup → Enable the Register Time field.

Then go to User Setup → Enable Register Time per user (optional override).

View data in the User Time Registers page.

What it captures:

Daily login duration per user.

Uses the Created At field for login and Modified At for logout.

Does not capture exact login/logout timestamps or account for idle time or crashes [1] [2] [3].

Alternative: Azure AD Sign-In Logs
For more detailed login data:

Use Azure Active Directory > Sign-ins.

Provides timestamps, device info, and app usage.

Does not specify which Business Central environment was accessed [1].

2. Tracking Records Created by Users
Business Central does not provide a built-in cross-table report for this, but here are options:
Option A: Use Change Log

Enable Change Log for relevant tables (e.g., Sales Header, Purchase Header).

It logs who created or modified records and when.

Can be queried or reported on using standard pages or custom reports.

Option B: Custom Development

Create a custom extension or report that:

Queries key tables.

Groups by Created By or User ID.

Aggregates counts per user.

Option C: Telemetry via Azure Application Insights

If telemetry is enabled, you can use Application Insights to track user actions.

Requires setup and Power BI or Kusto queries to analyze.

3. Existing Reports or Extensions

Power BI App for Business Central Telemetry: Offers insights into usage patterns (though not login durations).

Custom Power BI Reports: Can be built using Change Log or telemetry data.

Third-party extensions: Some ISVs offer user activity monitoring tools, but these vary in scope and cost.

Recommendations for Minimal Overhead

Enable Register Time for basic login tracking.

Use Change Log for tracking record creation.

Leverage Azure AD logs for detailed sign-in data.

Avoid heavy customizations unless detailed auditing is a strict requirement.

[1] Dynamics 365 Business Central: User Login History (Register Time and ...
[2] User Time Register Feature in Business Central: Track User Login History
[3] How to Monitor User Logins in Business Central

Note: I collaborated with Copilot to help craft this response for clarity and completeness.
Hope this helps some!

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,182 Super User 2025 Season 2 on at

Like (4)

Report

How to Track User Login Hours and Records Created in Business Central

For your reference

https://community.dynamics.com/blogs/post/?postid=7aa09b70-fdd7-ee11-92bd-002248527d3d

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 4,164 Super User 2025 Season 2 on at

Like (4)

Report

How to Track User Login Hours and Records Created in Business Central

Hello,

You could check the following configuration for your requirement:

In general Ledger setup too.

I hope I can help.

Regards,

Andres

Was this reply helpful? Yes No
Gerardo Rentería Ga... 23,574 Most Valuable Professional on at

Like (2)

Report

How to Track User Login Hours and Records Created in Business Central

Hi, good day
I hope this can help you, and give you some hints.

Telemetry in Action 🧐: Track User Activities in BC 🔍 – Gerardo Rentería Blog

Dynamics 365 Business Central: User Login History (Register Time and Sign-in logs) | Dynamics 365 Lab

How to Monitor User Logins in Business Central - Dynamics 365 Business Central Insights

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,578 Super User 2025 Season 2 on at

Like (3)

Report

How to Track User Login Hours and Records Created in Business Central

Hi, for user login records:

Dynamics 365 Business Central: User Login History (Register Time and Sign-in logs) | Dynamics 365 Lab

Analyzing Authorization Trace Telemetry

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/telemetry-authorization-trace?wt.mc_id=DX-MVP-5004336

For the modification history

Auditing changes: https://learn.microsoft.com/en-us/dynamics365/business-central/across-log-changes?wt.mc_id=DX-MVP-5004336

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,874 Super User 2025 Season 2 on at

Like (5)

Report

How to Track User Login Hours and Records Created in Business Central

Hello,

For cloud environments, you can use Azure Active Directory sign-in logs to monitor login activity. To track record creation, custom development can add a Created By field on key tables using event subscribers. Some third-party extensions like user activity trackers are also available on AppSource. For minimal overhead and supportability, combining Azure AD logs with lightweight AL customizations is the recommended approach.

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,087 Super User 2025 Season 2 on at

Like (2)

Report

How to Track User Login Hours and Records Created in Business Central

Business Central doesn't track login hours by default. For cloud environments, you can use Azure AD sign-in logs via Microsoft Entra for login tracking.

To count records created by each user, you’d need custom development—like adding fields or triggers to log "Created By" data—or use telemetry (Application Insights).

There’s no built-in report, but third-party apps or extensions might help.

✅ Mark this as the verified answer if helpful.

Was this reply helpful? Yes No