NAV RTC client user name vs NST user name

Hi, in order to identify which user blocks or participates in deadlocks I need to know the user involved. But because of NST in between the RTC client and the SQL I only get the user name of the connected NST on the SQL spids.
Any ideas how to get this information from NAV? I suppose it holds it somewhere because based on the Windows user of the user it gets the role and appropriate permissions.

Thanks!
Vassilis

Answers

  • SanderDkSanderDk Posts: 113Member
    Depending on you NAV version:
    For NAV2013-NAV2016 you can only specify the NST causing the locking (SQL)
    In NAV2017-NAV2018 you can setup and run Page 9511 "Database Locks" and see the database locks
Sign In or Register to comment.