Baseline, applicable computers, and how to filter on computer group

Content Authoring
1

I have a simple relevance below where I’m filtering on the baseline name of “custom baseline.” Notice I get four records back with the last column representing the name of the computer group of applicable computers. I simply want to be able to filter on that file and only include values = “Windows.” I’ve tried everything and cannot add this simple filter. Does anyone know how I can add this filter? Thanks!

(
name of it , id of it , Names of Applicable Computers of it as string , Names of BES Computer Groups of Applicable Computers of it as string
)
of bes baseline
whose
(
(
Name of it as string as lowercase = “custom baseline”
)
)

How can I only include the two records below that are “Windows” computer group?

Results:
custom baseline,2373,STCBOX,Windows
custom baseline,2373,STCBOX,Windows
custom baseline,2373,STCLNX,Linux
custom baseline,2373,STCLNX,Linux

2

You are reporting just one baseline, but it is relevant to 2 groups * 2 computers - hence 4 results.

Not quite sure what you use case is but this seems (to me) to be what you want

	(
		name of it , id of it , names of applicable computers 
		whose
		(
			exists bes computer group 
			whose
			(
				name of it = "Windows" 
			)
			of it 
		)
		of it 
	)
	of elements of set of bes fixlets 
	whose
	(
		baseline flag of it 
	and
		name of it = "custom baseline" 
	)

I hope the baseline name and group names are just for the purpose of showing your code

3

Hi trn, I pasted your code into my Relevance tester and the syntax was fine but it came back with zero rows. Do you have a slight adjustment that would get this working.

Also, here are two side questions:

  1. I see many resources online for how relevance works but there is still a steep learning curve, at least for me. Is there any teaching resources that are spectacular where I can learn this better? I’m very good with SQL and I wish I could just do some joins of the session relevance structures.
  2. As an example, I’d really like my relevance working in this post but it would be even better if I could get things associated with this content as well. For example, extractracting the components (fixlets, tasks) from the baseline. Any suggestions or examples of connecting baseline to computer groups and also get the components associated with those at the same time?

Thanks in advance!
Todd

p.s., I mostly use the Bigfix developer site (https://developer.bigfix.com/relevance), the Bigfix Session relevance tester, and the Excel connector to get what I need.