Share via

NAV 2015 TRACKING SESSIONS, USERS ACTIVITY, CHANGE LOG

  • Article

NAV 2015 TRACKING SESSIONS, USERS ACTIVITY, CHANGE LOG

A simple post about NAV 2015 Tracking Technology, based on MSDN NAV Online Help.

** 1) TRACKING SESSIONS**

NAV 2015 Active Sessions Table

“Active Session”  Table

“Specifies sessions that are currently active and are connected to a Microsoft Dynamics NAV Server instance. An active session can be in use or idle.

This table can contain sessions that are not active, before those are removed from the table. For example, if a Microsoft Dynamics NAV Server instance stops responding, then the table can contain sessions that are not active. When the Microsoft Dynamics NAV Server instance restarts, it deletes from the table the sessions that are not active. If the Microsoft Dynamics NAV Server instance never restarts, then other the Microsoft Dynamics NAV Server instances delete the sessions that are not active.”

https://msdn.microsoft.com/en-us/library/hh895997(v=nav.80).aspx

Field Location
Session ID Field, Active Session Table Using Microsoft Dynamics NAV
Database Name Field, Active Session Table Using Microsoft Dynamics NAV
Login Datetime Field, Active Session Table Using Microsoft Dynamics NAV
User ID Field, Active Session Table Using Microsoft Dynamics NAV
User SID Field, Active Session Table Using Microsoft Dynamics NAV
Server Computer Name Field, Active Session Table Using Microsoft Dynamics NAV
Client Computer Name Field, Active Session Table Using Microsoft Dynamics NAV
Client Type Field, Active Session Table Using Microsoft Dynamics NAV
Server Instance Name Field, Active Session Table Using Microsoft Dynamics NAV
Server Instance ID Field, Active Session Table Using Microsoft Dynamics NAV

** “Active Sessions List” Page > based on “Session” Table**

Client Type

> Windows Client, Web Client, Tablet  Client, Web Services (& Odata Access), Background Services (NAV Server Service or NAS Service)

** https://robertostefanettinavblog.files.wordpress.com/2015/06/nav-1.png?w=530&h=509**

2) TRACKING USERS ACTIVITY & CHANGE LOG

Standard NAV By Design functionalities

Actually NAV has 2 separate tables to track user activities  (only NAV activities handled by NAV Server)

>  User Time Registers Table > login\logout with user activities timing

“Specifies how much time an individual user works on the accounts.

The User Time Register table is useful for accounting firms that want to register the amount of time spent working on each company. You may also want to see who has worked on the companies in which period.

To use the User Time Register table, two conditions must be fulfilled: the user must be set up with a personal User ID in the security system and there must be a check mark in the Register Time field.

The program registers time in whole minutes, rounding up or down.”

https://msdn.microsoft.com/en-us/library/hh169225(v=nav.80).aspx

https://robertostefanettinavblog.files.wordpress.com/2015/06/nav-2.png?w=434&h=266

User Time Registers Table Detail

Field Location
User ID Field, User Time Register Table General Ledger
Minutes Field, User Time Register Table General Ledger
Date Field, User Time Register Table General Ledger

>  Change Log Table > data modifications (insert, delete, modify, previous record before modify)

By Default these tables are not configured & tracking isn’t active, user can activate these functions On-Demand

“The change log in Microsoft Dynamics NAV logs changes that are made to data in the tables that you track. In the change log, entries are chronologically ordered and show changes that are made to the fields on the specified tables.

The change log collects all changes that are made to the table.”

https://msdn.microsoft.com/en-us/library/hh167300(v=nav.80).aspx

https://robertostefanettinavblog.files.wordpress.com/2015/06/nav-3.png?w=355&h=356

Field Location
Primary Key Field, Change Log Setup Table General Ledger
Change Log Activated Field, Change Log Setup Table General Ledger