Find Devices With Multiple Physical Disks

This query is designed to find devices that have multiple physical disks. Here's a simple breakdown of what it does:

1. Data Source: It starts with a table or dataset called DiskDrive, which contains information about physical disks on various devices.

2. Summarize: It groups the data by each device and counts the number of physical disks associated with each device. This is done using the summarize function, which creates a new column called DiskCount that holds the count of disks for each device.

3. Filter: It then filters the results to only include devices that have more than one disk. This is achieved with the where clause, which specifies that only devices with a DiskCount greater than 1 should be included in the final output.

In summary, the query lists all devices that have more than one physical disk attached to them.