We've a report scheduled daily and when i look at the result i'm finding deleted equipment.
Take a look below. When i look at report manager web page in OneClick i'm still finding the deleted device.
But at oneclick i can't find it.
How can i avoid it in the further?
In what kind of report are you getting the destroyed models? Is it a canned report? Is it an Ad Hoc report using Web Intelligence?
What are you querying in the reporting database to get destroyed models?
I'm using a custom report from Spectrum AdHoc with Web Intelligence documment.
We're running the report below:
--> Availability / Outage
-> Start Time;
-> End Time;
-> Outage Duration (HH:MM:SS);
-> Model Name;
The filters used are:
Model Class = Workstation Server;
Report Manager is a historical reporting tool by design.
Our "current" reports will not show destroyed devices.
When we destroy a device in Report Manager we simply update a column to have a destroyed_time. Otherwise, its value is NULL.
So you will need to add "Active Devices" filter if you are running an asset type report in WEBI.
From the latest screenshot it appears to be availability though.
So you can drag over "destroyed_time" to the filters, and change the type from "in list" to "is Null".
like Matthew explained.
In the database, all old devices are stored - but marked with a destroy date.
Therefore You have to filter the devices.
If You use the filters and the device is still reported, then check the amount of bucketfiles? Probably the database is not up to date.
The update of the inventory in the SRM-DB runs only once daily. ... if You delete a device, you could run reports for it at the same date.
If You are able to check the datasource via mySQL you will find the table for devicemodels.
.. show tables like '%device%'; ..
then use desc "tablename" ..
then You should be able to build a query to fetch exactly this record.... and You will (hopefully) find a column with the destroy - date or destroy-flag.