web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Microsoft Dynamics Nav...
Microsoft Dynamics NAV (Archived)

Microsoft Dynamics Nav 2009 users

(0) ShareShare
ReportReport
Posted on by Community Member

In Microsoft Dynamics Nav 2013 and higher, Microsoft announced powershell cmdlets and its very easy to get all Nav users using powershell command Get-NAVServerUser.

Any idea how to get all users in Nav 2009 and lower where this is not supported? I need a way to get this users programmatically using powershell or c#.

*This post is locked for comments

I have the same question (0)
  • Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    Get-NavServerUser returns information about all users created in the current Microsoft Dynamics NAV database. Do you want to retrieve these informations on NAV 2009? You could directly read the User SQL table (and maybe other related such as Windows Login).

  • Community Member Profile Picture
    Community Member on at

    Is it always a case that users are stored in MS SQL database, or it can be other database type (local file or nav database)?

  • Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    No local file DB is dismissed. Users details are stored on SQL now.

  • Community Member Profile Picture
    Community Member on at

    Just to conclude: the only way to get all users is to log in to the database and read both windows and sql users? That would give me all users in the NAV?

    Thats already helpful. Is there a way to know NAV database names? My goal is to make application where you give credentials, and it connect to the server and read users. It would be very helpful if I can find nav DB name, because adding it manually for each server is not a good solution (my clients have environments with 60 or more nav servers)

  • Verified answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    You need to know the SQL database name, otherwise it's impossible to connect to him to read NAV user's configuration. Maybe you mean Company names? You can retrieve Companies in your NAV database by reading the Company and Company Information table.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans