Challenge — Answer the ops manager with KQL

تحدّي — جاوب مدير التشغيل بـ KQL

Three servers ( vm-q1 , vm-q2 , vm-q3 ) already send data to law-chm3 . The operations manager sends you four questions in a chat message and wants each answer as a query result, not a screenshot of a chart you guessed. Write the queries yourself.

The 4 tasks you will do

• Question 1 — "When did each server last check in?"السؤال 1 — "كل سيرفر آخر مرة بعت Heartbeat إمتى؟"
• Question 2 — "Which servers average above 60% CPU?"السؤال 2 — "أنهي سيرفرات متوسط الـ CPU بتاعها فوق 60%؟"
• Question 3 — "Show me the CPU trend"السؤال 3 — "وريني الـ Trend بتاع الـ CPU"
• Question 4 — "Who is the single busiest server?"السؤال 4 — "مين أكتر سيرفر شغال؟"

The lesson it belongs to

• Query and analyze logs with KQL