DPA.SQLQueryInfo
SolarWinds Information Service 2020.2 Schema Documentation
The entity provides the full formatted sql text and custom name for given sqlhash. DatabaseId and Hash are mandatory in where condition.
Inheritance
Access control
| Operations | Right |
|---|---|
| read | everyone |
Properties
| Name | Type | Summary | Access Control |
|---|---|---|---|
| DatabaseId | System.Int32 | ID of a monitored instance. References to Orion.DPA.DatabaseInstance.Id | everyone |
| GlobalDatabaseId | System.Int32 | Unique ID of database instance in Orion | everyone |
| SqlHash | System.String | SQL Hash | everyone |
| FullSqlText | System.String | Full formatted SQL text. If text not polled returns 'SQL statement not available'. | everyone |
| SQLName | System.String | Custom name of SQL. If SQL not named, returns SQL Hash or Oracle SQL Id if supported and collected. | everyone |