/AWS1/CL_PIEINSIGHT

Retrieves the list of performance issues which are identified.

CONSTRUCTOR

IMPORTING

Required arguments:

iv_insightid TYPE /AWS1/PIESTRING /AWS1/PIESTRING

The unique identifier for the insight. For example, insight-12345678901234567.

Optional arguments:

iv_insighttype TYPE /AWS1/PIESTRING /AWS1/PIESTRING

The type of insight. For example, HighDBLoad, HighCPU, or DominatingSQLs.

iv_context TYPE /AWS1/PIECONTEXTTYPE /AWS1/PIECONTEXTTYPE

Indicates if the insight is causal or correlated insight.

iv_starttime TYPE /AWS1/PIEISOTIMESTAMP /AWS1/PIEISOTIMESTAMP

The start time of the insight. For example, 2018-10-30T00:00:00Z.

iv_endtime TYPE /AWS1/PIEISOTIMESTAMP /AWS1/PIEISOTIMESTAMP

The end time of the insight. For example, 2018-10-30T00:00:00Z.

iv_severity TYPE /AWS1/PIESEVERITY /AWS1/PIESEVERITY

The severity of the insight. The values are: Low, Medium, or High.

it_supportinginsights TYPE /AWS1/CL_PIEINSIGHT=>TT_INSIGHTLIST TT_INSIGHTLIST

List of supporting insights that provide additional factors for the insight.

iv_description TYPE /AWS1/PIEMARKDOWNSTRING /AWS1/PIEMARKDOWNSTRING

Description of the insight. For example: A high severity Insight found between 02:00 to 02:30, where there was an unusually high DB load 600x above baseline. Likely performance impact.

it_recommendations TYPE /AWS1/CL_PIERECOMMENDATION=>TT_RECOMMENDATIONLIST TT_RECOMMENDATIONLIST

List of recommendations for the insight. For example, Investigate the following SQLs that contributed to 100% of the total DBLoad during that time period: sql-id.

it_insightdata TYPE /AWS1/CL_PIEDATA=>TT_DATALIST TT_DATALIST

List of data objects containing metrics and references from the time range while generating the insight.

it_baselinedata TYPE /AWS1/CL_PIEDATA=>TT_DATALIST TT_DATALIST

Metric names and values from the timeframe used as baseline to generate the insight.

---

Queryable Attributes

InsightId

The unique identifier for the insight. For example, insight-12345678901234567.

Accessible with the following methods

Method	Description
GET_INSIGHTID()	Getter for INSIGHTID, with configurable default
ASK_INSIGHTID()	Getter for INSIGHTID w/ exceptions if field has no value
HAS_INSIGHTID()	Determine if INSIGHTID has a value

InsightType

The type of insight. For example, HighDBLoad, HighCPU, or DominatingSQLs.

Accessible with the following methods

Method	Description
GET_INSIGHTTYPE()	Getter for INSIGHTTYPE, with configurable default
ASK_INSIGHTTYPE()	Getter for INSIGHTTYPE w/ exceptions if field has no value
HAS_INSIGHTTYPE()	Determine if INSIGHTTYPE has a value

Context

Indicates if the insight is causal or correlated insight.

Accessible with the following methods

Method	Description
GET_CONTEXT()	Getter for CONTEXT, with configurable default
ASK_CONTEXT()	Getter for CONTEXT w/ exceptions if field has no value
HAS_CONTEXT()	Determine if CONTEXT has a value

StartTime

The start time of the insight. For example, 2018-10-30T00:00:00Z.

Accessible with the following methods

Method	Description
GET_STARTTIME()	Getter for STARTTIME, with configurable default
ASK_STARTTIME()	Getter for STARTTIME w/ exceptions if field has no value
HAS_STARTTIME()	Determine if STARTTIME has a value

EndTime

The end time of the insight. For example, 2018-10-30T00:00:00Z.

Accessible with the following methods

Method	Description
GET_ENDTIME()	Getter for ENDTIME, with configurable default
ASK_ENDTIME()	Getter for ENDTIME w/ exceptions if field has no value
HAS_ENDTIME()	Determine if ENDTIME has a value

Severity

The severity of the insight. The values are: Low, Medium, or High.

Accessible with the following methods

Method	Description
GET_SEVERITY()	Getter for SEVERITY, with configurable default
ASK_SEVERITY()	Getter for SEVERITY w/ exceptions if field has no value
HAS_SEVERITY()	Determine if SEVERITY has a value

SupportingInsights

List of supporting insights that provide additional factors for the insight.

Accessible with the following methods

Method	Description
GET_SUPPORTINGINSIGHTS()	Getter for SUPPORTINGINSIGHTS, with configurable default
ASK_SUPPORTINGINSIGHTS()	Getter for SUPPORTINGINSIGHTS w/ exceptions if field has no
HAS_SUPPORTINGINSIGHTS()	Determine if SUPPORTINGINSIGHTS has a value

Description

Description of the insight. For example: A high severity Insight found between 02:00 to 02:30, where there was an unusually high DB load 600x above baseline. Likely performance impact.

Accessible with the following methods

Method	Description
GET_DESCRIPTION()	Getter for DESCRIPTION, with configurable default
ASK_DESCRIPTION()	Getter for DESCRIPTION w/ exceptions if field has no value
HAS_DESCRIPTION()	Determine if DESCRIPTION has a value

Recommendations

List of recommendations for the insight. For example, Investigate the following SQLs that contributed to 100% of the total DBLoad during that time period: sql-id.

Accessible with the following methods

Method	Description
GET_RECOMMENDATIONS()	Getter for RECOMMENDATIONS, with configurable default
ASK_RECOMMENDATIONS()	Getter for RECOMMENDATIONS w/ exceptions if field has no val
HAS_RECOMMENDATIONS()	Determine if RECOMMENDATIONS has a value

InsightData

List of data objects containing metrics and references from the time range while generating the insight.

Accessible with the following methods

Method	Description
GET_INSIGHTDATA()	Getter for INSIGHTDATA, with configurable default
ASK_INSIGHTDATA()	Getter for INSIGHTDATA w/ exceptions if field has no value
HAS_INSIGHTDATA()	Determine if INSIGHTDATA has a value

BaselineData

Metric names and values from the timeframe used as baseline to generate the insight.

Accessible with the following methods

Method	Description
GET_BASELINEDATA()	Getter for BASELINEDATA, with configurable default
ASK_BASELINEDATA()	Getter for BASELINEDATA w/ exceptions if field has no value
HAS_BASELINEDATA()	Determine if BASELINEDATA has a value

Public Local Types In This Class

Internal table types, representing arrays and maps of this class, are defined as local types:

TT_INSIGHTLIST

TYPES TT_INSIGHTLIST TYPE STANDARD TABLE OF REF TO /AWS1/CL_PIEINSIGHT WITH DEFAULT KEY
.