Mike Rockwell (Progress Software) asked a question.
Devices Collecting Disk utilization for C: or D: drive
This Dynamic Group will show all devices with a C: or D: drive disk utilization. If you want to change the drives or add more, just edit the WHERE clause
- SELECT DISTINCT PivotStatisticalMonitorTypeToDevice.nDeviceID
- FROM PivotStatisticalMonitorTypeToDevice INNER JOIN
- StatisticalDiskIdentification ON PivotStatisticalMonitorTypeToDevice.nPivotStatisticalMonitorTypeToDeviceID = StatisticalDiskIdentification.nPivotStatisticalMonitorTypeToDeviceID
- WHERE (StatisticalDiskIdentification.sDescription LIKE N'C:%') OR
- (StatisticalDiskIdentification.sDescription LIKE N'D:%')