Malware Detection Session Finished

Back


Id	88b9223c-29ff-48a9-a745-c553aa0dbae2
Rulename	Malware Detection Session Finished
Description	Detects when malware detection session finishes.
Severity	Informational
Required data connectors	Syslog SyslogAma
Kind	Scheduled
Query frequency	3h
Query period	3h
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Veeam/Analytic Rules/Malware_Detection_Session_Finished.yaml
Version	1.0.1
Arm template	88b9223c-29ff-48a9-a745-c553aa0dbae2.json

KQL

let action_results_lookup = union isfuzzy=true (datatable(JobResult:string, JobResultMessage:string)[]), (_GetWatchlist("action_results_lookup")); 
Veeam_GetSecurityEvents
| where instanceId == 42210
| extend Result = extract("Result=\"([^\"]*)\"", 1, SyslogMessage)
| extend SessionID = extract("SessionID=\"([^\"]*)\"", 1, SyslogMessage)
| lookup kind=leftouter (action_results_lookup)
    on $left.Result == $right.JobResult
| project
    Date = format_datetime(TimeGenerated, 'dd.MM.yyyy HH:mm'),
    DataSource = original_host,
    EventId = instanceId,
    ["Session ID"] = SessionID,
    ["StateMessage"] = JobResultMessage,
    MessageDetails = Description,
    Severity = SeverityDescription

YAML

name: Malware Detection Session Finished
id: 88b9223c-29ff-48a9-a745-c553aa0dbae2
description: Detects when malware detection session finishes.
triggerThreshold: 0
version: 1.0.1
triggerOperator: gt
query: |
  let action_results_lookup = union isfuzzy=true (datatable(JobResult:string, JobResultMessage:string)[]), (_GetWatchlist("action_results_lookup")); 
  Veeam_GetSecurityEvents
  | where instanceId == 42210
  | extend Result = extract("Result=\"([^\"]*)\"", 1, SyslogMessage)
  | extend SessionID = extract("SessionID=\"([^\"]*)\"", 1, SyslogMessage)
  | lookup kind=leftouter (action_results_lookup)
      on $left.Result == $right.JobResult
  | project
      Date = format_datetime(TimeGenerated, 'dd.MM.yyyy HH:mm'),
      DataSource = original_host,
      EventId = instanceId,
      ["Session ID"] = SessionID,
      ["StateMessage"] = JobResultMessage,
      MessageDetails = Description,
      Severity = SeverityDescription  
tactics: []
kind: Scheduled
queryFrequency: 3h
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Veeam/Analytic Rules/Malware_Detection_Session_Finished.yaml
severity: Informational
queryPeriod: 3h
requiredDataConnectors:
- dataTypes:
  - Syslog
  connectorId: Syslog
- dataTypes:
  - Syslog
  connectorId: SyslogAma
status: Available
customDetails:
  VbrHostName: DataSource
  Severity: Severity
  Date: Date
  MessageDetails: MessageDetails
  EventId: EventId
eventGroupingSettings:
  aggregationKind: AlertPerResult
relevantTechniques: []

ARM