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

description: |
    'Detects when a user deletes many items in short period of time.'
kind: Scheduled
queryFrequency: 1h
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Box/Analytic Rules/BoxMultipleItemsDeletedByUser.yaml
status: Available
triggerOperator: gt
severity: Medium
relevantTechniques:
- T1485
triggerThreshold: 0
name: Box - Many items deleted by user
entityMappings:
- fieldMappings:
  - columnName: AccountCustomEntity
    identifier: FullName
  entityType: Account
requiredDataConnectors:
- connectorId: BoxDataConnector
  dataTypes:
  - BoxEvents_CL
id: 1b212329-6f2c-46ca-9071-de3464f3d88d
queryPeriod: 1h
tactics:
- Impact
version: 1.0.1
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

ARM