How to filter out the destroyed model from the Ad Hoc custom Asset report

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

The Ad Hoc custom Asset report is including the destroyed models.

How to exclude the device with destroy_time is not NULL?

Environment

Release : 21.2

Component : Spectrum Reporting

Resolution

Use the IsNull calculated measure.

 

1. Create an Ad Hoc custom Asset report

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.