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

relevantTechniques: []
name: Malware Detection Session Finished
queryFrequency: 3h
version: 1.0.1
triggerThreshold: 0
severity: Informational
requiredDataConnectors:
- connectorId: Syslog
  dataTypes:
  - Syslog
- connectorId: SyslogAma
  dataTypes:
  - Syslog
tactics: []
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Veeam/Analytic Rules/Malware_Detection_Session_Finished.yaml
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  
kind: Scheduled
queryPeriod: 3h
triggerOperator: gt
customDetails:
  MessageDetails: MessageDetails
  VbrHostName: DataSource
  Severity: Severity
  EventId: EventId
  Date: Date
eventGroupingSettings:
  aggregationKind: AlertPerResult
id: 88b9223c-29ff-48a9-a745-c553aa0dbae2
status: Available
description: Detects when malware detection session finishes.

ARM