CarbonBlackEvents_CL
| extend eventTime = datetime(1970-01-01) + tolong(eventTime_d/1000) * 1sec
| where targetApp_effectiveReputation_s =~ "KNOWN_MALWARE"
| summarize StartTime = min(TimeGenerated), EndTime = max(TimeGenerated), count() by eventTime, deviceDetails_deviceName_s, deviceDetails_deviceIpAddress_s, processDetails_fullUserName_s, processDetails_targetName_s
name: Known Malware Detected
relevantTechniques:
- T1204
id: 9f86885f-f31f-4e66-a39d-352771ee789e
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/VMware Carbon Black Cloud/Analytic Rules/KnownMalwareDetected.yaml
requiredDataConnectors:
- dataTypes:
- CarbonBlackEvents_CL
connectorId: VMwareCarbonBlack
version: 1.0.2
severity: Medium
triggerThreshold: 0
queryPeriod: 1h
entityMappings:
- fieldMappings:
- identifier: FullName
columnName: processDetails_fullUserName_s
entityType: Account
- fieldMappings:
- identifier: FullName
columnName: deviceDetails_deviceName_s
entityType: Host
- fieldMappings:
- identifier: Address
columnName: deviceDetails_deviceIpAddress_s
entityType: IP
queryFrequency: 1h
status: Available
query: |
CarbonBlackEvents_CL
| extend eventTime = datetime(1970-01-01) + tolong(eventTime_d/1000) * 1sec
| where targetApp_effectiveReputation_s =~ "KNOWN_MALWARE"
| summarize StartTime = min(TimeGenerated), EndTime = max(TimeGenerated), count() by eventTime, deviceDetails_deviceName_s, deviceDetails_deviceIpAddress_s, processDetails_fullUserName_s, processDetails_targetName_s
tactics:
- Execution
kind: Scheduled
description: |
'This creates an incident when a known Malware is detected on a endpoint managed by a Carbon Black.'
triggerOperator: gt