BloodHound Attack Path Finding - Large Default Groups in SQL Admins Groups

Back


Id	000d4f86-fc35-4451-9b2b-2a660a95f715
Rulename	BloodHound Attack Path Finding - Large Default Groups in SQL Admins Groups
Description	BloodHound Attack Path Finding - Large Default Groups in SQL Admins Groups
Severity	Medium
Required data connectors	BloodHoundEnterprise
Kind	Scheduled
Query frequency	1h
Query period	1h
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/BloodHound Enterprise/Analytic Rules/LargeDefaultGroupsInSqlAdminsGroups.yaml
Version	1.0.0
Arm template	000d4f86-fc35-4451-9b2b-2a660a95f715.json

KQL

BHEAttackPathsData_CL | where Finding == "LargeDefaultGroupsSQLAdmin"

YAML

triggerOperator: gt
queryFrequency: 1h
requiredDataConnectors:
- connectorId: BloodHoundEnterprise
  dataTypes:
  - BHEAttackPathsData_CL
relevantTechniques: []
entityMappings:
- entityType: URL
  fieldMappings:
  - identifier: Url
    columnName: domain_name
query: BHEAttackPathsData_CL | where Finding == "LargeDefaultGroupsSQLAdmin"
triggerThreshold: 0
customDetails:
  Remediation: ShortRemediation
  Description: ShortDescription
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/BloodHound Enterprise/Analytic Rules/LargeDefaultGroupsInSqlAdminsGroups.yaml
queryPeriod: 1h
name: BloodHound Attack Path Finding - Large Default Groups in SQL Admins Groups
status: Available
kind: Scheduled
description: BloodHound Attack Path Finding - Large Default Groups in SQL Admins Groups
id: 000d4f86-fc35-4451-9b2b-2a660a95f715
version: 1.0.0
tactics: []
severity: Medium

ARM