Failed patch, Member action ID - Session Relevance

Hi all,

I am using session relevance to query the status of patches in a given baseline:

(statuses of results of it, names of computers of results of it, names of it) of member actions of (bes action whose (id of it is ))

  1. I can’t seem to get just the Failed patches.
  2. I would also like to get the member action ID

Is this doable? I feel like I am really close.

Nevermind I was able to get it. Here it is for those looking in the future:

(number of statuses whose(“Failed” = it as string) of results of it, name of it,id of it) of member actions whose(exists statuses whose(“Failed” = it as string) of results of it) of top level bes actions whose(49264 = id of it)

This will give you a list of the number of failed patches, name of the failed patch, and most importantly the member action ID of the failed patch. I am then going to use the REST API call to pull down the exit codes using this:

https://BESserver/api/action/member_action_id>/status

and pick out the exit codes from there.

I am building a dashboard outside of Bigfix to parse that data. I will share when complete.

1 Like