web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 60,977 Super User 2025 Season 2 on at
    RE: how to get system login time and system logout time to nav for job management?

    Please check Register Time field in General Ledger Setup

  • Mahesh U Profile Picture
    Mahesh U 433 on at
    RE: how to get system login time and system logout time to nav for job management?

    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 60,977 Super User 2025 Season 2 on at
    RE: how to get system login time and system logout time to nav for job management?

    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
    RE: how to get system login time and system logout time to nav for job management?

    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 60,977 Super User 2025 Season 2 on at
    RE: how to get system login time and system logout time to nav for job management?

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

  • Mahesh U Profile Picture
    Mahesh U 433 on at
    RE: how to get system login time and system logout time to nav for job management?

    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 2,716 on at
    RE: how to get system login time and system logout time to nav for job management?

    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 2,716 on at
    RE: how to get system login time and system logout time to nav for job management?

    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
    RE: how to get system login time and system logout time to nav for job management?

    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

Responsible AI policies

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

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Alexander Ermakov Profile Picture

Alexander Ermakov 2

#2
SC666 Profile Picture

SC666 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans