Check user Online

Dear Everybody.

In NAV 2013. How to know how many users are online. 
In NAV 5.0 I can check form Database Information and see current sessions. But NAV 2013 I'm can't see it.

Please suggestion.

Thanks very much.

My approach is in SQL Management Studio.
Create a query like this:

SELECT

DB_NAME(dbid) as DBName,
COUNT(dbid) as NumberOfConnections,
loginame as LoginName
FROM
sys.sysprocesses
WHERE
dbid > 0 and
DB_NAME(dbid)=‘my_NAV2013r2_DatabaseName’ --may be Case Sensitive!
GROUP BY
dbid, loginame

(sorry, crazy formatting; sometimes happens with Copy&Paste [:’(] )

Thanks Anfinnur very much.

That query will show current sessions but may not equate to active users due to the connection pooling.

HI Dinhson,

You can created a list or card page on the table “2000000009 - Session”. Then you can find the sessions accordingly.

Thank you and regards,

Dinz

Thanks Dinz but I can not find table 2000000009 - Session in database live of me. I can see table “2000000111-Session Event” and “2000000110-Active Session”

Best Regards

dinhson

Hi Dinhson,

I am sorry , I forget to mention that this table is hidden in dynamics NAV. When you are creating new page just give the Tabled ID as source table.

Please find the below Saurav’s blog for more information.

http://saurav-nav.blogspot.com/2012/02/navision-list-of-hidden-tables.html

Thank you and regards,

Dinz

Thanks Dinz