Idea Transcript
how to get system login time and system logout time to nav for job management? Sign In (/login?ReturnUrl=%2Fnav%2Ff%2F34%2Ft%2F165612)
Share
RSS (/nav/f/34/rss?Mode=0)
Mahesh U (/members/mahesh-u) asked a question on 7 Jul 2015 12:41 AM
Hi Experts,
Question Status Suggested Answer
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.
(/members/mahesh-u)
is there any possibility to do that in nav? Can any one tell me if you know....
Mahesh U (/members/maheshu)
Thanks and Regards,
Works For ICS Technology Services Pvt Ltd. in Hyderabad
Tags:
My Badges
Mahesh U
Microsoft Dynamics NAV 2015: Jobs and Resources (/nav/f/34/tags/Microsoft%2bDynamics%2bNAV%2b2015/Jobs%2band%2bResources)
(/badges/21)
(/badges/26)
All Responses (9)
Only Answers
Mohana Yadav (/members/mohana-yadav) responded on 7 Jul 2015 1:01 AM
Please check Register Time field in General Ledger Setup
(/members/mohanayadav)
Mohana Yadav (/members/mohanayadav) Works In Hyderabad, India @mohana_cse06 (http://twitter.com/mohana_cse06) LinkedIn (http://in.linkedin.com/in/mohanakrishnayadavp) YouTube (http://www.youtube.com/channel/UC1sSk439hIAlHCwkgyNojQA) Blog (http://mohanadynamicsnav.blogspot.nl/) My Badges (/badges/64)
(/badges/40)
(/badges/17)
(/badges/12)
(/badges/68)
(/badges/61)
(/badges/155)
(/badges/156)
(/badges/158)
(/badges/159)
(/badges/161)
(/badges/162)
(/badges/56)
(/badges/170)
(/badges/203)
Mahesh U (/members/mahesh-u) responded on 7 Jul 2015 1:25 AM
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..
(/members/mahesh-u)
Mahesh U (/members/maheshu)
Thanks and regards, Mahesh u
Works For ICS Technology Services Pvt Ltd. in Hyderabad My Badges (/badges/21)
(/badges/26)
Mohana Yadav (/members/mohana-yadav) responded on 7 Jul 2015 1:49 AM
Please use help button in NAV you can select the field and press F1
(/members/mohanayadav)
Mohana Yadav (/members/mohanayadav) Works In Hyderabad, India
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.
@mohana_cse06 (http://twitter.com/mohana_cse06) LinkedIn (http://in.linkedin.com/in/mohanakrishnayadavp) YouTube (http://www.youtube.com/channel/UC1sSk439hIAlHCwkgyNojQA) Blog (http://mohanadynamicsnav.blogspot.nl/) My Badges (/badges/64)
(/badges/40)
(/badges/17)
(/badges/12)
(/badges/68)
(/badges/61)
(/badges/155)
(/badges/156)
(/badges/158)
(/badges/159)
(/badges/161)
(/badges/162)
(/badges/56)
(/badges/170)
(/badges/203)
Mahesh U (/members/mahesh-u) responded on 7 Jul 2015 2:29 AM
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.
(/members/mahesh-u)
Mahesh U (/members/maheshu)
can you please tell me how to track system login time. Thanks and Regards, Mahesh u
Works For ICS Technology Services Pvt Ltd. in Hyderabad My Badges (/badges/21)
(/badges/26)
Mohana Yadav (/members/mohana-yadav) responded on 7 Jul 2015 3:30 AM
There is no standard functionality to record system login and logout time
(/members/mohanayadav)
Mohana Yadav (/members/mohanayadav) Works In Hyderabad, India @mohana_cse06 (http://twitter.com/mohana_cse06) LinkedIn (http://in.linkedin.com/in/mohanakrishnayadavp) YouTube (http://www.youtube.com/channel/UC1sSk439hIAlHCwkgyNojQA) Blog (http://mohanadynamicsnav.blogspot.nl/) My Badges (/badges/64)
(/badges/40)
(/badges/17)
(/badges/12)
(/badges/68)
(/badges/61)
(/badges/155)
(/badges/156)
(/badges/158)
(/badges/159)
(/badges/161)
(/badges/162)
(/badges/56)
(/badges/170)
(/badges/203)
Suggested Answer
Mahesh U (/members/mahesh-u) responded on 7 Jul 2015 3:40 AM
Then how can i achieve this mohana, is there any other way to do this? Thanks Mahesh U
(/members/mahesh-u)
Mahesh U (/members/maheshu) Works For ICS Technology Services Pvt Ltd. in Hyderabad My Badges (/badges/21)
(/badges/26)
Alex A (/members/alex-a) responded on 7 Jul 2015 1:01 PM
Suggested Answer
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:
(/members/alex-a)
Alex A (/members/alexa)
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.
Works In CA, USA My Badges (/badges/12)
(/badges/23)
(/badges/18)
Alex A (/members/alex-a) responded on 7 Jul 2015 1:36 PM
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:
(/members/alex-a)
Alex A (/members/alexa) Works In CA, USA
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
My Badges (/badges/12)
(/badges/23)
(/badges/18)
Mahesh U (/members/mahesh-u) responded on 8 Jul 2015 4:45 AM
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..
(/members/mahesh-u)
Mahesh U (/members/maheshu) Works For ICS Technology Services Pvt Ltd. in Hyderabad My Badges (/badges/21)
(/badges/26)
Thanks and Regards, Mahesh U
Suggested Answer