BloodHound Attack Path Finding - SQL Admin Users on Tier Zero Computers

Back


Id	b3c6f684-5fb3-451d-b1d9-fec8089c2503
Rulename	BloodHound Attack Path Finding - SQL Admin Users on Tier Zero Computers
Description	BloodHound Attack Path Finding - SQL Admin Users on Tier Zero Computers
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/SqlAdminUsersOnTierZeroComputers.yaml
Version	1.0.0
Arm template	b3c6f684-5fb3-451d-b1d9-fec8089c2503.json

KQL

BHEAttackPathsData_CL | where Finding == "T0SQLAdmin"

YAML

description: BloodHound Attack Path Finding - SQL Admin Users on Tier Zero Computers
kind: Scheduled
tactics: []
requiredDataConnectors:
- connectorId: BloodHoundEnterprise
  dataTypes:
  - BHEAttackPathsData_CL
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/BloodHound Enterprise/Analytic Rules/SqlAdminUsersOnTierZeroComputers.yaml
severity: Medium
name: BloodHound Attack Path Finding - SQL Admin Users on Tier Zero Computers
customDetails:
  Remediation: ShortRemediation
  Description: ShortDescription
triggerThreshold: 0
queryPeriod: 1h
query: BHEAttackPathsData_CL | where Finding == "T0SQLAdmin"
relevantTechniques: []
id: b3c6f684-5fb3-451d-b1d9-fec8089c2503
queryFrequency: 1h
status: Available
triggerOperator: gt
version: 1.0.0
entityMappings:
- entityType: URL
  fieldMappings:
  - columnName: domain_name
    identifier: Url

ARM