List all discovered databases

The following query will list all discovered databases, and show whether or not they are fully scanned

Note, to find a list of valid database types in your environment you can use the following query:

SELECT DISTINCT Type FROM [history].[v_DiagnosticsApplicationList]

Query to list discovered databases

List Databases

SELECT [ProjectID]
      ,[TargetName]
      ,[IPAddressOrHostname]
      ,[FoundApplicationID]
      ,[Name]
      ,[Type]
      ,[Vendor]
      ,[ApplicationID]
      ,[Status]
      ,[DeviceID]
      ,[Reason]
      ,[scancount]
      ,[DeviceHostname]
      ,[TargetBinary]
  FROM [history].[v_DiagnosticsApplicationList]
  WHERE (Type = 'Oracle Database Server' or Type = 'SQL Server')
    AND ProjectID = 1