☁️
CTHFM: Azure
  • Welcome
  • Getting Started
    • Account Setup
      • Account Creation Instructions
  • Azure Fundamentals
    • Azure Fundamentals Overview
      • Azure Documentation
      • Azure Entra
      • Azure Hierarchy
      • Identities
      • Azure Entra Roles
      • Azure RBAC
      • Azure Licensing Overview
        • Azure Entra ID Premium Licenses Comparison
      • Azure Shared Responsibility Model
      • Azure Frameworks
      • Azure Security Services
      • Conditional Access Policies
        • How Conditional Access Policies Work
        • Benefits of Conditional Access
        • Best Practices for Conditional Access
        • Conditions for Conditional Access
        • Conditional Access Controls
        • Sign-In Risk and Identity Protection
        • Conditional Access Session Control
        • Name Locations IP Location
      • Azure Quotas
      • Azure Tokens
        • Access Tokens
        • ID Tokens
        • Refresh Tokens
          • Invalidate Refresh Tokens
        • Primary Refresh Tokens
        • Continuous Access Evaluation (CAE)
        • Token Protection: Conditional Access (Public Preview)
  • Azure CLI
    • Introduction to Azure CLI
    • Installing Azure CLI
    • CLI Commands
    • Resource Group Management
    • Creating and Managing Resources with Azure CLI
    • Managing IAM
    • Azure CLI Automation
    • Monitoring and Troubleshooting in Azure CLI
    • Azure CLI Overview
      • Azure CLI: Linux
      • Azure CLI: Windows
      • Azure CLI: MacOS
  • KQL
    • KQL Overview
      • KQL Introduction
      • Data Types
      • Quick Reference
      • Render
      • Basic Queries
  • Powershell
    • PowerShell for Azure
      • Powershell Documentation
      • Powershell Basics
      • Understanding Powershell Variables
      • Understanding Cmdlets
      • Powershell Console & ISE
      • Powershell: Entra Module
        • Module Reference & Getting Started
      • Powershell: Azure Module
        • Installation Instructions
        • Powershell Azure CLI: Windows
        • Powershell Azure CLI: Linux
        • Powershell Azure CLI: MacOS
        • Example Azure Cmdlets
  • Bicep
    • Bicep File Structure
    • Variable Types
  • Azure Logging References
    • Logging
      • Log Retention Strategies
      • Azure Log Types
      • Azure Activity Logs
        • Administrative Event Schema
        • Service Health Notification Schema
        • Resource Health
        • Alert Category
        • Autoscale
        • Security
        • Recommendation
        • Policy
      • Entra ID Logging
        • Identity Based Logs
          • Audit Logs
          • Sign-In Logs
            • AADNonInteractiveUserSignInLogs
            • AADManagedIdentitySignInLogs
            • AADServicePrincipalSignInLogs
            • First Party Sign-In Activity
          • Provisioning Logs (AADProvisioningLogs)
          • Microsoft Graph Activity
          • Identity Protection
            • Risk Detections
            • AADRiskyServicePrincipals
            • AADRiskyUsers
            • AADUserRiskEvents
            • AADServicePrincipalRiskEvents
        • Additional Entra ID Logs
      • Azure Key Vault
        • Azure Key Vault Logging Overview
      • Network Watcher
        • RBAC Permissions
        • Flow Log Types
          • NSG Flow Log Schema
          • VNET Flow Log Schema
        • Enabling Logs
          • NSG Flow Logs
          • VNET Flow Logs
        • Packet Capture
          • Packet Capture: VM
          • Packet Capture: Scale Sets
      • Compute Resources
        • Azure Monitor Agent
        • VM Insights
          • VM Insights Tables
      • Storage Accounts
        • Storage Account Logging
          • File
            • Enable StorageFileLogs
            • StorageFileLogs
          • Blob
            • Enable Blob Logging
            • StorageBlobLogs
          • Queue
            • Enable Queue Logging
            • StorageQueueLogs Table
          • Table
            • Enable Table Logging
            • StorageTableLogs Table
      • Azure App Service
        • Log Types
        • Enabling Logging
      • Azure Monitor
        • Resource Logs
          • Resource Log Top Level Documentation
        • Log Analytics Workspace
          • Setup
        • Workbooks
        • Dashboards
        • Alerts
        • Azure Monitor Documentation
      • Defender for Cloud
      • Intune
      • Sysmon
      • Purview Audit Log Schema
      • Kubernetes Audit Log (AKS)
  • Threat Hunting
    • Threat Hunting in Azure
      • Threat Hunting Introduction
      • Threat Hunting Process
        • Hypothesis Generation
        • Investigation
        • Identification
        • Resolution & Follow Up
      • Pyramid of Pain
      • Azure Threat Hunting Ideas
      • Hands On Threat Hunting Examples
      • OSINT Feeds
  • Sigma
    • Sigma Rule Structure
  • Microsoft Defender TI
    • Microsoft Defender Threat Intelligence
      • Data Sets
      • Reputational Scoring
      • Analyst Insights
      • Microsoft Defender TI: Copilot Integration
  • MITRE Att&ck
    • MITRE Att&ck
      • MITRE Att&ck Concepts
      • MITRE Data Sources
      • MITRE Att&ck Mitigations
      • MITRE Att&ck: Azure
        • MITRE Att&CK: Azure Security Control Mapping
  • Microsoft Resources
    • Microsoft Incident Response Ninja Hub
    • Microsoft Defender XDR Ninja Hub
  • Azure Threat Research Matrix (ATRM)
  • Security Research & Resources
    • Azure Goat
    • Azure Security Research
      • Azure Related CVEs
  • Defender XDR
    • Defender XDR Overview
    • Defender XDR Licensing
    • Defender XDR Default Retention
    • Defender XDR Advanced Hunting Table Schemas
    • Automated Response Requirements
    • Supported Response Actions
  • Azure Sentinel
    • Sentinel Overview
    • Azure Sentinel Deployments
    • Supported Data
    • Workbook, Playbook, Notebook Comparison
    • Sentinel Workbooks
    • Entities
    • User and Entity Behavior Analytics
    • Anomaly Detection
    • Mult-Stage Attack Detection
    • Sentinel: Az CLI
  • Microsoft Defender
    • Microsoft Defender for Cloud References
    • Defender for Cloud: Az CLI
  • Azure Policy
    • Azure Policy
    • Azure Policy Components
    • Azure Policy Rules
    • Scope Azure Policy
    • Policy Assignments
    • Policy Effect
    • Initiative Definition
    • Policy Parameters
    • Remediation Task Structure
    • Use Cases for Azure Policy
    • Azure Policy: Az CLI
  • Intune
    • Intune Overview
    • Intune Licensing
    • Intune API Permission Scopes
    • Intune Sample Script Resources
  • Intune Logging
    • Configure Logging
    • Logging Schema References
    • Intune Queries and Resources
  • Windows Host Security
    • Windows System Architecture and OS Fundamentals
    • SysInternals
    • Basic vs Advanced Security Auditing
    • Sysmon
  • Adversary Emulation
    • AzureHound
    • AADInternals
      • Install
    • RoadTools
      • Install
    • Oh365UserFinder
    • GraphRunner
  • Incident Response
    • Incident Response
      • Azure IR Program Development Cheat Sheet
      • Azure IR Playbooks (MS Guidance)
      • Ransomware (MS Guidance)
  • Automation
    • Automation Overview
    • Logic Apps
      • How Logic Apps Work
      • Logic App Types
      • Triggers
      • Connectors
      • Conditional Logic and Control Flow
      • APIs in Logic Apps
      • Handling Large Workflows with Stateful Logic Apps
      • External Service Integration
      • Securing, Managing, and Scaling Azure Logic Apps
      • Logic Apps: Az CLI
  • Packet Analysis
    • Wireshark Cheatsheet
    • TShark Cheatsheet
    • TCPDUMP Cheatsheet
    • Protocol Analysis Basics
    • HTTP Response Code Cheatsheet
    • RFC Protocol Mappings
    • PCAP Acquisition
  • Detection Lab
    • Detection Lab Introduction
    • Account Creation Instructions
    • Enable MFA Within Azure Tenant
    • Create an Azure Admin With Cloud Shell
    • Setup and Install Instructions
  • VSCode and Code Setup
  • Deploying Code
  • Enabling Logs for Log Analytics Workspace
  • Logging Into Windows VM
  • Verifying Logs in Log Analytics Workspace
  • Creating Detections: Azure Monitor
  • Cost Management: Billing Alarms
