web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Clean up DataBaseLog

Finance | Project Operations, Human Resources, ...

Unanswered

Clean up DataBaseLog

(1) Share

Report

Report

Posted on by Christian Busche

616

Hi,

I like to use the standard functionallity to clean up the database log:

A dialog opend where particular filters can be set:

Hopeful to delete all database log entries from today less than 30 days I create this filter (see Advanced filtering and query syntax - Finance & Operations | Dynamics 365 | Microsoft Learn) But it doesn't work...

What is the right syntax to define a query, that deletes all entries from today less 30 days?

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Adis 6,027 Super User 2025 Season 2 on at

Like (0)

Report

Hello,

I tried different things and it didnt work. Its weird that it worked for others:

Solved: Database Log Clean Up Batch Job

When I filtererd like you mentioned, the system deleted all records.

I tried the following:

Checked the parameters on the batch job and received this. Which means, it did nothing, because the filter means: until empty date and empty date is 01.01.1900. So nothing was deleted.

Entering a specific date like : ..20.02.2025 works fine. However, I need a relative date for setting up a batch job.

I flagged the question for help.

@André Arnaud de Calavon do you have any idea?

Kind regards, Adis

Was this reply helpful? Yes No
Martin Dráb 237,697 Most Valuable Professional on at

Like (1)

Report

What exactly do you mean by "it doesn't work"?

You seem to want a query returning records created 30 days ago or earlies, but that's not what your filter does. You want to remove 30 days from today, not to add them: (lessThanUtcDate(-30)).

Was this reply helpful? Yes No
Christian Busche 616 on at

Like (0)

Report

Hey Martin,

I wanted to delete data that is older than today minus 30 days. Example... On 01.03. all data that was created before 30.01. is to be deleted. I only wanted to keep the data from the last 30 days...

That was not possible with my filter. So I try to use "your" filter lessThanUtcDate(-30)

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 683 Most Valuable Professional

#2

André Arnaud de Cal... 563 Super User 2025 Season 2

#3

Sohaib Cheema 398 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans