...
The following query will list all scanned databases (this example is limited to SQL and Oracle)
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
SELECT app.ApplicationID
, app.Edition
, app.Version
, dev.Hostname
, apq.Qualifier
, prd.Name as ProductName
, appdb.Name as AppDBName
, appdb.DatabaseIdent
FROM [model].[t_Application] app
INNER JOIN model.v_ApplicationQualifier apq ON app.ApplicationID = apq.ApplicationID
INNER JOIN model.t_Product prd on prd.ProductID = app.ProductID
INNER JOIN model.t__Application_Device apd ON app.ApplicationID = apd.ApplicationID
INNER JOIN model.t_Device dev ON apd.DeviceID = dev.DeviceID
LEFT OUTER JOIN model.v_ApplicationDatabase appdb ON appdb.ApplicationID = app.ApplicationID
WHERE prd.Name in (N'SQL Server',N'Oracle Database Server') |
...