Find out who is connected to AX and from which computer

Here is a very simple query you can run against your Business Database to find out who are the users that have an active sessions in AX:

SELECT DISTINCT USERID, CLIENTCOMPUTER FROM SYSCLIENTSESSIONS WHERE STATUS = 1

This table has some more useful info that you can extract so you can tune the query for your own use.

use SELECT * from SYSCLIENTSESSIONS to see the whole table.

** This works for AX 2009 /2012

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s