SELECT [ProjectID]DISTINCT p.Name as ProjectName
, dal.[TargetNameDeviceHostname]
, dal.[IPAddressOrHostname]
, dal.[FoundApplicationIDDeviceID]
, dal.[NameFoundApplicationID]
, dal.[TypeApplicationID]
, dal.[Name] as ProductName
,[Vendor] , ,dal.[ApplicationIDStatus]
, dal.[StatusReason]
, dal.[DeviceIDVendor]
, ad.[Name] AS DBName
,[Reason] ad.Owner AS DBOwner
FROM ,[scancount[history].[v_DiagnosticsApplicationList] dal
INNER ,[DeviceHostnameJOIN [config].[t_Project] p ON p.ProjectID = dal.ProjectID
,[TargetBinary] LEFT OUTER FROMJOIN [historymodel].[v_DiagnosticsApplicationList]ApplicationDatabase] ad ON dal.ApplicationID = ad.ApplicationID
WHERE (Type = 'Oracle Database Server' or Type = 'SQL Server')
AND ProjectID = 1(ad.[DatabaseIdent] NOT IN ('master','tempdb','model','msdb'))
|