You're reading from Microsoft Sentinel in Action Architect, design, implement, and operate Microsoft Sentinel as the core of your security solutions

Product type Paperback

Published in Feb 2022

Publisher Packt

ISBN-13 9781801815536

Length 478 pages

Edition 2nd Edition

Tools

Azure Functions

Concepts

Cybersecurity

Authors (2):

Richard Diver

Gary Bushey

View More author details

Table of Contents (23) Chapters

Preface

1. Section 1: Design and Implementation

2. Chapter 1: Getting Started with Microsoft Sentinel FREE CHAPTER

3. Chapter 2: Azure Monitor – Introduction to Log Analytics

4. Section 2: Data Connectors, Management, and Queries

5. Chapter 3: Managing and Collecting Data

6. Chapter 4: Integrating Threat Intelligence with Microsoft Sentinel

7. Chapter 5: Using the Kusto Query Language (KQL)

8. Chapter 6: Microsoft Sentinel Logs and Writing Queries

9. Section 3: Security Threat Hunting

10. Chapter 7: Creating Analytic Rules

11. Chapter 8: Creating and Using Workbooks

12. Chapter 9: Incident Management

13. Chapter 10: Configuring and Using Entity Behavior

14. Chapter 11: Threat Hunting in Microsoft Sentinel

15. Section 4: Integration and Automation

16. Chapter 12: Creating Playbooks and Automation

17. Chapter 13: ServiceNow Integration for Alert and Case Management

18. Section 5: Operational Guidance

19. Chapter 14: Operational Tasks for Microsoft Sentinel

20. Chapter 15: Constant Learning and Community Contribution

21. Assessments

22. Other Books You May Enjoy

Scalar functions

Scalar functions take a value and perform some sort of manipulation on it to return a different value. They are useful for performing conversions between data types, looking at only part of the variable, and performing mathematical computations.

The ago() function

The ago() function is used to subtract a specific timespan from the current UTC time. Remember that all times stored in the Log Analytics log are based on UTC time, unless they are times in a custom log that are specifically designed not to be. Generally, it is safe to assume that the times stored are based on UTC time.

If I wanted to look for events in StormEvents that ended less than an hour ago, I would use the following command. Note that this command doesn't return any values as the times stored are from 2007:

StormEvents
| where EndTime > ago(1h)

In addition to using h for hours, you can also use d for days, among others.

The rest of the chapter is locked

You're reading from Microsoft Sentinel in Action Architect, design, implement, and operate Microsoft Sentinel as the core of your security solutions

Table of Contents (23) Chapters

Scalar functions

The ago() function

Unlock this book and the full library FREE for 7 days

Authors (2)

Personalised recommendations for you