SolarWinds Information Service v3.0 Schema Documentation

Index

DPA.SQLQueryInfo

Base type: System.Entity

Summary: The entity provides the full formatted sql text and custom name for given sqlhash. DatabaseId and Hash are mandatory in where condition.

Properties

Name Type Notes
DatabaseId System.Int32 ID of a monitored instance. References to Orion.DPA.DatabaseInstance.Id
GlobalDatabaseId System.Int32 Unique ID of database instance in Orion
SqlHash System.String SQL Hash
FullSqlText System.String Full formatted SQL text. If text not polled returns 'SQL statement not available'.
SQLName System.String Custom name of SQL. If SQL not named, returns SQL Hash or Oracle SQL Id if supported and collected.
DisplayName System.String
Description System.String
InstanceType System.Type
Uri System.String
InstanceSiteId System.Int32 Default='0'.