Hi, is it possible to trap each object accessed by user during its session?
I mean page, report, codeunit, etc.
It should be very useful during user profiling.
I'm using change log for data purpose, but for pages, how can get the list of objects accessed by user without writing some code in each object to log access?
I'm using NAV 2013.
Many thanks.
*This post is locked for comments
I know it and I have worked with it very very often, but NAV 2013 join SQL Server as NAV User service and I'm able to distinguish SQL batches for one user or other user.
By the same SQL Server connection, NAV app server works with several users, sharing resouces, cursors, etc.
Have you a solution to join SQL process ID and NAV User session ID?
I never found it, yet.
Without this is impossible to identify what exactly user is doing in a specified time.
I have 90 users working on NAV.
B/R
Giorgio
i used sql profiler many times for analyzing nav activities. it's a useful tool.
additional follow
Mmmmhhh...
First: MARS on NAV2013 hide NAV user -> Sql profiler is idle
Second: Without changes on Permissions, app server caches profiles and then won't call SQL Server Engin -> Sql profile is idle
probably this approach was useful with 2009 version, with NAV user/SQL user mapping
But now?
Am I forgetting something?
Now I have a lot of users running NAV as System administrator and this isn't safe.
I know that every one haven't fucked me because surely they are honest, but I will stay pace when they won't do mistakes surely.
So I'm searching a quickly way to map objects accessed by someone for same days in order to build a "map" and then to customize group policies.
I could lock everythink and then spend a lot of time mapping every error, but with hundres of object this will be "a little bit" problem...
For tables is quite simple with change log (but not for reading purposes, for example), but for other objects?
I tryed debug thinking to intercept when NAV checks for permission, accessing Permissions table, but it seems this task isn't executed at C/AL level but in a deeper application level.
You have to create Code Coverage Tool like this
blogs.msdn.com/.../pimp-your-nav-2013-code-coverage-in-30-minuten-nachr-252-sten.aspx
and activate it to check objects that are hit by user.
Is this what you need or Technical/Code changes we did in objects?
I perfect know Change Log use, but it helps only for data change/access purposes, not for object access level. In other words, I know when a user changes data in a table, but I don't know when user opens a page or executes a CU.
hi,
best use the change log.
www.archerpoint.com/.../setting-change-logs-microsoft-dynamics-nav-2013
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (