To clarify, you would like to get a list of all Servers that run Oracle databases. A Server is not a Database. So what you are really looking for is a query that looks for the relationships between a Server and a Database CI. There are two methods for this:
1) Create a list or report against the CI Relationship table (cmdb_rel_ci) and filter the data based on the Relationship Type and the Parent and Child CIs. For example: Child.Class is a Server and Parent.Class is a Oracle Instance and Relationship Type is "Runs On". Adjust the filter criteria to suit your needs and then display the desired columns from the Child CI, i.e. the Server.
2) Create a new query in CMDB Query Builder. This one might look fancier and more appealing, and it just might work. But it can also be confusing to get it to work right, and from what I have seen it is broken in Tokyo. The other down side is that you can't use this as a source of a Report. So this might not be what you are looking for anyway.
If this helped you please mark this as Helpful, or Accept Solution.
The opinions expressed here are the opinions of the author, and are not endorsed by ServiceNow or any other employer, company, or entity.
