Bert-Jan Pals unknown stable kql

Live Response File Collection

This query lists all the Getfile activities that have been executed. This includes listing the SHA256 hash of the collected file (when available).

View Source

Detection Logic

CloudAppEvents
| where Timestamp > ago(30d)
| where ActionType == "LiveResponseGetFile"
| extend FileName = tostring(parse_json(RawEventData).FileName), FileSHA256 = tostring(parse_json(RawEventData).FileSHA256)
| project-rename InitiatedByAccountName = AccountDisplayName, InitiatedByAccounttId = AccountId, SHA256 = FileSHA256
| invoke FileProfile(SHA256, 1000)
| project-reorder Timestamp, FileName, SHA256, InitiatedByAccountName, InitiatedByAccounttId, GlobalPrevalence, SignatureState

Field Validations

Loading…

Comments (0)

Loading comments...