Powered by GitBook
On this page
  • Workbook Overview
  • Key Features of Workbooks
  • Workbook Setup
  • Example Security Event Workbook Scenario
  1. Azure Logging References
  2. Logging
  3. Azure Monitor

Workbooks

Last updated 9 months ago

Workbook Overview

Azure Workbooks are interactive, customizable reports that help security analysts visualize and analyze security-related data. Workbooks can aggregate data from multiple sources, allowing analysts to identify patterns, investigate anomalies, and respond to security threats more effectively.

Key Features of Workbooks

  1. Data Integration: Pull in data from Log Analytics, Azure Security Center, Azure Sentinel, and other data sources.

  2. Querying Capabilities: Use Kusto Query Language (KQL) to write complex queries for detailed data analysis.

  3. Flexible Visualizations: Create charts, tables, and graphs to visualize data effectively.

  4. Templates: Leverage pre-built templates for common security scenarios and customize them as needed.

Workbook Setup

Step 1: Access Azure Monitor

  1. Log in to Azure Portal: Go to and log in with your credentials.

  2. Navigate to Azure Monitor: Use the search bar at the top to search for "Azure Monitor" and select it from the results.

Step 2: Open Workbooks

  1. Go to Workbooks: In the Azure Monitor overview pane, select Workbooks under the Insights section.

