Clean up DataBaseLog

(1) Share

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 (3)

Answers (0)

Adis 5,823 Super User 2025 Season 2 on at

Like (0)

Report

Clean up DataBaseLog

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 236,960 Most Valuable Professional on at

Like (1)

Report

Clean up DataBaseLog

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

Clean up DataBaseLog

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