Hey guys, im trying to create a dashboard table for all successful logins on the server. But what i additionally need is all successful logins on holidays? But how can i do that with a query?
gsmith
(GSmith)
May 18, 2024, 1:11am
2
hey @xploit41
You can use a pipeline to capture successful logins for weekdays, weekends and for holidays you have to put the correct day/month.
something like this.
I have to give respect to @jan for showing me this. This became the most importent Pipeline we use in multiply environments.
rule "Between 6 PM and 6 AM"
when
( to_long(to_date($message.timestamp, "American/Chicago").hourOfDay) >= 0 AND to_long(to_date($message.timestamp, "American/Chicago").hourOfDay) <= 6 ) OR
( to_long(to_date($message.timestamp, "American/Chicago").hourOfDay) >= 18 AND to_long(to_date($message.timestamp, "American/Chicago").hourOfDay) <= 0 )
then
set_field("trigger_workh…