Question Status

Verified
Brad Hollingsworth asked a question on 8 Apr 2013 11:41 AM

When you scroll through the X++ Classes in AX, there is a window on the right side of the screen that shows last change date.  Is there any way to report or perform a SQL query on that date?  Where is that date stored (table or metadata within the class)?

Reply
Verified Answer
Dick Wenning responded on 8 Apr 2013 11:59 AM

look at the table UtilElements

it is in the aot system documentation. click right mouse and table brouwse

Kind regards, 

Kaya Solutions

Dick Wenning

+31 6 147 989 53 

Landjuweel 5

3905 PE - Veenendaal

 

OTHER CONTACT INFORMATION

Reply
Suggested Answer
Joris de Gruyter responded on 15 Apr 2013 9:01 AM

Also a word of warning though, I wouldn't trust those dates and user IDs of last changed if my life depended on it. Once you get your reporting going I'm positive you will agree.

Reply
Verified Answer
Dick Wenning responded on 8 Apr 2013 11:59 AM

look at the table UtilElements

it is in the aot system documentation. click right mouse and table brouwse

Kind regards, 

Kaya Solutions

Dick Wenning

+31 6 147 989 53 

Landjuweel 5

3905 PE - Veenendaal

 

OTHER CONTACT INFORMATION

Reply
Brad Hollingsworth responded on 8 Apr 2013 12:32 PM

Thanks for your suggestion, but this appears to show create/change information about Tables rather than Classes.

Reply
Dick Wenning responded on 8 Apr 2013 12:48 PM

look better, there is record type with

class,  class instance method, cass static method

it is all there, it is the whole AOT

Kind regards, 

Kaya Solutions

Dick Wenning

+31 6 147 989 53 

Landjuweel 5

3905 PE - Veenendaal

 

OTHER CONTACT INFORMATION

Reply
Brad Hollingsworth responded on 8 Apr 2013 3:07 PM

Thanks, I was looking in the wrong place at first.  This should allow me to audit changes reliably.

Reply
Suggested Answer
Joris de Gruyter responded on 15 Apr 2013 9:01 AM

Also a word of warning though, I wouldn't trust those dates and user IDs of last changed if my life depended on it. Once you get your reporting going I'm positive you will agree.

Reply