News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Dynamics NAV subscript...

Microsoft Dynamics NAV (Archived)

Dynamics NAV subscription license limitations

(0) Share

Report

Report

Posted on by Community Member

Hi there,

I've dynamics nav subscription license. That allows 4 full users to log in to NAV application. But it allows to log in 5 users as well.

So I need to restrict this.

How to know a number of licensed users count via some SQL query or C/AL code?

Please suggest achieving this.

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Lars Hædersdal 750 on at

Like (0)

Report

RE: Dynamics NAV subscription license limitations

Why do you want to limit it?

When you buy a subscription license it also includes one partner and one accountant access for free. So in your case 6 persons can log on.

If you create one partner and one accountant account in NAV beside the 4 "real" users you cannot create more users without adding extra users in the licens.
Suggested answer

Suresh Kulla 44,656 on at

Like (0)

Report

RE: Dynamics NAV subscription license limitations

You can check in the Active Session Table or use the PowserShell Command from Administration Shell Get-NAVServerSession and will list all the opens sessions
Suggested answer

Stefano Demiliani 37,162 Most Valuable Professional on at

Like (0)

Report
RE: Dynamics NAV subscription license limitations

You can check user session in NAV directly from Development Environment or via C/AL querying the Active Session table.

Via T-SQL:

SELECT * from [Active Session];

Via Powershell:

$NAVID = 100

Import-module "${env:ProgramFiles}\Microsoft Dynamics NAV\$NAVID\Service\NavAdminTool.ps1" -force -ErrorAction Stop -WarningAction SilentlyContinue -Verbose:$false | out-null

$ServerInstances = Get-NAVServerInstance
foreach ($ServerInstance in $ServerInstances)
{
    foreach ($Attribute in $ServerInstance.Attributes)
    {
        IF ($Attribute.Name -eq 'ServerInstance')
        {
            $Session += Get-NAVServerSession -ServerInstance $Attribute.Value -ErrorAction SilentlyContinue -WarningAction SilentlyContinue
        }
    }
}

IF ($Session)
{
    $Session | Out-GridView
}

Check if the $NAVID setting is valid (e.g. 90 = NAV 2016, 100 = NAV 2017, 110 = NAV 2018)

Execute the code by pressing F5

You will see a list of all users currently logged in Dynamics NAV.

Note: This script shows all loggend users over all NAV Server-instances.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,430 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans