Technical Tip: Accessing Usage Data in Microsoft Dynamics AX

Technical Tip: Accessing Usage Data in Microsoft Dynamics AX

January Blog Series: New & Best Practices

Insights From: Chris Jamison (Fullscope Senior Software Developer)​

Accessing Usage data (form/table SysLastValue) for all users

Microsoft Dynamics AX  uses usage data specific to each UserId to store user-entered defaults and personalizations.  Each user can see their own data under File> Tools> Options.

Sometimes, however, this user-specific usage data needs to be deleted in order to see new form changes that have been made as a customization to the form, query, etc. in the AOT.

It is often difficult, confusing or cumbersome to notify users that they may need to delete their usage data in order to see new form changes.  System administrators sometimes take the shortcut of recommending that users simply delete all of their usage data in order to allow new changes to take effect.  This is not ideal, since a lot of good personalizations get deleted along with the one needed.

What would be helpful is a form that allows a system administrator to see all users' usage data and make the needed deletions on a more granular basis.

The standard Microsoft Dynamics AX Usage data form (SysLastValue) as accessed from the application will show usage data only for the current user.

Alternately, using the table browser to browse on the SysLastValue table will show all users, but will not show the data details within each record (since the field is a container).

The solution to this (without customizing code) is to access the SysLastValue form directly from the AOT.  Navigate to AOT> Menu items> Display> SysLastValue.  Right-click> Open the menu item:

Notice that the UserID is visible on the form, now.

A system administrator can now delete specific records for multiple users in response to changes in the underlying form object.  And, users can keep the personalizations they have created for other, non-affected forms.

AX Technical Tip, ERP tips