Web report on excessive uptime

(imported topic written by jeko1791)

Hi,

I’ve been trying to create a custom webr eport that will alert on systems that have exceeded 180 days of uptime. The report would include the computer name, uptime property, OS, etc. We have a property called “Last Reboot Time” with relevance of “now - uptime of operating system” which returns the uptime in the same format as Last Report Time. Web Reports recognizes Last Report Time as a time format and allows you to report “greater than, less than xx days ago” but doesn’t do this with other properties that report a time format.

First question, is there any way to get web reports to recognize other time formatted property results and offer the “greater than/less than xx days ago” filter?

Second question, assuming the answer to #1 above is “No”, how would I create a session relevance clause such that I could schedule a weekly report to only include systems whose “Last Reboot Time” exceeds 180 days. The report would contain columns for Computer Name, Last Reboot Time, and OS at minimum.

(imported comment written by SystemAdmin)

create a relavance called “Last Reboot exceeds 180 days” and use something like this “((uptime of operating system) / day) > 180” then create a scheduled report on the computers that report true to “Last Reboot exceeds 180 days”