I am trying to get a regionalized report for a action on a baseline. We have a retrieve property for regions, but I am not able to get the report to work.
I can get a report for the results of a action:
number of statuses whose (it = bes action status fixed) of results of bes actions whose (id of it = )
And I can get a report of a number of machines in a specific region:
number of values whose (it = “na”) of results of bes property whose (name of it = “Infrastructure:Location:Sys_Loc_Region”)
But I cannot come up with a way to get the number of fixed machines for any given region on the same report.
number of statuses whose ( it = bes action status fixed ) of ( results ( bes action whose ( id of it = <bes action> ) , item 0 of it ) ) of ( bes computers,it ) whose ( value of results ( item 0 of it, item 1 of it ) contains
"na" ) of bes properties whose ( name of it =
"Infrastructure:Location:Sys_Loc_Region" )
This should do it. Note that with a small alteration to this expression you can drill down to the name of each computer whose is fixed and in a given region.