Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Fu R3 and Earlier

...

Not all the results from the above query will be databases, but any discovered database applications will be listed.

The list of products which can be scanned is found in the table model.t_Product.

Query to list discovered Oracle and SQL Server databases

...

Gwynn R1 and Later


Warning

These queries work with iQSonar releases up to and including Fu R3.

Changes were made to some underlying tables in Gwynn R1 and Gwynn R2 to reduce the amount of history saved as the diagnostic information can grow. In the Gwynn R3 release the option to preserve or delete this diagnostic can be selected in the user interface. Instructions on how to keep the history data can be found on this page.


The following query will list all scanned databases (this example is limited to SQL and Oracle)

...

The user is of course free to add additional products to these lists. The list of products which can be scanned is found in the table model.t_Product.

The following query will give a list of unscanned Oracle Instances and the "reason" we were unable to scan them.


Code Block
languagesql
themeMidnight
titleUnscanned Oracle Instances
SELECT DISTINCT fa.FoundApplicationID
     , d.Hostname
     , faIP.IPAddress
	 , ch.Instance
	 , fap.Port 
	 , fa.Reason as UnscannedReason
FROM model.t_FoundApplication fa
    INNER JOIN model.t_Product prd on prd.ProductID = fa.ProductID
    INNER JOIN model.v_FoundApplicationIPAddress faIP ON faIP.FoundApplicationID = fa.FoundApplicationID
    Inner JOIN model.t_Device d ON d.DeviceID = fa.DeviceID
	JOIN [model].[t_FoundApplicationPort] fap ON fap.FoundApplicationID = fa.FoundApplicationID
	INNER JOIN history.t_ConnectionHistory ch ON fa.FoundApplicationID = ch.FoundApplicationID
WHERE prd.Name =N'Oracle Database Server'
  AND fa.DeviceID IS NOT NULL
  AND fa.ApplicationID IS NULL
ORDER BY FoundApplicationID, Port, UnscannedReason