Actions ran today?

(imported topic written by rpedregon)

Hello, I am still fairly new to Relevance, so please excuse me if this is a simple minded question.

I am trying to create a report that will show actions that were ran today and have it scheduled. Here is my relevance:

(name of it, name of issuer of it, time issued of it) of bes actions whose (time issued of it > ("{now}" as time - 1*day))

when I use this I get nothing returned, but if I use a specific date I will get data back to me:

(name of it, name of issuer of it, time issued of it) of bes actions whose (time issued of it > (“18 Jan 2012 00:48:11 -0800” as time - 1*day))

this statement will return information.

PLEASE HELP!!!

(imported comment written by JasonHonda)

You want to do this instead.

(name of it, name of issuer of it, time issued of it) of bes actions whose (time issued of it > (now - 1*day))

now is already a time object and can be referenced directly. When all in relevance you don’t need the {}. That is relevance substitution in other areas like in action script.

(imported comment written by rpedregon)

That worked perfect. thank you so much for the help!

(imported comment written by SystemAdmin)

hi,

thanks very good.

Is it possible to see also the computer name who the action was installed?

Thanks Andi

(imported comment written by SystemAdmin)

hi,

thanks very good.

Is it possible to see also the computer name on which the action was installed?

Thanks Andi

(imported comment written by SystemAdmin)

(names of computers of results of it,name of it, name of issuer of it, time issued of it) of bes actions whose (time issued of it > (now - 1*day))

(imported comment written by SystemAdmin)

oh, thank you

Is it possible to list also the start/time and end date/time in the query?

Thanks Andi

(imported comment written by SystemAdmin)

hi,

this query is not workin, the result is alway 0 irmes returned:

(names of computers of results of it,name of it, name of issuer of it, time issued of it) of bes actions whose (time issued of it > (now - 1*day))

Have anyone an idea?

Thanks Andi

(imported comment written by MrFixit)

The query looks fine and works for me. Are you testing in the presentation debugger or Web Reports QNA?

(imported comment written by tleason)

When I ran the relevance showing all actions that ran last night I got the full list. However, when I ran the version that showed the endpoint, I only got a list of machines from just one action. Not the entire list. Did I miss something?

(imported comment written by SystemAdmin)

I don’t want to go off this thread but is there a way to just list the actions for one particular machine?

GearMesh

(imported comment written by Lee Wei)

GearMesh,

Yes we can do that in Relevance.

What has discussed above is the BES Action object.

When computers respond to an Action, we get the BES Action Result object.

BES Action Result objects can be created in the following ways:

action results of : bes action result

result <( bes action, bes computer )>: bes action result

result <( bes computer, bes action )>: bes action result

result from of : bes action result

result from of : bes action result

results of : bes action result

It has the following properties:

action of : bes action

apply count of : integer

computer of : bes computer

detailed status of : string

line number of : integer

retry count of : integer

status of : bes action status

So we can write a statement like the following:

( name of action of it, time issued of action of it, name of computer of it, status of it ) of results from (bes actions) of (bes computer whose (name of it = 
"MyComputer"))

(imported comment written by SystemAdmin)

That worked perfectly.

I added a few more objects to get the full information of the actions ran:

(

name of action of it,

id of actions of it,

state of actions of it,

time issued of action of it,

status of it,

(if (exists source fixlet of it) then (if (name of site of source fixlet of it = “ActionSite”) then (“Master Action Site”) else (display name of site of source fixlet of it)) else (if (operator site flag of it) then (name of issuer of it & “'s Operator Site”) else (“Master Operator Site”))) of action of it,

(if (exists issuer of actions of it) then (name of issuer of actions of it) else (“None”)),

(if (it) then (“Action Group”) else (“Single Action”)) of multiple flag of actions of it,

name of computer of it) of results from (bes actions) of (bes computer whose (name of it = “MyComputerName”)

)

GearMesh

(imported comment written by dbhambri)

Can someone please help me, on how Stagger works in BigFix.

I need to target a 500 MB package to 16000 machines and I want to cover 1000 machines per week, please suggest what should be the stagger time be specified.

(imported comment written by Lee Wei)

Dalip,

“Stagger action start times over” does not provide the precise control you have described.

When you specify the number of minutes (X minutes) in this option, all the computers receiving the Action will randomly picked a time from 0 - X.

The randomness will ensure that the Actions will be distributed across the time span, but we don’t know exactly how many computers are taking actions, except to make a calculated guess.

Lee Wei

Hello,
both work for me.
First relevance:
(names of computers of results of it,
name of it,
name of issuer of it,
state of it,
time issued of it
) of bes actions whose (time issued of it > (now - 1*day) )

and Second relevance:
(
name of action of it,
id of actions of it,
state of actions of it,
time issued of action of it,
status of it,
(if (exists source fixlet of it) then (if (name of site of source fixlet of it = “ActionSite”) then (“Master Action Site”) else (display name of site of source fixlet of it)) else (if (operator site flag of it) then (name of issuer of it & “'s Operator Site”) else (“Master Operator Site”))) of action of it,
(if (exists issuer of actions of it) then (name of issuer of actions of it) else (“None”)),
(if (it) then (“Action Group”) else (“Single Action”)) of multiple flag of actions of it,
name of computer of it) of results from (bes actions ) of (bes computer whose (name of it = “my computer”))

Is it possible to change this statement of bes actions whose (time issued of it > (now - 1*day) ) instead of (bes computer whose (name of it = “my computer”)) at the second relevance???

Thanks Andreas