Need to create a BigFix API query using session relevance

Content Authoring
1

Hi BigFix Experts,

I am trying to create a BigFix API query using session relevance to retrieve the relevant fixlet patch names for all windows machines in my environment. Specifically, I need to achieve the following:

  1. Extract the first 8 characters of the patch name from relevant fixlets. (Ex- MS24-DEC, MS25-JAN)
  2. Target fixlets from the site named “Patches for Windows.”
  3. Filter the fixlets to include only those with a source severity of “Critical.”
  4. Get results for all machines where the fixlets are relevant.

I’ve attempted to write the query, but I am encountering errors. Please assist.

Note: For Linux we are able to get the remaining patch date from source release date.

2

Based on the criteria provided, the following may be a place to start:

(first 8 of name of it) of bes fixlets whose (display name of site of it = "Patches for Windows" AND fixlet flag of it AND source severity of it = "Critical" AND applicable computer count of it > 0 AND exists source id whose (it as lowercase does not contain "unspecified") of it)

2 Likes
3

Thanks Aram! This query is retrieving all patches without including hostnames. When I attempted to modify it, the result included all patch names against hostnames but did not filter for the relevant ones.

4

Try something like:
(first 8 of name of it, names of elements of applicable computer set of it) of bes fixlets whose (display name of site of it = "Patches for Windows" AND fixlet flag of it AND source severity of it = "Critical" AND applicable computer count of it > 0 AND exists source id whose (it as lowercase does not contain "unspecified") of it)

1 Like
5

Thanks alot ! This really helped. :slight_smile: