You're reading from Learn Azure Sentinel Integrate Azure security with artificial intelligence to build secure cloud systems

Product type Paperback

Published in Apr 2020

Publisher Packt

ISBN-13 9781838980924

Length 422 pages

Edition 1st Edition

Tools

Azure

Concepts

Artificial Intelligence

Authors (2):

Gary Bushey

Richard Diver

Preface

1. Section 1: Design and Implementation

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

3. Chapter 2: Azure Monitor – Log Analytics

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

5. Chapter 3: Managing and Collecting Data

6. Chapter 4: Integrating Threat Intelligence

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

8. Chapter 6: Azure Sentinel Logs and Writing Queries

9. Section 3: Security Threat Hunting

10. Chapter 7: Creating Analytic Rules

11. Chapter 8:Introducing Workbooks

12. Chapter 9:Incident Management

13. Chapter 10: Threat Hunting in Azure Sentinel

14. Section 4: Integration and Automation

15. Chapter 11: Creating Playbooks and Logic Apps

16. Chapter 12: ServiceNow Integration

17. Section 5: Operational Guidance

18. Chapter 13: Operational Tasks for Azure Sentinel

19. Chapter 14: Constant Learning and Community Contribution

20. Assessments

21. Other Books You May Enjoy

Chapter 5

You need to filter the StormEvents table by all the states that are set to California (remember the case-sensitive versus not case-sensitive filters) and then get a count of those rows. You could cheat and look at the output of the first two lines of the following code in the ADE, but that isn’t really the best way to get the answer, which is 898:
```
StormEvents
| where State =~ “California”
| summarize count()
```
This entails looking at the StormEvents table and getting just one instance of each State. Use the distinct operator for this:
```
StormEvents
|  distinct State
```
You will need to look at the DamageProperty field in the StormEvents table and make sure it is greater than 10,000 and less than 15,000:
```
StormEvents
| where DamageProperty >10000 and DamageProperty <15000
```
You have three out of the four columns needed in the StormEvents table already. The fourth column, the one for the total amount of damage, can be created by adding the DamageProperty...