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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / how to get system logi...
Microsoft Dynamics NAV (Archived)

how to get system login time and system logout time to nav for job management?

(0) ShareShare
ReportReport
Posted on by Mahesh U 433

Hi Experts,

    i am developing a job management for my organization. i want to automate the employee login time and logout time using that particular employee system login time and system shutdown time.

is there any possibility to do that in nav? Can any one tell me if you know....

Thanks and Regards,

Mahesh U

*This post is locked for comments

I have the same question (0)
  • Mohana Yadav Profile Picture
    Mohana Yadav 61,214 Super User 2026 Season 1 on at

    Please check Register Time field in General Ledger Setup

  • Mahesh U Profile Picture
    Mahesh U 433 on at

    Thanks for reply mohana,

    I have checked that field its a boolean field. how can i use this field to track my system login and logout time. can you please explain me bit more clearly..

    Thanks and regards,

    Mahesh u

  • Mohana Yadav Profile Picture
    Mohana Yadav 61,214 Super User 2026 Season 1 on at

    Please use help button in NAV

    you can select the field and press F1

    Here you can specify whether the program will register the user's time usage. Place a check mark in the field if you want the program to register time for each user.

    The program can use the User Time Register table to register how much time an individual user spends on the companies. When there is a check mark in the Register Time field, the program automatically enters information (about the user ID, date and number of minutes worked) in the User Time Register table each time the user leaves the program. The time is registered in whole minutes, so periods can be rounded up or down by as much as 30 seconds.

    If you have specified a different setting in the User Setup table then the setup in the User Setup table will overrule this general setting.

  • Mahesh U Profile Picture
    Mahesh U 433 on at

    Thank you Mohana,

      it is showing how many minutes you worked with nav... but i need system login time not nav working minutes. its also helpful for me somewhere.

    can you please tell me how to track system login time.

    Thanks and Regards,

    Mahesh u

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 61,214 Super User 2026 Season 1 on at

    There is no standard functionality to record system login and logout time

  • Mahesh U Profile Picture
    Mahesh U 433 on at

    Then how can i achieve this mohana, is there any other way to do this?

    Thanks

    Mahesh U

  • Suggested answer
    Alex A Profile Picture
    Alex A 3,131 Super User 2026 Season 1 on at

    Hello Mahesh,

    The system login time is tracked in the [Active Session] table. If you have a Database Administrator (DBA) to help you, then they should be able to see the data you are looking for in the following simple query:

    SELECT [User ID], [Client Computer Name], [Login Datetime] 
FROM [Active Session]
ORDER BY [User ID]

    Your DBA should be able to get all the information you need from the NAV and System tables.

  • Suggested answer
    Alex A Profile Picture
    Alex A 3,131 Super User 2026 Season 1 on at

    You can also use the [Session Event] table. It keeps track of all logon and logoff events with date and time stamps. Here is a simple query your DBA can use to see what I'm talking about:

    SELECT [User ID], [Client Computer Name], [Event Datetime],
CASE
  WHEN [Event Type] = 0 THEN 'Logon'
  WHEN [Event Type] = 1 THEN 'Logoff'
  WHEN [Event Type] = 2 THEN 'Start'
  WHEN [Event Type] = 3 THEN 'Stop'
  WHEN [Event Type] = 4 THEN 'Close'
  ELSE CAST([Event Type] AS VARCHAR)
  END AS [Event Type]
FROM [Session Event]
ORDER BY [Event Datetime] DESC


  • Mahesh U Profile Picture
    Mahesh U 433 on at

    Hi Alex,

    Thanks for your information. i will check and let you know whether it will helpful for me or not. once again thank you for your info..

    Thanks and Regards,

    Mahesh U

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans