Admin password not updated in 30 days

Back


Id	63d87fcb-d197-48d2-a642-de4813f0219a
Rulename	Admin password not updated in 30 days
Description	The policy detects an administrative account where the password of the account was not updated in the last 30 days.
Severity	Medium
Tactics	InitialAccess
Techniques	T1078
Required data connectors	Authomize
Kind	Scheduled
Query frequency	30m
Query period	30m
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Authomize/Analytic Rules/Admin_password_wasnt_updated.yaml
Version	1.0.2
Arm template	63d87fcb-d197-48d2-a642-de4813f0219a.json

KQL

Authomize_v2_CL
| where ingestion_time() >= ago(30m)
| extend EventID = id_s, Policy = policy_name_s, Severity = severity_s,Description = description_s,Recommendation = recommendation_s,URL = url_s,Tactics = tactics_s
| where Policy has "Admin password wasn't updated during the last 30 days"
| project  EventID, Policy, Severity, Description, Recommendation, URL, Category, Tactics

YAML

version: 1.0.2
severity: Medium
eventGroupingSettings:
  aggregationKind: SingleAlert
triggerOperator: gt
kind: Scheduled
description: The policy detects an administrative account where the password of the account was not updated in the last 30 days.
incidentConfiguration:
  groupingConfiguration:
    lookbackDuration: 5h
    groupByAlertDetails: []
    groupByCustomDetails: []
    reopenClosedIncident: false
    groupByEntities: []
    matchingMethod: AnyAlert
    enabled: true
  createIncident: true
tactics:
- InitialAccess
triggerThreshold: 0
query: |-
  Authomize_v2_CL
  | where ingestion_time() >= ago(30m)
  | extend EventID = id_s, Policy = policy_name_s, Severity = severity_s,Description = description_s,Recommendation = recommendation_s,URL = url_s,Tactics = tactics_s
  | where Policy has "Admin password wasn't updated during the last 30 days"
  | project  EventID, Policy, Severity, Description, Recommendation, URL, Category, Tactics  
name: Admin password not updated in 30 days
relevantTechniques:
- T1078
requiredDataConnectors:
- dataTypes:
  - Authomize_v2_CL
  connectorId: Authomize
status: Available
queryPeriod: 30m
entityMappings:
- fieldMappings:
  - columnName: URL
    identifier: Url
  entityType: URL
suppressionDuration: 5h
customDetails:
  ReferencedURL: URL
  EventRecommendation: Recommendation
  AuthomizeEventID: EventID
  EventName: Policy
  EventDescription: Description
id: 63d87fcb-d197-48d2-a642-de4813f0219a
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Authomize/Analytic Rules/Admin_password_wasnt_updated.yaml
alertDetailsOverride:
  alertSeverity: Severity
  alertDynamicProperties:
  - alertProperty: AlertLink
    value: URL
  alertTactics: Tactics
  alertnameFormat: Alert from Authomize - Admin password wasn't updated during the last 30 days
  alertDescriptionFormat: |
        Admin password wasn't updated during the last 30 days. The policy detects admin account where password wasn't updated during the last 30 days.
queryFrequency: 30m
suppressionEnabled: false

ARM

{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "workspace": {
      "type": "String"
    }
  },
  "resources": [
    {
      "apiVersion": "2024-01-01-preview",
      "id": "[concat(resourceId('Microsoft.OperationalInsights/workspaces/providers', parameters('workspace'), 'Microsoft.SecurityInsights'),'/alertRules/63d87fcb-d197-48d2-a642-de4813f0219a')]",
      "kind": "Scheduled",
      "name": "[concat(parameters('workspace'),'/Microsoft.SecurityInsights/63d87fcb-d197-48d2-a642-de4813f0219a')]",
      "properties": {
        "alertDetailsOverride": {
          "alertDescriptionFormat": "Admin password wasn't updated during the last 30 days. The policy detects admin account where password wasn't updated during the last 30 days.\n",
          "alertDynamicProperties": [
            {
              "alertProperty": "AlertLink",
              "value": "URL"
            }
          ],
          "alertnameFormat": "Alert from Authomize - Admin password wasn't updated during the last 30 days",
          "alertSeverity": "Severity",
          "alertTactics": "Tactics"
        },
        "alertRuleTemplateName": "63d87fcb-d197-48d2-a642-de4813f0219a",
        "customDetails": {
          "AuthomizeEventID": "EventID",
          "EventDescription": "Description",
          "EventName": "Policy",
          "EventRecommendation": "Recommendation",
          "ReferencedURL": "URL"
        },
        "description": "The policy detects an administrative account where the password of the account was not updated in the last 30 days.",
        "displayName": "Admin password not updated in 30 days",
        "enabled": true,
        "entityMappings": [
          {
            "entityType": "URL",
            "fieldMappings": [
              {
                "columnName": "URL",
                "identifier": "Url"
              }
            ]
          }
        ],
        "eventGroupingSettings": {
          "aggregationKind": "SingleAlert"
        },
        "incidentConfiguration": {
          "createIncident": true,
          "groupingConfiguration": {
            "enabled": true,
            "groupByAlertDetails": [],
            "groupByCustomDetails": [],
            "groupByEntities": [],
            "lookbackDuration": "PT5H",
            "matchingMethod": "AnyAlert",
            "reopenClosedIncident": false
          }
        },
        "OriginalUri": "https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Authomize/Analytic Rules/Admin_password_wasnt_updated.yaml",
        "query": "Authomize_v2_CL\n| where ingestion_time() >= ago(30m)\n| extend EventID = id_s, Policy = policy_name_s, Severity = severity_s,Description = description_s,Recommendation = recommendation_s,URL = url_s,Tactics = tactics_s\n| where Policy has \"Admin password wasn't updated during the last 30 days\"\n| project  EventID, Policy, Severity, Description, Recommendation, URL, Category, Tactics",
        "queryFrequency": "PT30M",
        "queryPeriod": "PT30M",
        "severity": "Medium",
        "status": "Available",
        "subTechniques": [],
        "suppressionDuration": "PT5H",
        "suppressionEnabled": false,
        "tactics": [
          "InitialAccess"
        ],
        "techniques": [
          "T1078"
        ],
        "templateVersion": "1.0.2",
        "triggerOperator": "GreaterThan",
        "triggerThreshold": 0
      },
      "type": "Microsoft.OperationalInsights/workspaces/providers/alertRules"
    }
  ]
}