Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

How to monitor Dynamics AX client versions

Hello,

If you see “version mismatch” warning messages in an AOS Server Event Viewer’s Application log, you have Dynamics AX clients with out-of-date versions:

Object Server xxx: Internal version mismatch. Microsoft Dynamics AX Client from xxx

The SYSUSERLOG table can help you to find the Dynamics AX clients that need to be updated. This table logs the login and logout events for each client, including the client build number.

More information can be found here: https://msdn.microsoft.com/en-us/library/sysuserlog.aspx.

A basic query could be as follows:

SELECT USERID, COMPUTERNAME, BUILDNUM

FROM SYSUSERLOG

WHERE CREATEDDATETIME >= GETDATE() – 30 — last 30 days

AND CLIENTTYPE = 1 — user sessions

You can build your own queries, for example to obtain the build number of the last session by user, or to return all the workstations with an AX client build number different from the AOS version number:

SELECT DISTINCT(COMPUTERNAME)

FROM SYSUSERLOG

WHERE BUILDNUM <> ‘6.2.1000.4051’

AND CREATEDDATETIME >= GETDATE() – 30

 

I hope this is helpful!

Bertrand