Ax 2012 R2, R3 Sql de en son değişiklikleri bulma

 SELECT  ME.Name ,

        ME2.Name ,

        MED.MODIFIEDDATETIME ,

        MED.MODIFIEDBY

FROM    dbo.ModelElementData AS MED

        LEFT JOIN dbo.ModelElement AS ME ON ME.ElementHandle = MED.ElementHandle

        LEFT JOIN dbo.ModelElement AS ME2 ON ME2.ElementHandle = ME.ParentHandle

WHERE MED.MODIFIEDBY like '%CKR%'

ORDER BY MED.MODIFIEDDATETIME DESC