Odd sorting behaviour for boot_time

Problem:
I want to sort for systems which haven`t been rebooted since 90 days.
In the past we used the fact uptime_days which is not possible anymore.
The fact system_uptime::days is not exported to foreman via puppet.

So I tried to use boot_time which only allows to sort by day of the month?
e.g boot_time < 10
Shows me host with a boot_time before the 10th of this month
Maybe someone could help me understand this.

Expected outcome:
Something like eg: e.g boot_time > 60d allows me to find systems which have been booted 60 days ago.
Foreman and Proxy versions:
Foreman 3.14 Foreman Proxy 3.14.0
Katello 4.16.3

Distribution and version:
RHEL 9.6
Other relevant data:

I solved the problem with the help of an internal collegue, for anybody who has the same interest.
Use the following Syntax: boot_time < "60 days ago"

1 Like