0

How do you pull out the number of users in sessions in Navision 2018?

Josh

August 02, 2021 01:39

None

Follow

Hi,

I wonder if anyone can advise how to pull out existing users who are having a session in Navision using Jet report?

 

Thank you.

• Facebook
• Twitter
• LinkedIn

3 comments

• 1
  
  Rob Fontaine September 02, 2021 18:02

  Hi Josh,

  For the number of active sessions:

  NL("Count","Active Session",,"Database Name","databasename")

  For list of active sessions by user ID:

  NL("Rows","Active Session","User ID","Database Name","databasename")

• 0
  
  Josh September 06, 2021 00:58

  Hi Rob, 

  Thank you for your reply. I was able to pull out the active session.

  Is it me, or is Jet Report Forums tends to be real quiet and a bit slow to response?

  Is there any other Jet Report forums that we can expect faster response?

  Thank you.

• 0
  
  BryanAtTigunia December 22, 2021 13:41

  I think the problem with the forums and low activity has to do with the acquisition of Jet by insightsoftware.  Prior to the acquisition, Jet consultants were encouraged to spend some time each week looking at the forum and answering what they could.  We never touted ourselves as consultants, but we were out there.

  I don't think insightsoftware has the same belief in the forums.

  I personally no longer have a Jet license or a NAV/BC database to test against to ensure syntax, so I help out when I can.

  I'm sure this post will get taken down by the moderator.