You’re offline. This is a read only version of the page.
4,359
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!
If you have access to development environment you should see table 2000000110 Active Session or you can access it from SQL Server Management Studio.
Josh,
I do not. Do you have access to SQL? If yes, follow Marco's instructions to perform the Query.
Thanks,
Steve
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!
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.
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.
Please try to open the page Session List or Active session table, it should show all the active sessions.
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
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (