Converting Action Start time from UTC to EST

Content Authoring
1

I have a session relevance statement that provides me with the exact out put I am looking for. However, since we set our actions to use UTC, I am getting the time and date in UTC. This makes sense, but was wondering if there was a way to convert it to EST for an automation piece we are looking to integrate to place the systems into maintenance mode. The baselines need to be in UTC but want to pull the information like I am doing and then convert the time back to est. Below is my relevance and I have tried a bunch of things but nothing seems to work, so any direction would be great.

</ script

(names of elements of reported computer set of it, name of it, start date of it, start time_of_day of it,end date of it, end time_of_day of it) of top level bes actions whose(multiple flag of it AND "Stopped" = state of it AND name of it contains "BaseLineName")

/>
2

You could be able to take any <time_of_day> object and turn it into <time_of_day> & <time zone>

Like this:

(start time_of_day of it & "-0500" as time zone)

Replacing -0500 with whatever time zone you need.

Bill

3

Thank you very much. I learn something new everyday about session relevance and that is a great thing.

2 Likes
4

Bill,

So the answer you provide to me is a possible solution, but was wondering how I could add a check to my relevance to see it the baseline action has the UTC flag and if so then set time zone to +0400 and if baseline action does not have UTC flag then set time zone to -0400.

The reason is that we have baselines that we execute using UTC and others we execute using local time, and we need to pull the data for a report. Please let me know if you need anymore information.