Skip to main content

Notifications

Microsoft Dynamics AX forum
Unanswered

AX2012 Utilelements/ Utilidelements modifieddatetime

Posted on by 2,721

Hi,

is was looking for an SQL-script that gives me all the created/modified Dates of any obj. I found the Utilelements/ Utilidelements views which would perfectly show wht im looking for. But when Scrolling thru it seems that the modifieddatetime is sometimes the last compile / cil date. Is there anyway to get rid of these?

thx .. Pirmin

  • Jonathan  Halland Profile Picture
    Jonathan Halland 11,302 on at
    RE: AX2012 Utilelements/ Utilidelements modifieddatetime

    Hi Pirmin.

    We wrote a script a while ago to find out what objects have been modified in the last 24 hours (for auditing). However it ended up being mostly useless as alot of objects in AX simply do not record modifieddatetimes. Especially objects that have sub-objects. We used the SysDictClasses quite extensively to accomplish this.

    I agree with Andre, the best way is certainly Source control.

    Kind Regards

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 283,682 Super User on at
    RE: AX2012 Utilelements/ Utilidelements modifieddatetime

    Hi Pirmin,

    If you really need the real dates probably a source control system like Team Foundation Server is better compared these tables.

    Unfortunately we can't control changing the dates as it is handled by the kernel.

    UPDATE: Also the morphX source control can be used in this case.

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 225,000 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans