SpyCloud Enterprise Malware Detection

Back


Id	7ba50f9e-2f94-462b-a54b-8642b8c041f5
Rulename	SpyCloud Enterprise Malware Detection
Description	This alert creates an incident when an malware record is detected in the SpyCloud watchlist data
Severity	High
Tactics	CredentialAccess
Techniques	T1555
Kind	Scheduled
Query frequency	12h
Query period	12h
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/SpyCloud Enterprise Protection/Analytic Rules/SpyCloudEnterpriseProtectionMalwareRule.yaml
Version	1.0.1
Arm template	7ba50f9e-2f94-462b-a54b-8642b8c041f5.json

KQL

SpyCloudBreachDataWatchlist_CL
| where Severity_s == '25'
| project TimeGenerated, Document_Id_g, Source_Id_s, SpyCloud_Publish_Date_t, Email_s, Domain_s, Password_s, Password_Plaintext_s, Username_s, Infected_Machine_Id_g, Infected_Path_s, Infected_Time_t, Target_Domain_s, Target_SubDomain_s, User_Hostname_s, User_OS_s, Target_URL_s,IP_Address_s

YAML

severity: High
customDetails:
  Domain: Domain_s
  PublishDate: SpyCloud_Publish_Date_t
  Document_Id: Document_Id_g
  Source_Id: Source_Id_s
  Infected_Path: Infected_Path_s
  User_Host_Name: User_Hostname_s
  Password: Password_s
  Infected_Time: Infected_Time_t
  Password_Plaintext: Password_Plaintext_s
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/SpyCloud Enterprise Protection/Analytic Rules/SpyCloudEnterpriseProtectionMalwareRule.yaml
incidentConfiguration:
  createIncident: true
  groupingConfiguration:
    matchingMethod: AllEntities
    lookbackDuration: 12h
    enabled: true
    reopenClosedIncident: false
requiredDataConnectors: []
alertDetailsOverride: 
id: 7ba50f9e-2f94-462b-a54b-8642b8c041f5
suppressionDuration: 5h
tactics:
- CredentialAccess
queryFrequency: 12h
eventGroupingSettings:
  aggregationKind: AlertPerResult
triggerOperator: gt
relevantTechniques:
- T1555
description: |
    'This alert creates an incident when an malware record is detected in the SpyCloud watchlist data'
triggerThreshold: 0
kind: Scheduled
name: SpyCloud Enterprise Malware Detection
query: |
  SpyCloudBreachDataWatchlist_CL
  | where Severity_s == '25'
  | project TimeGenerated, Document_Id_g, Source_Id_s, SpyCloud_Publish_Date_t, Email_s, Domain_s, Password_s, Password_Plaintext_s, Username_s, Infected_Machine_Id_g, Infected_Path_s, Infected_Time_t, Target_Domain_s, Target_SubDomain_s, User_Hostname_s, User_OS_s, Target_URL_s,IP_Address_s  
entityMappings:
- entityType: Host
  fieldMappings:
  - columnName: Infected_Machine_Id_g
    identifier: HostName
  - columnName: User_Hostname_s
    identifier: DnsDomain
- entityType: Account
  fieldMappings:
  - columnName: Email_s
    identifier: FullName
  - columnName: Username_s
    identifier: Name
- entityType: DNS
  fieldMappings:
  - columnName: Target_Domain_s
    identifier: DomainName
- entityType: DNS
  fieldMappings:
  - columnName: Target_SubDomain_s
    identifier: DomainName
- entityType: IP
  fieldMappings:
  - columnName: IP_Address_s
    identifier: Address
status: Available
sentinelEntitiesMappings: 
version: 1.0.1
queryPeriod: 12h

ARM

{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "workspace": {
      "type": "String"
    }
  },
  "resources": [
    {
      "id": "[concat(resourceId('Microsoft.OperationalInsights/workspaces/providers', parameters('workspace'), 'Microsoft.SecurityInsights'),'/alertRules/7ba50f9e-2f94-462b-a54b-8642b8c041f5')]",
      "name": "[concat(parameters('workspace'),'/Microsoft.SecurityInsights/7ba50f9e-2f94-462b-a54b-8642b8c041f5')]",
      "type": "Microsoft.OperationalInsights/workspaces/providers/alertRules",
      "kind": "Scheduled",
      "apiVersion": "2022-11-01-preview",
      "properties": {
        "displayName": "SpyCloud Enterprise Malware Detection",
        "description": "'This alert creates an incident when an malware record is detected in the SpyCloud watchlist data'\n",
        "severity": "High",
        "enabled": true,
        "query": "SpyCloudBreachDataWatchlist_CL\n| where Severity_s == '25'\n| project TimeGenerated, Document_Id_g, Source_Id_s, SpyCloud_Publish_Date_t, Email_s, Domain_s, Password_s, Password_Plaintext_s, Username_s, Infected_Machine_Id_g, Infected_Path_s, Infected_Time_t, Target_Domain_s, Target_SubDomain_s, User_Hostname_s, User_OS_s, Target_URL_s,IP_Address_s\n",
        "queryFrequency": "PT12H",
        "queryPeriod": "PT12H",
        "triggerOperator": "GreaterThan",
        "triggerThreshold": 0,
        "suppressionDuration": "PT5H",
        "suppressionEnabled": false,
        "tactics": [
          "CredentialAccess"
        ],
        "techniques": [
          "T1555"
        ],
        "alertRuleTemplateName": "7ba50f9e-2f94-462b-a54b-8642b8c041f5",
        "incidentConfiguration": {
          "groupingConfiguration": {
            "enabled": true,
            "lookbackDuration": "PT12H",
            "matchingMethod": "AllEntities",
            "reopenClosedIncident": false
          },
          "createIncident": true
        },
        "eventGroupingSettings": {
          "aggregationKind": "AlertPerResult"
        },
        "alertDetailsOverride": null,
        "customDetails": {
          "Infected_Time": "Infected_Time_t",
          "User_Host_Name": "User_Hostname_s",
          "PublishDate": "SpyCloud_Publish_Date_t",
          "Document_Id": "Document_Id_g",
          "Source_Id": "Source_Id_s",
          "Infected_Path": "Infected_Path_s",
          "Password": "Password_s",
          "Domain": "Domain_s",
          "Password_Plaintext": "Password_Plaintext_s"
        },
        "entityMappings": [
          {
            "fieldMappings": [
              {
                "identifier": "HostName",
                "columnName": "Infected_Machine_Id_g"
              },
              {
                "identifier": "DnsDomain",
                "columnName": "User_Hostname_s"
              }
            ],
            "entityType": "Host"
          },
          {
            "fieldMappings": [
              {
                "identifier": "FullName",
                "columnName": "Email_s"
              },
              {
                "identifier": "Name",
                "columnName": "Username_s"
              }
            ],
            "entityType": "Account"
          },
          {
            "fieldMappings": [
              {
                "identifier": "DomainName",
                "columnName": "Target_Domain_s"
              }
            ],
            "entityType": "DNS"
          },
          {
            "fieldMappings": [
              {
                "identifier": "DomainName",
                "columnName": "Target_SubDomain_s"
              }
            ],
            "entityType": "DNS"
          },
          {
            "fieldMappings": [
              {
                "identifier": "Address",
                "columnName": "IP_Address_s"
              }
            ],
            "entityType": "IP"
          }
        ],
        "sentinelEntitiesMappings": null,
        "status": "Available",
        "templateVersion": "1.0.1",
        "OriginalUri": "https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/SpyCloud Enterprise Protection/Analytic Rules/SpyCloudEnterpriseProtectionMalwareRule.yaml"
      }
    }
  ]
}