Page 1 of 1

Problem with Disk Percent on v1.37.13

Posted: Wed Apr 20, 2022 2:48 pm
by manfzimm
Hi

I'm running ZM v1.37.13

It is not possible to Purge my (nearly) full disk (96 %).

Storage Area matches default
Disk Percent greater than or equal to 90
End Date/Time is not NULL

When I test by using "list matches" the page display not a single event

When I use the "Debug"-button I get this Information:
SQL SELECT E.*,M.Name AS MonitorName,M.DefaultScale
FROM Monitors AS M INNER JOIN Events AS E ON (M.Id = E.MonitorId)
WHERE
E.StorageId regexp '2' and TRUE /*DiskPercent*/ and E.EndDateTime IS NOT NULL ORDER BY Id ASC LIMIT 10

As you see the SQL-satement does not use the "90" for/*DiskPercent*/.....

Is there a solution ?


Thanx

Manfred

Re: Problem with Disk Percent on v1.37.13

Posted: Wed Apr 20, 2022 3:01 pm
by Magic919
Why would it? Surely it's a variable.

Re: Problem with Disk Percent on v1.37.13

Posted: Wed Apr 20, 2022 3:44 pm
by Andyrh
Be sure the storage area is listed in the filter. Otherwise it only looks at the original storage area.

Re: Problem with Disk Percent on v1.37.13

Posted: Wed Apr 20, 2022 4:44 pm
by manfzimm
Thanks for responding.

Yes, it is a variable. And disk usage is shown in the control panel STORAGE --> DEFAULT: 96 %

The storage area is also listed in the filter (dropdown --> DEFAULT).

If I delete the line "Disk Percent" and "LIST MATCHES" shows events.

Re: Problem with Disk Percent on v1.37.13

Posted: Wed Apr 20, 2022 7:01 pm
by dougmccrary
The default limit is 100.
Suggest you try that or even 1000.

Re: Problem with Disk Percent on v1.37.13

Posted: Thu Apr 21, 2022 2:06 pm
by knight-of-ni
moved to the1.37 forum

Re: Problem with Disk Percent on v1.37.13

Posted: Fri Apr 22, 2022 1:55 pm
by iconnor
The Debug button uses different code than the actual filter. What we need \to do here is turn on debugging, restart the filter and check the filter logs to see what the actual SQL is.