What is there 0 sessions in Live session when navision 2018 shows me that the licenses are full?

(0) Share

Report

Posted on by joshtechsolutions

4,979

Hi,

I was prompted that the Navision license are full

But when I go to my server and attempt to check the sessions, it shows 0? How come?

Is there anywhere I can get a FREE excel chart to retrieve who is using the license in my Navision?

Thank you!

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

Community Member on at

Like (1)

Report

Josh,

I am not a DEV person but I know this page over the years was a not perfect. The Active Sessions table showed the active licenses users. I recall Jet might be able to read Table 2000000110. Maybe one of the other DEV Forum readers can offer more insight.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (1)

Report

Please try to open the page Session List or Active session table, it should show all the active sessions.

Was this reply helpful? Yes No
joshtechsolutions 4,979 on at

Like (0)

Report

Hi Suresh,

Please advise doesn't accessing Active List or Session List requires another license to go in an view?

In the first place, I can't access navision. How can I see who is in the session so that I can ask the user to log off?

Thank you.

Was this reply helpful? Yes No
Verified answer

Marco Mels on at

Like (1)

Report

Hello,

You can go directly into SQL server. For example this query:

///

SELECT TOP (1000) [timestamp]

,[Server Instance ID]

,[Session ID]

,[User SID]

,[Server Instance Name]

,[Server Computer Name]

,[User ID]

,[Client Type]

,[Client Computer Name]

,[Login Datetime]

,[Database Name]

,[Session Unique ID]

FROM [Demo Database NAV (10-0)].[dbo].[Active Session]

///

You need to replace the database with the actual database name.

Thanks.

Was this reply helpful? Yes No
joshtechsolutions 4,979 on at

Like (0)

Report

Hi Steve,

May I ask if you have any recommended videos that I can learn how to do this?

I also have Jet Report License, however, in my navision server, I dont see Table 2000000110.

Thank you for the great help!

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Josh,

I do not. Do you have access to SQL? If yes, follow Marco's instructions to perform the Query.

Thanks,

Steve

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

If you have access to development environment you should see table 2000000110 Active Session or you can access it from SQL Server Management Studio.

Was this reply helpful? Yes No