Dynamic Reporting

[jlpeppers]

I’m going to try and explain this as best as I can. We have 14 Manual groups where we have servers that are rebooted over a two week period, a group for each day. Here is the problem, I’m trying to report on the groups for each day they are rebooted but I only want the report for the list for that day. For Instance on the second Wednesday of the month I only want that list of machines for that group and not the other 13 groups in web reports. I know I can do 14 individual schedules but that seems inefficient. I’ve been trying to figure out a way to use 1 scheduled report and that will cycle through the days over the 2 week period.

So far I’ve come up with a way to report on the status if it rebooted in the last 2 hours and I’m keying off that property to but if a machine doesn’t come back up I’m missing the one that could potentially have issues. That is why I need it to cycle through the groups based on the current day.

uptime of operating system < 2 * hour

I’m also using this below to only run the report on the first 2 weeks of the month…in combination with the last 2 hours rebooted but like I mentioned, it only reports the machines that come back up and report in.

In the report I’m using System Uptime and Last reboot time…

current date = first Sunday of current month_and_year or current date = first Monday of current month_and_year or current date = first Tuesday of current month_and_year or current date = first Wednesday of current month_and_year or current date = first Thursday of current month_and_year or current date = first Friday of current month_and_year or current date = first Saturday of current month_and_year or current date = first Sunday of current month_and_year + 7 * day or current date = first Monday of current month_and_year + 7 * day or current date = first Tuesday of current month_and_year + 7 * day or current date = first Wednesday of current month_and_year + 7 * day or current date = first Thursday of current month_and_year + 7 * day or current date = first Friday of current month_and_year + 7 * day or current date = first Saturday of current month_and_year + 7 * day

Any ideas or have I confused anyone with what I’m trying to accomplish?

[jgstew]

@jlpeppers

14 Manual groups

Manual Groups are generally a bad idea. It is better to have an equivalent automatic group.

@jlpeppers

I know I can do 14 individual schedules but that seems inefficient.

I think that might be the best option.

@jlpeppers

uptime of operating system < 2 * hour

This definitely will not work. You have to use Session Relevance to compute something like that, not regular relevance. You would use boot time of operating system in relevance, and compute uptime with session relevance.

[jgstew]

@jlpeppers

I’m also using this below to only run the report on the first 2 weeks of the month

Hmm, okay.

@jlpeppers

current date = first Sunday of current month_and_year or current date = first Monday of current month_and_year or current date = first Tuesday of current month_and_year or current date = first Wednesday of current month_and_year or current date = first Thursday of current month_and_year or current date = first Friday of current month_and_year or current date = first Saturday of current month_and_year or current date = first Sunday of current month_and_year + 7 * day or current date = first Monday of current month_and_year + 7 * day or current date = first Tuesday of current month_and_year + 7 * day or current date = first Wednesday of current month_and_year + 7 * day or current date = first Thursday of current month_and_year + 7 * day or current date = first Friday of current month_and_year + 7 * day or current date = first Saturday of current month_and_year + 7 * day

This is very confusing and complicated.

Wouldn’t this be the exact same thing:

current day_of_month as integer <= 14

[jlpeppers]

It probably is but that is the best I could come up with my knowledge. I had to self:slight_smile: teach myself to a certain degree so I’m not well versed in relevance language.