Database UCMDB

[Aleksandr Gorbunov]

Tell me, is there a table in the database ucmdb that stores information on already deleted CI?

[JohnCI]

No.
many users would like to have a form of Recycle Bin for CIs but we don't have anything like that.
Partially we can see the deleted CIs in the server logs (if they aren't overwritten) and maybe in Reconciliation analyzer.

[ISSC]

A usefull option would be able to see in the history of a CI the delation of a related CI not only for the childreen.

For exemple, be able to see on a CI Type "Node" history the adding or delationing of a BusinessApplication link

[bhaskarbadam]

Hi Aleksandr,

There is a way you can see removed ci's in UCMDB admin-ui console.

Go to reports-->Custom Reports-->Administration-->Auditing Report  and enter the details. Change type should be delete.

Please find attached screenshot for reference. 

In UCMDB Database, This data is queried from History tables.  History tables in DB naming starts with HDM*.

This data contains only global id and no other information is available.

I hope this answers your question.

Regards

Bhaskar Badam

[Aleksandr Gorbunov]

Thank you very much. Your recommendations helped me a lot.