As of 2025.2, we can now create recurring maintenance schedules for our nodes and alerts on daily, weekly, or monthly frequencies and assign them accordingly. However, there is no easy way for a user to view which nodes have upcoming maintenance or even just the assigned schedule definition.
Through my own efforts in SWQL, I have tried creating my own query to display this, but the frequencies are stored as CRON expressions, which SWQL has no native way of interpreting that I am aware of. I can only get so far before issues arise with the monthly frequencies.
I would ask that we have the following:
Out of the box Resource on the Node Details page detailing the Maintenance Schedules assigned, duration, and frequency of the maintenance, as well as the next upcoming window for that particular entity.
This should also be available to display either in an out-of-the-box widget for custom class/modern dashboard views, or an easier way implemented into the SWQL schema for us to filter on the CRON expression frequency.
Here is an example of how the frequency is stored in the Orion.Frequencies table:
FrequencyID | DisplayName | CronExpression |
18 | Weekly - every day | 0 0 * * 0,1,2,3,4,5,6 |
19 | Weekly to BDO | 30 9 * * 5 |
21 | Weekdays only | 0 8 * * 1-5 |
22 | Weekdays only | 0 8 * * 1-5 |
24 | Mon thru Fri | 0 8 * * 1,2,3,4,5 |
26 | Weekly | 0 2 * * 6 |
27 | Daily | 1 17 */1 * * |
28 | Weekly | 0 14 * * 4,6 |
