Is there a way to get a list of what databases/instances are running for both MS SQL Server 2000/2005 and/or Oracle 9i/10g?

By default in the Tideway UI under the Infrastructure tab there is a channel called Database Reports which will provide you with instance information for each type of Database selected.

While you will not be able to get both Oracle and MS SQL results on the same report or limit the versions reported to the specific ones you mentioned using these reports, you can filter the results using the “filter” button on the top of each column on the results page.

As you have probably guessed by now, these are just reports built into the UI, and therefore we can write a custom report to be more specific and produce the results exactly as you need them. A starting point for the report maybe along the lines of:

SEARCH SoftwareInstance
WHERE type = “Oracle Database Server”
and (product_version like “9i” or product_version like “10g”)
SHOW type, instance, product_version

Which you can customise as you need.

Let me know if you have any questions arising from this.
Rgds
Nik

Examples of the Database Channel, which dashboard it is on by default and how to create a custom channel are in the Dashboard Howto.

The overall Database Version Channel is here.

There are also examples of product specific dashboards. Apache is documented here and an Oracle one is available by default. Adding further products requires some customisation of the reports but these two existing resources can be used as templates so it is a simple task.