KQL 101

1. How many employees work at FramtidX?

Ans: ✅ 755

Employees
| count

1. What is the CEO’s name?

Ans: ✅ Johanna Karlsson

1. How many emails did Mona Hunter receive?

Ans: 24

Employees
| where name == "Mona Hunter"
| project email_addr

Email
| where recipient == "[email protected]"
| count 

1. How many distinct senders were seen in the email logs from techinnovators.io?

Ans: ✅ 675

Email
| where sender has "techinnovators.io"
| distinct sender
| count

1. How many distinct websites did Mona Hunter visit?

Ans: ✅ 46

find Mona Hunter Ip 1st

OutboundNetworkEvents
| where src_ip == "10.10.0.131"
| distinct url
| count