FO - Mass update or deletion of user records
Id | 5ab00fbb-ba2c-44dc-b02e-f119639b9a11 |
Rulename | F&O - Mass update or deletion of user records |
Description | Identifies large delete or update operations on Finance & Operations user records based on predefined thresholds. |
Severity | Medium |
Tactics | Impact |
Techniques | T1485 T1565 T1491 |
Required data connectors | Dynamics365Finance |
Kind | Scheduled |
Query frequency | 1h |
Query period | 1h |
Trigger threshold | 0 |
Trigger operator | gt |
Source Uri | https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Microsoft Business Applications/Analytic Rules/F&O - Mass update or deletion of user records.yaml |
Version | 3.2.0 |
Arm template | 5ab00fbb-ba2c-44dc-b02e-f119639b9a11.json |
// Set threshold for number of updated or deleted records
let update_detection_threshold = 50;
let deleted_detection_threshold = 10;
FinanceOperationsActivity_CL
| where TableName == "UserInfo" and LogType in ("Update", "Delete")
| summarize
TotalEvents = count(),
StartTime = min(LogCreatedDateTime),
EndTime = max(LogCreatedDateTime)
by TableName, Username, LogType
| where (LogType == "Update" and TotalEvents > update_detection_threshold) or (LogType == "Delete" and TotalEvents > deleted_detection_threshold)
| extend FinOpsAppId = 32780
| project StartTime, EndTime, Username, LogType, TableName, TotalEvents, FinOpsAppId
entityMappings:
- entityType: Account
fieldMappings:
- identifier: FullName
columnName: Username
- entityType: CloudApplication
fieldMappings:
- identifier: AppId
columnName: FinOpsAppId
queryFrequency: 1h
name: F&O - Mass update or deletion of user records
alertDetailsOverride:
alertDisplayNameFormat: F&O - many user account records deleted
alertDescriptionFormat: '{{TotalEvents}} user records deleted in F&O by user {{Username}}'
kind: Scheduled
tactics:
- Impact
triggerThreshold: 0
query: |
// Set threshold for number of updated or deleted records
let update_detection_threshold = 50;
let deleted_detection_threshold = 10;
FinanceOperationsActivity_CL
| where TableName == "UserInfo" and LogType in ("Update", "Delete")
| summarize
TotalEvents = count(),
StartTime = min(LogCreatedDateTime),
EndTime = max(LogCreatedDateTime)
by TableName, Username, LogType
| where (LogType == "Update" and TotalEvents > update_detection_threshold) or (LogType == "Delete" and TotalEvents > deleted_detection_threshold)
| extend FinOpsAppId = 32780
| project StartTime, EndTime, Username, LogType, TableName, TotalEvents, FinOpsAppId
relevantTechniques:
- T1485
- T1565
- T1491
triggerOperator: gt
queryPeriod: 1h
eventGroupingSettings:
aggregationKind: SingleAlert
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Microsoft Business Applications/Analytic Rules/F&O - Mass update or deletion of user records.yaml
severity: Medium
status: Available
id: 5ab00fbb-ba2c-44dc-b02e-f119639b9a11
requiredDataConnectors:
- connectorId: Dynamics365Finance
dataTypes:
- FinanceOperationsActivity_CL
version: 3.2.0
description: Identifies large delete or update operations on Finance & Operations user records based on predefined thresholds.
{
"$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/5ab00fbb-ba2c-44dc-b02e-f119639b9a11')]",
"kind": "Scheduled",
"name": "[concat(parameters('workspace'),'/Microsoft.SecurityInsights/5ab00fbb-ba2c-44dc-b02e-f119639b9a11')]",
"properties": {
"alertDetailsOverride": {
"alertDescriptionFormat": "{{TotalEvents}} user records deleted in F&O by user {{Username}}",
"alertDisplayNameFormat": "F&O - many user account records deleted"
},
"alertRuleTemplateName": "5ab00fbb-ba2c-44dc-b02e-f119639b9a11",
"customDetails": null,
"description": "Identifies large delete or update operations on Finance & Operations user records based on predefined thresholds.",
"displayName": "F&O - Mass update or deletion of user records",
"enabled": true,
"entityMappings": [
{
"entityType": "Account",
"fieldMappings": [
{
"columnName": "Username",
"identifier": "FullName"
}
]
},
{
"entityType": "CloudApplication",
"fieldMappings": [
{
"columnName": "FinOpsAppId",
"identifier": "AppId"
}
]
}
],
"eventGroupingSettings": {
"aggregationKind": "SingleAlert"
},
"OriginalUri": "https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Microsoft Business Applications/Analytic Rules/F&O - Mass update or deletion of user records.yaml",
"query": "// Set threshold for number of updated or deleted records\nlet update_detection_threshold = 50;\nlet deleted_detection_threshold = 10;\nFinanceOperationsActivity_CL\n| where TableName == \"UserInfo\" and LogType in (\"Update\", \"Delete\")\n| summarize\n TotalEvents = count(),\n StartTime = min(LogCreatedDateTime),\n EndTime = max(LogCreatedDateTime)\n by TableName, Username, LogType\n| where (LogType == \"Update\" and TotalEvents > update_detection_threshold) or (LogType == \"Delete\" and TotalEvents > deleted_detection_threshold)\n| extend FinOpsAppId = 32780\n| project StartTime, EndTime, Username, LogType, TableName, TotalEvents, FinOpsAppId\n",
"queryFrequency": "PT1H",
"queryPeriod": "PT1H",
"severity": "Medium",
"status": "Available",
"subTechniques": [],
"suppressionDuration": "PT1H",
"suppressionEnabled": false,
"tactics": [
"Impact"
],
"techniques": [
"T1485",
"T1491",
"T1565"
],
"templateVersion": "3.2.0",
"triggerOperator": "GreaterThan",
"triggerThreshold": 0
},
"type": "Microsoft.OperationalInsights/workspaces/providers/alertRules"
}
]
}