Fu R3 and Earlier
The following query will list all discovered databases, and show whether or not they are fully scanned
...
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
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
SELECT DISTINCT p.Name as ProjectName
, dal.[DeviceHostname]
, dal.[IPAddressOrHostname]
, dal.[DeviceID]
, dal.[FoundApplicationID]
, dal.[ApplicationID]
, dal.[Name] as ProductName
, dal.[Status]
, dal.[Reason]
, dal.[Vendor]
, ad.[Name] AS DBName
, ad.Owner AS DBOwner
FROM [history].[v_DiagnosticsApplicationList] dal
INNER JOIN [config].[t_Project] p ON p.ProjectID = dal.ProjectID
LEFT OUTER JOIN [model].[v_ApplicationDatabase] ad ON dal.ApplicationID = ad.ApplicationID
WHERE (Type = 'Oracle Database Server' or Type = 'SQL Server')
AND (ad.[DatabaseIdent] NOT IN ('master','tempdb','model','msdb'))
|
...