Cleaning more than 1 drive in one filter?

[IgorA100]

In theory it should work, but I haven't succeeded yet.

Фильтр.JPG (126.16 KiB) Viewed 452 times

Code: Select all

SELECT E.*,M.Name AS MonitorName,M.DefaultScale
FROM Monitors AS M INNER JOIN Events AS E ON (M.Id = E.MonitorId)
WHERE
E.Archived = '0' and TRUE /*ExistsInFileSystem*/ and E.EndDateTime IS NOT NULL and (( E.StorageId = '4' and TRUE /*DiskPercent*/ ) or ( E.StorageId = '5' and TRUE /*DiskPercent*/ )) ORDER BY Id ASC LIMIT 200

The "NAS" disk is only 21% occupied, but the events stored on it fall under the filter selection.

[iconnor]

No it will only look at one of them for the DiskPercent part. Definitely needs improvement.