Today I wanted to get some basic information about my NAV2018 service and database name in my extension. A quick Google found a lot of useful stuff about this but nothing that was easy enough for me. I really did not want to go messing about with xml or dotNET. This is basic stuff right? There has to be a simple way. And then my eye was drawn to my system indicator, what I want is right there on the screen.
So I started having a look in table 79, Company Information, and there was the gem I needed:
But can I use it in VS Code? Well, it turn out that you can:
So, for me the Active Session table works perfectly. It does not show you the database server though.
Many thanks to the people who wrote about this before me:
https://www.kauffmann.nl/2015/04/07/read-server-settings-from-cal-code/
https://community.dynamics.com/nav/f/34/p/141286/831849#831849
http://www.dynamics.is/?p=541