Box - Many items deleted by user

Back


Id	1b212329-6f2c-46ca-9071-de3464f3d88d
Rulename	Box - Many items deleted by user
Description	Detects when a user deletes many items in short period of time.
Severity	Medium
Tactics	Impact
Techniques	T1485
Required data connectors	BoxDataConnector
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/Box/Analytic Rules/BoxMultipleItemsDeletedByUser.yaml
Version	1.0.1
Arm template	1b212329-6f2c-46ca-9071-de3464f3d88d.json

KQL

let threshold = 100;
BoxEvents
| where EventType =~ 'DELETE'
| summarize deleted_items = dcount(SourceItemName) by SrcUserName, bin(EventEndTime, 5m)
| where deleted_items > threshold
| extend AccountCustomEntity = SrcUserName

YAML

version: 1.0.1
status: Available
queryPeriod: 1h
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Box/Analytic Rules/BoxMultipleItemsDeletedByUser.yaml
relevantTechniques:
- T1485
description: |
    'Detects when a user deletes many items in short period of time.'
kind: Scheduled
name: Box - Many items deleted by user
queryFrequency: 1h
id: 1b212329-6f2c-46ca-9071-de3464f3d88d
requiredDataConnectors:
- connectorId: BoxDataConnector
  dataTypes:
  - BoxEvents_CL
tactics:
- Impact
triggerThreshold: 0
severity: Medium
query: |
  let threshold = 100;
  BoxEvents
  | where EventType =~ 'DELETE'
  | summarize deleted_items = dcount(SourceItemName) by SrcUserName, bin(EventEndTime, 5m)
  | where deleted_items > threshold
  | extend AccountCustomEntity = SrcUserName  
entityMappings:
- entityType: Account
  fieldMappings:
  - columnName: AccountCustomEntity
    identifier: FullName
triggerOperator: gt

ARM