Eventual end result desired for custom report:
Action Name, Computer Name, Status of Action Result, start time (MM/dd/yyyy HH:mm in “EST”), end time (MM/dd/yyyy HH:mm in “EST”) – WHERE – custom bes property “customProperty” of computer contains “string” and Action State != Expired
I’ve been working through this a bit at a time. I can get a lot of it but I’m stuck at formatting the TIME (the date formatting is working). I can get both date and time formatted correctly from the Action itself but NOT from the action results.
I’ve been muddling around with this that I found out on the interwebs:
(
(month of it as two digits & "/" & day_of_month of it as two digits & "/" & year of it as string & " " & ((if hour of it < 12 then hour of it else hour of it - 12) as string & ":" & minute of it as two digits)) of ( (start time of it) in time zone "-0500") | "N/A",
(month of it as two digits & "/" & day_of_month of it as two digits & "/" & year of it as string & " " & ((if hour of it < 12 then hour of it else hour of it - 12) as string & ":" & minute of it as two digits)) of ( (end time of it) in time zone "-0500") | "N/A"
) of results of bes actions whose (id of it = <ACTION_ID>)
This is returning “it used outside of whose clause”. I just can’t find what is causing it.
Note, if I remove the formatting and just use “start time” and “end time”, it resolves w/o error but just plain looks BAD.
Any/All breadcrumbs are welcome. I’m trying to learn, not just be given answers (though answers are appreciated, too, HAHA).