Step 3: Create a New Workbook

  1. Create a New Workbook:

    • Click on the New button to start creating a new workbook.

Step 4: Add and Customize Content

  1. Add a Text Block:

    • Click on the Add button and select Text.

    • Use this block to add descriptions, titles, or any textual content.

    • Example: Title: "Security Event Monitoring", Description: "This workbook provides insights into security-related events."

  2. Add a Query Control for Failed Logins:

    • Click on the Add button and select Query.

    • Select the data source (e.g., Log Analytics) and write your KQL query to fetch the data.

    • Example Query:

      SecurityEvent
      | where EventID == 4625
      | summarize count() by bin(TimeGenerated, 1h), Account
    • Visualize this data using a time chart to show failed login attempts over time.

  3. Add a Query Control for Successful Logins:

    • Add another query block with this KQL query:

      SecurityEvent
      | where EventID == 4624
      | summarize count() by bin(TimeGenerated, 1h), Account
    • Visualize this data using a bar chart to show successful login attempts.

  4. Add a Query Control for High-Severity Alerts:

    • Add a query block with this KQL query:

      SecurityAlert
      | where Severity == "High"
      | summarize count() by bin(TimeGenerated, 1h), AlertName
    • Visualize this data using a pie chart to show the distribution of high-severity alerts.

  5. Add Parameters for Filtering:

    • Click on the Add button and select Parameter to create dynamic inputs for your queries.

    • Define the parameter type (e.g., dropdown for time range, text box for specific account names) and link it to your queries.

Step 5: Configure and Customize Workbook

  1. Arrange and Format:

    • Drag and drop the elements to arrange them in your workbook.

    • Use the formatting options to customize the appearance of your text, queries, and visualizations.

  2. Save the Workbook:

    • Click on the Save button.

    • Provide a name, description, and save it in a specific resource group or subscription.

Step 6: Share and Collaborate

  1. Set Permissions:

    • Go to the Access Control (IAM) section of your workbook and configure permissions to share the workbook with your team.

  2. Share Link:

    • You can also share the workbook by providing a direct link to it within the Azure Portal.

Example Security Event Workbook Scenario

Let’s create a basic workbook to monitor security events like failed logins, successful logins, and high-severity alerts.

  1. Add Text:

    • Add a title "Security Event Monitoring" and a description: "This workbook provides insights into failed and successful login attempts, as well as high-severity security alerts."

  2. Add Failed Login Attempts Query:

    • Add a query block and use the following KQL query:

      SecurityEvent
      | where EventID == 4625
      | summarize count() by bin(TimeGenerated, 1h), Account
    • Visualize this data using a time chart.

  3. Add Successful Login Attempts Query:

    • Add another query block with this KQL query:

      SecurityEvent
      | where EventID == 4624
      | summarize count() by bin(TimeGenerated, 1h), Account
    • Visualize this data using a bar chart.

  4. Add High-Severity Alerts Query:

    • Add another query block with this KQL query:

      SecurityAlert
      | where Severity == "High"
      | summarize count() by bin(TimeGenerated, 1h), AlertName
    • Visualize this data using a pie chart.

  5. Save and Share:

    • Save the workbook and share it with your team.

Azure Portal