Skip to main content
Microsoft Dynamics NAV forum
Answered

sessions list NAV 2016

editSubscribe (0) ShareShare
ReportReport
Posted on by UG Leader

hi,

is there any option to find users login sessions with out login to NAV, my situation is , if the number of licence reached, even Myself (admin) cant able to login and see the sessions. in such cases how i could find out what are the logged in sessions ?

Categories:
  • Suggested answer
    TeddyH Profile Picture
    TeddyH 12,720 Super User on at
    RE: sessions list NAV 2016

    Run the search query to look for the active session.

    Once you decide which active session to kill, just do a DELETE with WHERE query.

    www.w3schools.com/.../sql_delete.asp

  • Community Member Profile Picture
    Community Member UG Leader on at
    RE: sessions list NAV 2016

    Thank you for your replay, but i couldnt find any active session unless run a query.  in other words i can only see the active session with sql query

  • Suggested answer
    TeddyH Profile Picture
    TeddyH 12,720 Super User on at
    RE: sessions list NAV 2016

    just delete the session from the active session. it should work.

  • Community Member Profile Picture
    Community Member UG Leader on at
    RE: sessions list NAV 2016

    Thank you for your response, i could view this , my situation is different. i should  view sessions without login to NAV. Anyways i got answer.  

  • Community Member Profile Picture
    Community Member UG Leader on at
    RE: sessions list NAV 2016

    It works.. thank you Very much.. by the way is there any option to kill a user session like this method. it would be helpful if it possible.

  • Verified answer
    TeddyH Profile Picture
    TeddyH 12,720 Super User on at
    RE: sessions list NAV 2016

    The query to the database name will be different according to your database setup and name.

    Go to SQL Server Management Studio, connect to your database, create the query, and run it.

    SELECT * from dbo.[Active Session]

  • Suggested answer
    azelaya59 Profile Picture
    azelaya59 2,805 on at
    RE: sessions list NAV 2016

    Binudas

    I see you have received many very good suggestions within SQL to see your users. If you are a SUPER, you can simply type "Sessions" from the search box within NAV and you will be presented with a complete listing of all open sessions. Including background sessions. Food for thought................

    2019_2D00_05_2D00_28_5F00_0709_5F00_001.png

    2019_2D00_05_2D00_28_5F00_0709_5F00_001.png

    Good Luck!

  • Community Member Profile Picture
    Community Member UG Leader on at
    RE: sessions list NAV 2016

    i am new to SQL. could you please  text a step by step procedure, it would be more helpful for me.

  • Suggested answer
    TeddyH Profile Picture
    TeddyH 12,720 Super User on at
    RE: sessions list NAV 2016

    What do you mean by subfolder ?

    Just do a sql query on the Active Session. You probably need to put condition to filter out unnecessary information.

    SELECT * from [Active Session]

  • Community Member Profile Picture
    Community Member UG Leader on at
    RE: sessions list NAV 2016

    i could find the dbo.Active session, but it has sub folders, none of it contains my active users list.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,045 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,570 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans