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
