ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Asset Report from CABI showing destroyed devices
Article ID: 145399
Updated On:
Products
CA Spectrum
DX NetOps
Issue/Introduction
When creating an adhoc report devices that were previously destroyed are showing up in the report
Cause
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 users to report on past data for the device, should they choose to.
Environment
Version: Any
Component: Spectrum Reporting
Resolution
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.
Feedback
Yes
No
Powered by
