Removing database instances that no longer exist

[Philip Hulshize]

We have databases MSSql and Oracle so far, where some of the applications create database instances which later go away. The app owners are clearly not going to keep up with reporting these, and requesting them to be decom/deleted, nor do I want them to need to.

Is there a way that I can have discovery remove these databases if they are not discovered?

I tried to set a deleting strategy but it does not appear to work in removing these.

[Philip Hulshize]

So, I think I found the reason I am not seeing these things delete.
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0993288

The deltas are being calculated only between two consecutive discoveries. So, if now I take the same device X, which was kept in the CMDB based on its deletion strategy, and now I change it to "Delete", it won't be deleted on the next discovery, since it has already been missing from the previous one.

So, the challenge is, I would need to either have a DB admin create a database, and then I create the strategy and then have him delete it to test, or I set this deletion strategy and hope I get it right the first time.