Asset Report from CABI showing destroyed devices

book

Article ID: 145399

calendar_today

Updated On:

Products

CA Spectrum CA eHealth

Issue/Introduction

When creating an adhoc report devices that were previously destroyed are showing up in the report

Resolution

Report Manager is a historical database.
Meaning, it will store historical data for devices.

If a device is destroyed we will update the device as destroyed in the reporting database, not remove the entry.
This enables customers to report on past data for the device, should they want to.

The fix for this in adhoc views/reports is to add a filter for destroy_time being blank.
In the database, a NULL value will let us know its an active device.  Any sort of date value indicates the device was destroyed.