Need query to get asset details as mentioned in the summary

Summary:

Hi,

There is an asset which is placed in service in Jan-24.Suppose there is an amount adjustment done in Aug-24 to the asset and in oct-24 life in months adjustment has happened.

WE need a remarks column in the report that gives
"Asset cost changed in Aug-24 to 5000" when I run it for Aug-24 or Sep-24,
"Asset cost changed in Aug-24 to 5000; Asset life changed in oct-24 to 6 months" when run it for oct-24 and above periods.
If run for periods between Jan-24 and Jul-24 then it should be blank as there is no transfer or adjustments happened.