The Ad Hoc custom Asset report is including the destroyed models.
How to exclude the device with destroy_time is not NULL?
Release : 21.2
Component : Spectrum Reporting
2. Create the Calculated Measure
3. The formula should be: IsNull("Destroy Time") and validate it before creating the measure.
4. Create a filter based on the calculated measure created.
5. Set the Destroy Time isNULL filter to true.