Baseline relevance with custom properties

Reporting
1

(imported topic written by Bill.Ehardt)

I’m trying to create a custom report for a baseline that shows computer, relevant fixlets of the baseline, and a few custom properties, like OS, some registry asset values, etc. The plan is to make a dropdown field with Baselines then report back all the information needed (including Bes Properties). I can handle the dropdown/scripting portion, I just need some ideas on the relevance portion

I’ve gotten as far as this based on baseline in the session relevance tester:

(names of elements of applicable computer set of it as string,names of it as string) of components of component group of bes fixlets whose (baseline flag of it = 

true and name of it = 
"October 2010 Microsoft Baseline")

Any tips on say, how to add OS name?

2

(imported comment written by Lee Wei)

Here is a statement with some examples for the different types of properties that you might need.

Operating System and Last Report Time are attributes of a BES Computer, so you can use them directly.

IP Addresses demonstrates treatment of a property where there might be multiple results.

License Type is an example of extracting any properties, including those you have created your own.

(( name of it, operating system of it, last report time of it, concatenations 
"; " of (ip addresses of it as string), values of results from (bes property whose (name of it = 
"License Type")) of it ) of elements of applicable computer set of it as string, names of it as string) of components of component groups of bes fixlets whose ( baseline flag of it = 

true and name of it = 
"October 2010 Microsoft Baseline")
3

(imported comment written by Bill.Ehardt)

Awesome, ty… but I can’t seem to format into TRS and TDs… I’m assuming because we have fixlet names, applicable computer names, and a whole bunch of nested properties?

How can I pull them apart so I can format them correctly?

4

(imported comment written by Lee Wei)

Here is an example on how I would do it.

(html 
"<table>" & it & html 
"</table>") of concatenations of trs of ( td of name of item 0 of it & td of operating system of item 0 of it & td of (last report time of item 0 of it as string) & td of concatenation 
"; " of (ip address of item 0 of it as string) & td of value of results from (bes property whose (name of it = 
"CPU")) of item 0 of it & td of item 1 of it ) of (elements of applicable computer set of it, names of it) of components of component groups of bes fixlets whose ( baseline flag of it = 

true and name of it = 
"October 2010 Microsoft Baseline")
5

(imported comment written by Bill.Ehardt)

This is awesome, one final question, is there any way to do a "if bes property exists then bes property else " ?

TY so much for your assistance!

6

(imported comment written by Lee Wei)

Do you mean if the BES Property exists, or if a computer is returning some values?

Here is an example of making sure that if a computer does not report on a property, we return n/a instead.

html 
"<table>" & it & html 
"</table>") of concatenations of trs of ( td of name of item 0 of it & td of operating system of item 0 of it & td of (last report time of item 0 of it as string) & td of concatenation 
"; " of (ip address of item 0 of it as string) & (

if (exists value of results from (bes property whose (name of it = 
"My Custom Property")) of item 0 of it) then (td of value of results from (bes property whose (name of it = 
"My Custom Property")) of item 0 of it) 

else (td of 
"n/a")) & td of item 1 of it ) of (elements of applicable computer set of it, names of it) of components of component groups of bes fixlets whose ( baseline flag of it = 

true and name of it = 
"October 2010 Microsoft Baseline")