- Get the object name for which we need to track these (user and date&time) information's.
- Login to SQL Server Management Studio and connect to corresponding AX Model database.
- Run below give query (replace element name with the object name).
- From the results, track the user and date&time of modifications.
SELECT ModelElement.ElementType, ModelElement.ElementHandle, ModelElement.Name, ModelElement.Origin,
ModelElementData.CREATEDDATETIME, ModelElementData.CREATEDBY, ModelElementData.MODIFIEDDATETIME,
ModelElementData.MODIFIEDBY, parent.ElementType AS [Parent type], Parent.Name AS [Parent name]
FROM ModelElement
INNER JOIN ModelElementData
ON ModelElementData.ElementHandle = ModelElement.ElementHandle
LEFT OUTER JOIN ModelElementData AS ParentData
ON ParentData.ElementHandle = ModelElement.ParentHandle
INNER JOIN ModelElement AS Parent
ON Parent.ElementHandle = ParentData.ElementHandle
WHERE --ModelElement.ElementType = 42 -- UtilElementType == Tables
ModelElement.Name LIKE '%EcoResProductCategory%' --Replace object name
AND ModelElementData.LayerId > 5 -- Customizations only. Values are in Layer table
No comments:
Post a Comment