Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

AX2012 R2 list of changed obj by date

Posted on by 2,721

Hi

i want to create a liste of changed / new obj in AX2012 per date. In AX 3.0 i did this via "develoment Environment" -> "Tools" ->""developement Tools" -> "application obj" and there filtered by date

any hint how to do this in AX 2012 (Kind of Version tracking..)

Thanks

Pirmin

  • CU14050944-0 Profile Picture
    CU14050944-0 2,721 on at
    RE: AX2012 R2 list of changed obj by date

    Hi

    well when using the sql script above i get too many changed obj for the time .. and most of them are at same date/hour with maybe some mins of difference..

  • Martin Dráb Profile Picture
    Martin Dráb 224,741 Super User on at
    RE: AX2012 R2 list of changed obj by date

    Why do you think so?

    If ModifiedDateTime was the time of the last compilation, compiling the whole AOT would update ModifiedDateTime on all elements, wouldn't it? It doesn't seem to be the case in my system.

    Regarding CIL, AX determines the last CIL generation date from SysXppAssembly table.

  • CU14050944-0 Profile Picture
    CU14050944-0 2,721 on at
    RE: AX2012 R2 list of changed obj by date

    thanks

    i did a lil sql statment

    **

    select  distinct  name, createddatetime, createdby, modifieddatetime, modifiedby   from ModelElementData  , ModelElement

    where -

    ModelElementData.parenthandle=ModelElement.elementhandle

    and year (modifieddatetime)=   2014    and month(  modifieddatetime) > 4

    ***

    can it be tht the modifieddate is also the last compile/cil date?

  • Martin Dráb Profile Picture
    Martin Dráb 224,741 Super User on at
    RE: AX2012 R2 list of changed obj by date

    In AX, it's under AOT > System Documentation > Tables. Technically it's a view to the model store database.

    By the way I made a little mistake - you want SysModelElementData table, not SysModelElement.

  • CU14050944-0 Profile Picture
    CU14050944-0 2,721 on at
    RE: AX2012 R2 list of changed obj by date

    Hi

    srry ..w as out of office .. where is the table sysmodeleement stored?

    Pirmin

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 224,741 Super User on at
    RE: AX2012 R2 list of changed obj by date

    The best kind of version tracking is a real version tracking. :-) And it's the only safe way, because it's independent on AX instances.

    Nevertheless SysModelElement.CreatedDataTime and ModifiedDataTime may be sufficient for your purposes.

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,663 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,741 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans