Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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?
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.
Please try to open the page Session List or Active session table, it should show all the active sessions.
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?
You can go directly into SQL server. For example this query:
SELECT TOP (1000) [timestamp]
,[Server Instance ID]
,[Server Instance Name]
,[Server Computer Name]
,[Client Computer Name]
,[Session Unique ID]
FROM [Demo Database NAV (10-0)].[dbo].[Active Session]
You need to replace the database with the actual database name.
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!
I do not. Do you have access to SQL? If yes, follow Marco's instructions to perform the Query.
If you have access to development environment you should see table 2000000110 Active Session or you can access it from SQL Server Management Studio.
Business Applications communities