report for asset stated changed to xxx in last year
Hi there,
basically we need a report that list all the asset that have their Asset State changed to insertCustomState within the past year or something like that.
Normally when we decommission/dispose an asset, either it's too old or broken, we changed the asset state to DISPOSED but not delete it from the record. This way we have a record of what asset(s) we have/had.
And then someone higher up requesting a report on how many IT assets we disposed of in the past year.
We can always create an additional fields on all of our assets called Date of disposal and manually set it every time we dispose an asset.
Problem is, it's a bit too late for that.
Many thanks for your advise.
basically we need a report that list all the asset that have their Asset State changed to insertCustomState within the past year or something like that.
Normally when we decommission/dispose an asset, either it's too old or broken, we changed the asset state to DISPOSED but not delete it from the record. This way we have a record of what asset(s) we have/had.
And then someone higher up requesting a report on how many IT assets we disposed of in the past year.
We can always create an additional fields on all of our assets called Date of disposal and manually set it every time we dispose an asset.
Problem is, it's a bit too late for that.
Many thanks for your advise.