Progress MOVEIt File transfer folder count above threshold
Id | 26a993ca-0a96-45a0-8405-05a210fb98f8 |
Rulename | Progress MOVEIt File transfer folder count above threshold |
Description | Identifies Progress MOVEIt File Transfers with distinct folder count above certain threshold in a 15min time period. Please note that entity mapping for arrays is not supported, so when there is a single value in an array, we will pull that value from the array as a single string to populate the entity to support entity mapping features within Sentinel. Additionally, if the array is multivalued, we will input a string to indicate this with a unique hash so that matching will not occur. |
Severity | Medium |
Tactics | Exfiltration |
Techniques | T1020 |
Required data connectors | WindowsForwardedEvents |
Kind | Scheduled |
Query frequency | 15m |
Query period | 15m |
Trigger threshold | 0 |
Trigger operator | gt |
Source Uri | https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Windows Forwarded Events/Analytic Rules/moveit_file_transfer_folders_above_threshold.yaml |
Version | 1.0.1 |
Arm template | 26a993ca-0a96-45a0-8405-05a210fb98f8.json |
let threshold = 500;
Event
| where EventID == 0 and Source == "MOVEit DMZ Audit" and EventLog == "Application"
| where RenderedDescription has_any ("Downloaded", "Uploaded")
| parse RenderedDescription with * "User '" userdisplayname "' (" *
| parse RenderedDescription with * "IPAddress: " ipaddress " FileID:" * " FileName: " filename " FolderID: " folderid " FolderPath: " folderpath " Username: " username " AgentBrand: " *
| summarize count_distinct_folderpath=dcount(folderpath), dirlist=make_set(folderpath) by Computer,userdisplayname,username,ipaddress,bin(TimeGenerated, 15m)
| where count_distinct_folderpath >= threshold
| extend DirSample = iff(array_length(dirlist) == 1, tostring(dirlist[0]), strcat("SeeDirListField","_", tostring(hash(tostring(dirlist)))))
name: Progress MOVEIt File transfer folder count above threshold
severity: Medium
queryFrequency: 15m
triggerOperator: gt
customDetails:
FilesList: dirlist
TransferCount: count_distinct_folderpath
relevantTechniques:
- T1020
version: 1.0.1
description: |
'Identifies Progress MOVEIt File Transfers with distinct folder count above certain threshold in a 15min time period.
Please note that entity mapping for arrays is not supported, so when there is a single value in an array, we will pull that value from the array as a single string to populate the entity to support entity mapping features within Sentinel. Additionally, if the array is multivalued, we will input a string to indicate this with a unique hash so that matching will not occur.'
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Windows Forwarded Events/Analytic Rules/moveit_file_transfer_folders_above_threshold.yaml
requiredDataConnectors:
- connectorId: WindowsForwardedEvents
dataTypes:
- WindowsEvent
entityMappings:
- fieldMappings:
- identifier: Name
columnName: userdisplayname
entityType: Account
- fieldMappings:
- identifier: Address
columnName: ipaddress
entityType: IP
- fieldMappings:
- identifier: HostName
columnName: Computer
entityType: Host
- fieldMappings:
- identifier: Name
columnName: DirSample
entityType: File
tactics:
- Exfiltration
queryPeriod: 15m
query: |
let threshold = 500;
Event
| where EventID == 0 and Source == "MOVEit DMZ Audit" and EventLog == "Application"
| where RenderedDescription has_any ("Downloaded", "Uploaded")
| parse RenderedDescription with * "User '" userdisplayname "' (" *
| parse RenderedDescription with * "IPAddress: " ipaddress " FileID:" * " FileName: " filename " FolderID: " folderid " FolderPath: " folderpath " Username: " username " AgentBrand: " *
| summarize count_distinct_folderpath=dcount(folderpath), dirlist=make_set(folderpath) by Computer,userdisplayname,username,ipaddress,bin(TimeGenerated, 15m)
| where count_distinct_folderpath >= threshold
| extend DirSample = iff(array_length(dirlist) == 1, tostring(dirlist[0]), strcat("SeeDirListField","_", tostring(hash(tostring(dirlist)))))
incidentConfiguration:
createIncident: true
groupingConfiguration:
matchingMethod: Selected
lookbackDuration: 5h
enabled: true
groupByEntities:
- Account
- Host
reopenClosedIncident: false
groupByAlertDetails: []
groupByCustomDetails: []
kind: Scheduled
triggerThreshold: 0
id: 26a993ca-0a96-45a0-8405-05a210fb98f8
{
"$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/26a993ca-0a96-45a0-8405-05a210fb98f8')]",
"kind": "Scheduled",
"name": "[concat(parameters('workspace'),'/Microsoft.SecurityInsights/26a993ca-0a96-45a0-8405-05a210fb98f8')]",
"properties": {
"alertRuleTemplateName": "26a993ca-0a96-45a0-8405-05a210fb98f8",
"customDetails": {
"FilesList": "dirlist",
"TransferCount": "count_distinct_folderpath"
},
"description": "'Identifies Progress MOVEIt File Transfers with distinct folder count above certain threshold in a 15min time period.\n Please note that entity mapping for arrays is not supported, so when there is a single value in an array, we will pull that value from the array as a single string to populate the entity to support entity mapping features within Sentinel. Additionally, if the array is multivalued, we will input a string to indicate this with a unique hash so that matching will not occur.'\n",
"displayName": "Progress MOVEIt File transfer folder count above threshold",
"enabled": true,
"entityMappings": [
{
"entityType": "Account",
"fieldMappings": [
{
"columnName": "userdisplayname",
"identifier": "Name"
}
]
},
{
"entityType": "IP",
"fieldMappings": [
{
"columnName": "ipaddress",
"identifier": "Address"
}
]
},
{
"entityType": "Host",
"fieldMappings": [
{
"columnName": "Computer",
"identifier": "HostName"
}
]
},
{
"entityType": "File",
"fieldMappings": [
{
"columnName": "DirSample",
"identifier": "Name"
}
]
}
],
"incidentConfiguration": {
"createIncident": true,
"groupingConfiguration": {
"enabled": true,
"groupByAlertDetails": [],
"groupByCustomDetails": [],
"groupByEntities": [
"Account",
"Host"
],
"lookbackDuration": "PT5H",
"matchingMethod": "Selected",
"reopenClosedIncident": false
}
},
"OriginalUri": "https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Windows Forwarded Events/Analytic Rules/moveit_file_transfer_folders_above_threshold.yaml",
"query": "let threshold = 500;\nEvent\n| where EventID == 0 and Source == \"MOVEit DMZ Audit\" and EventLog == \"Application\"\n| where RenderedDescription has_any (\"Downloaded\", \"Uploaded\")\n| parse RenderedDescription with * \"User '\" userdisplayname \"' (\" *\n| parse RenderedDescription with * \"IPAddress: \" ipaddress \" FileID:\" * \" FileName: \" filename \" FolderID: \" folderid \" FolderPath: \" folderpath \" Username: \" username \" AgentBrand: \" *\n| summarize count_distinct_folderpath=dcount(folderpath), dirlist=make_set(folderpath) by Computer,userdisplayname,username,ipaddress,bin(TimeGenerated, 15m)\n| where count_distinct_folderpath >= threshold\n| extend DirSample = iff(array_length(dirlist) == 1, tostring(dirlist[0]), strcat(\"SeeDirListField\",\"_\", tostring(hash(tostring(dirlist)))))\n",
"queryFrequency": "PT15M",
"queryPeriod": "PT15M",
"severity": "Medium",
"subTechniques": [],
"suppressionDuration": "PT1H",
"suppressionEnabled": false,
"tactics": [
"Exfiltration"
],
"techniques": [
"T1020"
],
"templateVersion": "1.0.1",
"triggerOperator": "GreaterThan",
"triggerThreshold": 0
},
"type": "Microsoft.OperationalInsights/workspaces/providers/alertRules"
}
]
}