Clear history logs from IAL automatcally

When “Copy Only New Data” in IAL is used you get a table created where the data from your SQL statement is stored. When you schedule this to run for example once a day only new records will be added to the table.

The IAL concept has no logic to remove records older than x number of days.

History logging cleanup is only removing history logs nothing else.

Now to your question about how to get only 180 days of data to be shown in IAL.

You can go for option “Copy All Data” and add the 180 days condition in your SQL statement.

Or you can keep it like it is and add a condition on 180 days when you use the IAL.