Pi-hole
top-clients.kql
Top 10 clients by DNS query count.
// Author: Ian D. Hanley (DevSecOpsDad) | linkedin.com/in/ianhanley | devsecopsdad.com | devsecopsdadattack.com
// Identify the top 10 clients making DNS queries
PiHole
| summarize Count = count() by ClientIP // Aggregate counts by client IP
| top 10 by Count // Select the top 10 clients by count