Aging reports queries
I have turned on the aging in ucmdb, I am keeping track of CI's which are candidates for deletion. I have two questions.
1. I am unable to pull out a report since the CI's are huge and I have to break them into hourly basis. Is there any other way to pull out reports.
2. How do I pull out a report which gives me the list of CI's deleted. From the custom delete candidate report I can just see numbers.
Re: Aging reports queries
You can create report based on the isCandidateForDeletion attribute = true. In the TQL you can do whatever conditions and groupings you want, not only numbers. The deletion will happen 40 days of LastAccessTime being unchanged, so you can fill down the datetime comparison operators and easily see what will be going on in the next days with the system data.
To get which CIs are actually deleted is almost impossible from UCMDB (There is the History Change CI federation, but I wouldn't put a lot of trust on it). Eventually you can use SQL statements to the history tables in the database.