Report on Decommissioned CIs

[wendith]

I want to create a report on the number of CI's that were decommissioned during a certain time period.

I have created a report for CIs created using the cmdb_ci table and using Created to filter on the desired date range.  

There doesn't seem to be a similar field for decommissioned or retired.

I am looking to capture CIs created by any means (manually or discovered).   Does anyone have any suggestions?

Thanks in advance!

W.

[Michael Fry1]

Most of use Status field as you found Active doesn't exist. It depends on your process as to what you use to signify decommissioned.

[andrewpilachows]

If your process is using asset management, there's a table that controls the status mapping between Asset and CI, which both have a Retired status OOB.   Also I don't think you want the created date, as you would be looking for CIs that have been created AND retired within the past year which seems unlikely.   May want to change that to updated date, but if the record keeps getting updated that will still be inaccurate.   You may need to add a custom field Decommission Date and a business rule when state changes to Retired, set Decommission Date to current datetime.