...
| Code Block |
|---|
| language | sql |
|---|
| theme | Confluence |
|---|
|
SELECT DISTINCT Connection FROM [history].[t_ConnectionHistory] |
The following queries will enable you to investigate database connection issues:
Note that the "Type" column is the Application Type, which is not the same as the Connection type in most of the other queries on this page. You can get a list of valid types in your environment with the following query:
| Code Block |
|---|
| language | sql |
|---|
| theme | Confluence |
|---|
|
SELECT DISTINCT Type FROM [history].[v_DiagnosticsApplicationList] |
| Code Block |
|---|
| language | sql |
|---|
| theme | Midnight |
|---|
| title | Database Info |
|---|
|
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'
|
...