Create Incident for XDR Alerts
| Id | 0febd8cc-1b8d-45ed-87b3-e1e8a57d14cd |
| Rulename | Create Incident for XDR Alerts |
| Description | This Query creates an incident based on Trend Vision One Workbench Alerts and maps the impacted entities for Microsoft Sentinel usage. |
| Severity | High |
| Required data connectors | TrendMicroXDR |
| Kind | Scheduled |
| Query frequency | 5m |
| Query period | 5m |
| Trigger threshold | 0 |
| Trigger operator | gt |
| Source Uri | https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Trend Micro Vision One/Analytic Rules/Create Incident for XDR Alerts.yaml |
| Version | 1.0.4 |
| Arm template | 0febd8cc-1b8d-45ed-87b3-e1e8a57d14cd.json |
TrendMicro_XDR_WORKBENCH_CL
| extend Severity = case(severity_s == "low", "Informational",
severity_s == "medium", "Low",
severity_s == "high", "Medium",
"High"
)
| extend
UserAccountName_s = todynamic(column_ifexists("UserAccountName_s", "[]")),
UserAccountNTDomain_s = todynamic(column_ifexists("UserAccountNTDomain_s", "[]")),
FileName_s = todynamic(column_ifexists("FileName_s", "[]")),
FileDirectory_s = todynamic(column_ifexists("FileDirectory_s", "[]")),
ProcessCommandLine_s = todynamic(column_ifexists("ProcessCommandLine_s", "[]")),
RegistryKey_s = todynamic(column_ifexists("RegistryKey_s", "[]")),
RegistryValue_s = todynamic(column_ifexists("RegistryValue_s", "[]")),
RegistryValueName_s = todynamic(column_ifexists("RegistryValueName_s", "[]"))
query: |
TrendMicro_XDR_WORKBENCH_CL
| extend Severity = case(severity_s == "low", "Informational",
severity_s == "medium", "Low",
severity_s == "high", "Medium",
"High"
)
| extend
UserAccountName_s = todynamic(column_ifexists("UserAccountName_s", "[]")),
UserAccountNTDomain_s = todynamic(column_ifexists("UserAccountNTDomain_s", "[]")),
FileName_s = todynamic(column_ifexists("FileName_s", "[]")),
FileDirectory_s = todynamic(column_ifexists("FileDirectory_s", "[]")),
ProcessCommandLine_s = todynamic(column_ifexists("ProcessCommandLine_s", "[]")),
RegistryKey_s = todynamic(column_ifexists("RegistryKey_s", "[]")),
RegistryValue_s = todynamic(column_ifexists("RegistryValue_s", "[]")),
RegistryValueName_s = todynamic(column_ifexists("RegistryValueName_s", "[]"))
queryPeriod: 5m
queryFrequency: 5m
alertRuleTemplateName:
status: Available
id: 0febd8cc-1b8d-45ed-87b3-e1e8a57d14cd
entityMappings:
- entityType: Account
fieldMappings:
- columnName: UserAccountName_s
identifier: Name
- columnName: UserAccountNTDomain_s
identifier: NTDomain
- entityType: File
fieldMappings:
- columnName: FileName_s
identifier: Name
- columnName: FileDirectory_s
identifier: Directory
- entityType: Process
fieldMappings:
- columnName: ProcessCommandLine_s
identifier: CommandLine
- entityType: RegistryKey
fieldMappings:
- columnName: RegistryKey_s
identifier: Key
- entityType: RegistryValue
fieldMappings:
- columnName: ProcessCommandLine_s
identifier: Name
- columnName: RegistryValue_s
identifier: Value
customDetails:
ImpactScopeSummary: impactScope_Summary_s
WorkbenchLink: workbenchLink_s
WorkbenchName: workbenchName_s
PriorityScore: priorityScore_d
XDRCustomerID: xdrCustomerID_g
CreatedAt: createdTime_t
Provider: alertProvider_s
WorkbenchID: workbenchId_s
Severity: severity_s
relevantTechniques:
suppressionEnabled: false
suppressionDuration: 5h
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Trend Micro Vision One/Analytic Rules/Create Incident for XDR Alerts.yaml
requiredDataConnectors:
- connectorId: TrendMicroXDR
dataTypes:
- TrendMicro_XDR_WORKBENCH_CL
eventGroupingSettings:
aggregationKind: AlertPerResult
alertDetailsOverride:
alertSeverityColumnName: Severity
alertDisplayNameFormat: '{{workbenchName_s}}'
alertDescriptionFormat: '{{description_s}}'
incidentConfiguration:
createIncident: true
groupingConfiguration:
enabled: true
lookbackDuration: 5m
reopenClosedIncident: false
matchingMethod: Selected
groupByCustomDetails:
- WorkbenchID
name: Create Incident for XDR Alerts
description: |
'This Query creates an incident based on Trend Vision One Workbench Alerts and maps the impacted entities for Microsoft Sentinel usage.'
tactics:
severity: High
triggerThreshold: 0
version: 1.0.4
kind: Scheduled
triggerOperator: gt
{
"$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
"contentVersion": "1.0.0.0",
"parameters": {
"workspace": {
"type": "String"
}
},
"resources": [
{
"apiVersion": "2024-01-01-preview",
"id": "[concat(resourceId('Microsoft.OperationalInsights/workspaces/providers', parameters('workspace'), 'Microsoft.SecurityInsights'),'/alertRules/0febd8cc-1b8d-45ed-87b3-e1e8a57d14cd')]",
"kind": "Scheduled",
"name": "[concat(parameters('workspace'),'/Microsoft.SecurityInsights/0febd8cc-1b8d-45ed-87b3-e1e8a57d14cd')]",
"properties": {
"alertDetailsOverride": {
"alertDescriptionFormat": "{{description_s}}",
"alertDisplayNameFormat": "{{workbenchName_s}}",
"alertSeverityColumnName": "Severity"
},
"alertRuleTemplateName": "0febd8cc-1b8d-45ed-87b3-e1e8a57d14cd",
"customDetails": {
"CreatedAt": "createdTime_t",
"ImpactScopeSummary": "impactScope_Summary_s",
"PriorityScore": "priorityScore_d",
"Provider": "alertProvider_s",
"Severity": "severity_s",
"WorkbenchID": "workbenchId_s",
"WorkbenchLink": "workbenchLink_s",
"WorkbenchName": "workbenchName_s",
"XDRCustomerID": "xdrCustomerID_g"
},
"description": "'This Query creates an incident based on Trend Vision One Workbench Alerts and maps the impacted entities for Microsoft Sentinel usage.'\n",
"displayName": "Create Incident for XDR Alerts",
"enabled": true,
"entityMappings": [
{
"entityType": "Account",
"fieldMappings": [
{
"columnName": "UserAccountName_s",
"identifier": "Name"
},
{
"columnName": "UserAccountNTDomain_s",
"identifier": "NTDomain"
}
]
},
{
"entityType": "File",
"fieldMappings": [
{
"columnName": "FileName_s",
"identifier": "Name"
},
{
"columnName": "FileDirectory_s",
"identifier": "Directory"
}
]
},
{
"entityType": "Process",
"fieldMappings": [
{
"columnName": "ProcessCommandLine_s",
"identifier": "CommandLine"
}
]
},
{
"entityType": "RegistryKey",
"fieldMappings": [
{
"columnName": "RegistryKey_s",
"identifier": "Key"
}
]
},
{
"entityType": "RegistryValue",
"fieldMappings": [
{
"columnName": "ProcessCommandLine_s",
"identifier": "Name"
},
{
"columnName": "RegistryValue_s",
"identifier": "Value"
}
]
}
],
"eventGroupingSettings": {
"aggregationKind": "AlertPerResult"
},
"incidentConfiguration": {
"createIncident": true,
"groupingConfiguration": {
"enabled": true,
"groupByCustomDetails": [
"WorkbenchID"
],
"lookbackDuration": "PT5M",
"matchingMethod": "Selected",
"reopenClosedIncident": false
}
},
"OriginalUri": "https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Trend Micro Vision One/Analytic Rules/Create Incident for XDR Alerts.yaml",
"query": "TrendMicro_XDR_WORKBENCH_CL\n| extend Severity = case(severity_s == \"low\", \"Informational\",\n severity_s == \"medium\", \"Low\",\n severity_s == \"high\", \"Medium\",\n \"High\"\n )\n| extend \n UserAccountName_s = todynamic(column_ifexists(\"UserAccountName_s\", \"[]\")),\n UserAccountNTDomain_s = todynamic(column_ifexists(\"UserAccountNTDomain_s\", \"[]\")),\n FileName_s = todynamic(column_ifexists(\"FileName_s\", \"[]\")),\n FileDirectory_s = todynamic(column_ifexists(\"FileDirectory_s\", \"[]\")),\n ProcessCommandLine_s = todynamic(column_ifexists(\"ProcessCommandLine_s\", \"[]\")),\n RegistryKey_s = todynamic(column_ifexists(\"RegistryKey_s\", \"[]\")),\n RegistryValue_s = todynamic(column_ifexists(\"RegistryValue_s\", \"[]\")),\n RegistryValueName_s = todynamic(column_ifexists(\"RegistryValueName_s\", \"[]\"))\n",
"queryFrequency": "PT5M",
"queryPeriod": "PT5M",
"severity": "High",
"status": "Available",
"subTechniques": [],
"suppressionDuration": "PT5H",
"suppressionEnabled": false,
"tactics": null,
"techniques": null,
"templateVersion": "1.0.4",
"triggerOperator": "GreaterThan",
"triggerThreshold": 0
},
"type": "Microsoft.OperationalInsights/workspaces/providers/alertRules"
}
]
}