Data Dictionary
There are two types of data sources reported by Open Canvas: Cases data source and Azure events data. There are three instances where these data fields can be found and below, you can see the fields defined and how they related to each instance.
Cases Data Source
Visuals
Field Display Name | Axis | Value | Legend | OrderBy | Data Example | Data Definition |
---|---|---|---|---|---|---|
RequestId | ✔️ | ✔️ | 211220006000XXXX | Support Request (SR) ID | ||
State | ✔️ | ✔️ | ✔️ | Open | SR open/closed state | |
Status | ✔️ | ✔️ | ✔️ | Duplicate, Disconnect, Initial Contact Pending, Request to Revolve, Resolved, Resolved by Customer, Transferred from External, Troubleshooting, Un-Resovled | The state of an active case. | |
InitialSeverity | ✔️ | ✔️ | ✔️ | 4 | SR severity set by the support request submitter Severity values in the data source are 1-4, and the Severity Name fields map those values to the Unified Enterprises offering's severity names. 1. = "1 - Critical business system down" 2. = "A Critical business system degraded" 3. = "B - Moderate business impact" 4. = "C - Minor business impact" |
|
InitialSeverityName | ✔️ | ✔️ | ✔️ | C - Minor Business impact | SR severity set by the support request submitter | |
Severity | ✔️ | ✔️ | ✔️ | 3 | Current severity of the SR. Severity values in the data source are 1-4, and the Severity Name fields map those values to the Unified Enterprises offering's severity names. 1. = "1 - Critical business system down" 2. = "A Critical business system degraded" 3. = "B - Moderate business impact" 4. = "C - Minor business impact" |
|
CurrentSeverity | ✔️ | ✔️ | ✔️ | B - Moderate Business impact | Current severity of the SR | |
MaxSeverity | ✔️ | ✔️ | ✔️ | 2 | Highest severity assigned to the SR during its lifecycle. | |
MaxSeverityName | ✔️ | ✔️ | ✔️ | A - Critical business system degraded | Highest severity assigned to the SR during its lifecycle. Severity values in the data source are 1-4, and the Severity Name fields map those values to the Unified Enterprise offering’s severity names. 1. = "1 - Critical business system down" 2. = "A Critical business system degraded" 3. = "B - Moderate business impact" 4. = "C - Minor business impact" |
|
IsCritSit | ✔️ | ✔️ | TRUE | Flag that SR has a Critical Situation (CritSit) severity (Sev1 or SevA) | ||
Country | ✔️ | ✔️ | ✔️ | United States | Country/region of the support request submitter | |
Product | ✔️ | ✔️ | ✔️ | Virtual Machine Scale Sets | The Microsoft product the SR is related to | |
ProductFamily | ✔️ | ✔️ | ✔️ | Azure | A grouping of related Microsoft products | |
Cloud | ✔️ | ✔️ | ✔️ | Azure | Simplified groupings of related Microsoft products (Azure, D365, M365, Onprem or Others) | |
Created | ✔️ | ✔️ | ✔️ | 12/14/2021 09:55:09 | SR created timestamp | |
Closed | ✔️ | ✔️ | ✔️ | 1/7/2022 22:52 | SR closed timestamp | |
LastEmailInteraction | ✔️ | 12/14/2021 09:55:09 | Last SR email interaction timestamp | |||
CreatedYear | ✔️ | ✔️ | ✔️ | 2021 | Calendar year from the Created timestamp | |
CreatedMonth | ✔️ | ✔️ | ✔️ | May | Calendar month from the Created timestamp | |
CreatedDay | ✔️ | ✔️ | ✔️ | Thu | Day of the week from the Created timestamp | |
CreatedHour | ✔️ | ✔️ | ✔️ | 9:00 | Hour of the day from the Created timestamp | |
ImpactStartMonth | ✔️ | ✔️ | ✔️ | 2021-06 | Calendar month from the Created timestamp (used to create month-to-months visuals) | |
DaysOpen | ✔️ | ✔️ | 4.84 | Number of days SR has been open | ||
DaysWithoutContact | ✔️ | ✔️ | 1.03 | Time (days) since last email communication from Microsoft Support | ||
DaysToResolution | ✔️ | ✔️ | 5.68 | Time (days) from support request creation to resolution | ||
CritElapsedTime | ✔️ | ✔️ | Time a support request has been in a CritSit severity | |||
ReopenedCount | ✔️ | ✔️ | ✔️ | ✔️ | 0 | Number of times a SR was closed and then reopened |
SubscriptionId | ✔️ | ✔️ | ✔️ | ✔️ | 11cf11de-11b1-b11a-111d1fd1111 | Azure Subscription ID |
PackageId | ✔️ | ✔️ | ✔️ | ✔️ | 158111111 | Agreement's package ID that the SR is entitled against |
Grids
Field Display Name | OrderBy | Select | Data Example | Data Definition |
---|---|---|---|---|
RequestId | ✔️ | ✔️ | 211220006000XXXX | Support Request (SR) ID |
State | ✔️ | ✔️ | Open | SR open/cloased state |
Status | ✔️ | ✔️ | Duplicate, Disconnect, Initial Contact Pending, Request to Revolve, Resolved, Resolved by Customer, Transferred from External, Troubleshooting, Un-Resovled | The state of an active case. |
InitialSeverity | ✔️ | ✔️ | 4 | SR severity set by the support request submitter Severity values in the data source are 1-4, and the Severity Name fields map those values to the Unified Enterprises offering's severity names. 1. = "1 - Critical business system down" 2. = "A Critical business system degraded" 3. = "B - Moderate business impact" 4. = "C - Minor business impact" |
InitialSeverityName | ✔️ | ✔️ | C - Minor business impact | SR severity set by the support request submitter |
Severity | ✔️ | ✔️ | 3 | Current severity of the SR. Severity values in the data source are 1-4, and the Severity Name fields map those values to the Unified Enterprises offering's severity names. 1. = "1 - Critical business system down" 2. = "A Critical business system degraded" 3. = "B - Moderate business impact" 4. = "C - Minor business impact" |
CurrentSeverity | ✔️ | ✔️ | B - Moderate business impact | Current severity of the SR |
MaxSeverity | ✔️ | ✔️ | 2 | Highest severity assigned to the SR during its lifecycle |
MaxSeverityName | ✔️ | ✔️ | A - Critical business system degraded | Highest severity assigned to the SR during its lifecycle. Severity values in the data source are 1-4, and the Severity Name fields map those values to the Unified Enterprises offering's severity names. 1. = "1 - Critical business system down" 2. = "A Critical business system degraded" 3. = "B - Moderate business impact" 4. = "C - Minor business impact" |
IsCritSit | ✔️ | ✔️ | TRUE | Flag that SR has a Critical Situation (CritSit) severity (Sev1 or SevA) |
Country | ✔️ | ✔️ | United States | Country/region of the support request submitter |
Product | ✔️ | ✔️ | Virtual Machine Scale Sets | |
ProductFamily | ✔️ | ✔️ | Azure | A grouping of related Microsoft products |
Cloud | ✔️ | ✔️ | Azure | Simplified groupings of related Microsoft products (Azure, D365, M365, Onprem or Others) |
Created | ✔️ | ✔️ | 12/14/2021 09:55:09 | SR created timestamp |
Closed | ✔️ | ✔️ | 1/7/2022 22:52 | SR closed timestamp |
LastEmailInteraction | ✔️ | ✔️ | 12/14/2021 09:55:09 | Last SR email interaction timestamp |
CreatedYear | ✔️ | ✔️ | 2021 | Calendar year from the Created timestamp |
CreatedMonth | ✔️ | ✔️ | May | Calendar month from the Created timestamp |
CreatedDay | ✔️ | ✔️ | Thu | Day of the week from the Created timestamp |
CreatedHour | ✔️ | ✔️ | 9:00 | Hour of the day from the Created timestamp |
ImpactStartMonth | ✔️ | 2021-06 | Calendar month from the Created timestamp (used to create month-to-months visuals) | |
DaysOpen | ✔️ | ✔️ | 4.84 | Number of days SR has been open |
DaysWithoutContact | ✔️ | ✔️ | 1.03 | Time (days) since last email communication from Microsft Support |
DaysToResolution | ✔️ | ✔️ | 5.68 | Time (days) from support request creation to resolution |
CritElapsedTime | ✔️ | ✔️ | Time a support request has been in a CritSit severity | |
ReopenedCount | ✔️ | ✔️ | 0 | |
SubscriptionId | ✔️ | ✔️ | 11cf11de-11b1-b11a-111d1fd1111 | Azure Subscription ID |
PackageId | ✔️ | ✔️ | 158111111 | Agreement's package ID that the SR is entitled against |
Case Title | ✔️ | ✔️ | SQL Server performance issue | The title of the case with PII redactions |
Case Type | ✔️ | ✔️ | Advisory/Incident | Defines the nature of the case, whether a problem/incident or advisory |
Is associated with Service Impacting Event | ✔️ | ✔️ | True/False | Defines whether a case has been tagged as associated with a known cloud service impacting event |
Support Topic | ✔️ | ✔️ | Azure App Configuration | The third level down in the support area path beyond Product Family and Product |
Tenant ID | ✔️ | ✔️ | x0xxx10-00x0-0x01-0xxx-x0x0x01xx100 | The case is associated with this Tenant ID |
Filters
Field Display Name | Filter | Data Example | Data Definition |
---|---|---|---|
RequestId | 211220006000XXXX | Support Request (SR) ID | |
State | ✔️ | Open | SR open/closed state |
Status | ✔️ | Duplicate, Disconnect, Initial Contact Pending, Request to Revolve, Resolved, Resolved by Customer, Transferred from External, Troubleshooting, Un-Resovled. | The state of an active case. |
InitialSeverity | ✔️ | 4 | SR severity set by the support request submitter Severity values in the data source are 1-4, and the Severity Name fields map those values to the Unified Enterprises offering's severity names. 1. = "1 - Critical business system down" 2. = "A Critical business system degraded" 3. = "B - Moderate business impact" 4. = "C - Minor business impact" |
InitialSeverityName | C - Minor Business impact | SR severity set by the support request submitter | |
Severity | ✔️ | 3 | Current severity of the SR |
CurrentSeverity | B - Moderate Business impact | Current severity of the SR. Severity values in the data source are 1-4, and the Severity Name fields map those values to the Unified Enterprise offering’s severity names. 1. = "1 - Critical business system down" 2. = "A Critical business system degraded" 3. = "B - Moderate business impact" 4. = "C - Minor business impact" |
|
MaxSeverity | ✔️ | 2 | Highest severity assigned to the SR during its lifecycle. |
MaxSeverityName | A - Critical business system degraded | Highest severity assigned to the SR during its lifecycle. Severity values in the data source are 1-4, and the Severity Name fields map those values to the Unified Enterprise offering’s severity names. 1. = "1 - Critical business system down" 2. = "A Critical business system degraded" 3. = "B - Moderate business impact" 4. = "C - Minor business impact" |
|
IsCritSit | TRUE | Flag that SR has a Critical Situation (CritSit) severity (Sev1 or SevA) | |
Country | ✔️ | United States | Country/region of the support request submitter |
Product | ✔️ | Virtual Machine Scale Sets | |
ProductFamily | ✔️ | Azure | A grouping of related Microsoft products |
Cloud | ✔️ | Azure | Simplified groupings of related Microsoft products (Azure, D365, M365, Onprem or Others) |
Created | 12/14/2021 09:55:09 | SR created timestamp | |
Closed | 1/7/2022 22:52 | SR closed timestamp | |
LastEmailInteraction | 12/14/2021 09:55:09 | Last SR email interaction timestamp | |
CreatedYear | 2021 | Calendar year from the Created timestamp | |
CreatedMonth | May | Calendar month from the Created timestamp | |
CreatedDay | Thu | Day of the week from the Created timestamp | |
CreatedHour | 9:00 | Hour of the day from the Created timestamp | |
ImpactStartMonth | 2021-06 | Calendar month from the Created timestamp (used to create month-to-months visuals) | |
DaysOpen | ✔️ | 4.84 | Number of days SR has been open |
DaysWithoutContact | ✔️ | 1.03 | Time (days) since last email communication from Microsoft Support |
DaysToResolution | 5.68 | Time (days) from support request creation to resolution | |
CritElapsedTime | Time a support request has been in a CritSit severity | ||
ReopenedCount | 0 | ||
SubscriptionId | 11cf11de-11b1-b11a-111d1fd1111 | Azure Subscription ID | |
PackageId | 158111111 | Agreement's package ID that the SR is entitled against | |
Case Title | ✔️ | SQL Server performance issue | The title of the support request with PII redactions |
Case Type | ✔️ | Advisory/Incident | Defines the nature of the case whether a problem/incident or advisory |
Is associated with Service Impacting Event | ✔️ | True/False | Defines whether a case has been tagged as associated with a known cloud service impacting event |
Support Topic | ✔️ | Azure App Configuration | The third level down in the support area path beyond Product Family and Product |
Tenant ID | ✔️ | x0xxx10-00x0-0x01-0xxx-x0x0x01xx100 | The case is associated with this Tenant ID |
Azure Events Data Source
Visuals
Field Display Name | Axis | Value | Legend | OrderBy | Data Example |
---|---|---|---|---|---|
TrackingId | ✔️ | ✔️ | 9MCT-XXX | ||
Id | /subscriptions/d8f9e0d3-7XXX-4a40-a4f0-XXXXXXXXXXXX/providers/Microsoft.ResourceHealth/events/DXXX-XXX | ||||
Title | ✔️ | SQL Server IaaS Extension Registration for Windows | |||
EventType | ✔️ | ✔️ | ✔️ | ✔️ | PlannedMaintenance |
ImpactStartDate | ✔️ | 2/15/2022 10:29:39 PM | |||
ImpactStartDay | ✔️ | ✔️ | ✔️ | Mon | |
ImpactStartMonth | ✔️ | ✔️ | ✔️ | 2022-02 | |
ImpactStartYear | ✔️ | ✔️ | ✔️ | 2022 | |
ImpactMitigationDate | ✔️ | 2/20/2022 12:00:00 AM | |||
Status | ✔️ | ✔️ | ✔️ | Active | |
Priority | ✔️ | ✔️ | 20 | ||
ExternalIncidentId | 2881XXXXX | ||||
Level | ✔️ | ✔️ | ✔️ | Warning | |
EventLevel | ✔️ | ✔️ | ✔️ | Informational | |
PlatformInitiated | ✔️ | ✔️ | ✔️ | True | |
Header | Your service might have been impacted by an Azure service issue | ||||
EventSource | ✔️ | ✔️ | ✔️ | ServiceHealth | |
ImpactedRegions | ✔️ | ✔️ | 1 | ||
ImpactedRegion | ✔️ | ✔️ | ✔️ | Global | |
ImpactedService | ✔️ | ✔️ | ✔️ | Virtual Machines | |
DaysToResolution | ✔️ | ✔️ | 30 | ||
MinutesToResolution | ✔️ | ✔️ | 43200 | ||
EventDate | ✔️ | 2/20/2022 3:12:06 AM | |||
ImpactedSubscriptionCount | ✔️ | ✔️ | 4 | ||
ImpactedSubscriptions | ✔️ | ✔️ | 0XXXXe10-ceaX-XXa1-XXXc-f102bdXXXXXX, etc. | ||
ImpactedSubscriptionDisplay | ✔️ | ✔️ | 0XXXXe10-ceaX-XXa1-XXXc-f102bdXXXXXX, etc. |
Grids
Field Display Name | OrderBy | Select | Data Example |
---|---|---|---|
TrackingId | ✔️ | ✔️ | 9MCT-XXX |
Id | ✔️ | /subscriptions/d8f9e0d3-7XXX-4a40-a4f0-XXXXXXXXXXXX/providers/Microsoft.ResourceHealth/events/DXXX-XXX | |
Title | ✔️ | ✔️ | SQL Server IaaS Extension Registration for Windows |
EventType | ✔️ | ✔️ | PlannedMaintenance |
ImpactStartDate | ✔️ | ✔️ | 2/15/2022 10:29:39 PM |
ImpactStartDay | ✔️ | ✔️ | Mon |
ImpactStartMonth | ✔️ | ✔️ | 2022-02 |
ImpactStartYear | ✔️ | ✔️ | 2022 |
ImpactMitigationDate | ✔️ | ✔️ | 2/20/2022 12:00:00 AM |
Status | ✔️ | ✔️ | Active |
Priority | ✔️ | ✔️ | 20 |
ExternalIncidentId | ✔️ | 2881XXXXX | |
Level | ✔️ | ✔️ | Warning |
EventLevel | ✔️ | ✔️ | Informational |
PlatformInitiated | ✔️ | ✔️ | True |
Header | ✔️ | Your service might have been impacted by an Azure service issue | |
EventSource | ✔️ | ✔️ | ServiceHealth |
ImpactedRegions | ✔️ | ✔️ | 1 |
ImpactedRegion | ✔️ | ✔️ | Global |
ImpactedService | ✔️ | ✔️ | Virtual Machines |
DaysToResolution | ✔️ | ✔️ | 30 |
MinutesToResolution | ✔️ | ✔️ | 43200 |
EventDate | ✔️ | ✔️ | 2/20/2022 3:12:06 AM |
ImpactedSubscriptionCount | ✔️ | ✔️ | 4 |
ImpactedSubscriptions | ✔️ | ✔️ | 0XXXXe10-ceaX-XXa1-XXXc-f102bdXXXXXX, etc. |
ImpactedSubscriptionDisplay | ✔️ | ✔️ | 0XXXXe10-ceaX-XXa1-XXXc-f102bdXXXXXX, etc. |
Filters
Field Display Name | Filter | Data Example |
---|---|---|
TrackingId | ✔️ | 9MCT-XXX |
Id | /subscriptions/d8f9e0d3-7XXX-4a40-a4f0-XXXXXXXXXXXX/providers/Microsoft.ResourceHealth/events/DXXX-XXX | |
Title | SQL Server IaaS Extension Registration for Windows | |
EventType | ✔️ | PlannedMaintenance |
ImpactStartDate | 2/15/2022 10:29:39 PM | |
ImpactStartDay | ✔️ | Mon |
ImpactStartMonth | ✔️ | 2022-02 |
ImpactStartYear | ✔️ | 2022 |
ImpactMitigationDate | 2/20/2022 12:00:00 AM | |
Status | ✔️ | Active |
Priority | ✔️ | 20 |
ExternalIncidentId | 2881XXXXX | |
Level | ✔️ | Warning |
EventLevel | ✔️ | Informational |
PlatformInitiated | True | |
Header | Your service might have been impacted by an Azure service issue | |
EventSource | ✔️ | ServiceHealth |
ImpactedRegions | 1 | |
ImpactedRegion | ✔️ | Global |
ImpactedService | ✔️ | Virtual Machines |
DaysToResolution | 30 | |
MinutesToResolution | 43200 | |
EventDate | ✔️ | 2/20/2022 3:12:06 AM |
ImpactedSubscriptionCount | ✔️ | 4 |
ImpactedSubscriptions | ✔️ | 0XXXXe10-ceaX-XXa1-XXXc-f102bdXXXXXX, etc. |
ImpactedSubscriptionDisplay | ✔️ | 0XXXXe10-ceaX-XXa1-XXXc-f102bdXXXXXX, etc. |