let threshold = 10;
QualysHostDetection
| where Severity == "5"
| summarize StartTime = min(TimeGenerated), EndTime = max(TimeGenerated), count() by NetBios, IPAddress
| where count_ >= threshold
queryPeriod: 1h
query: |
let threshold = 10;
QualysHostDetection
| where Severity == "5"
| summarize StartTime = min(TimeGenerated), EndTime = max(TimeGenerated), count() by NetBios, IPAddress
| where count_ >= threshold
name: High Number of Urgent Vulnerabilities Detected
entityMappings:
- fieldMappings:
- columnName: NetBios
identifier: FullName
entityType: Host
- fieldMappings:
- columnName: IPAddress
identifier: Address
entityType: IP
queryFrequency: 1h
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/QualysVM/Analytic Rules/HighNumberofVulnDetectedV2.yaml
requiredDataConnectors:
- connectorId: QualysVMLogsCCPDefinition
dataTypes:
- QualysHostDetection
description: |
'This Creates an incident when a host has a high number of Urgent, severity 5, vulnerabilities detected.'
kind: Scheduled
version: 1.0.3
status: Available
severity: Medium
relevantTechniques:
- T1190
triggerOperator: gt
triggerThreshold: 0
tactics:
- InitialAccess
id: 3edb7215-250b-40c0-8b46-79093949242d