Bes computer action status- Need help!

(imported topic written by cstoneba)

Can someone, anyone, please help me?

I need a report that displays a computer names and a breakdown of action statuses they took for multiple baselines.

Computer Fixed Failed PendingRestart

comp123 5 2 0

This is what I have so far, but because there are multiple open actions results, it gives me back a seperate result for each action the server took, not putting them together on a single line.

code

( name of computer of it as string & ", " & id of computers of it as string & ", " & number of relevant fixlets whose (name of it as lowercase contains “duppong” AND baseline flag of it) of computer of it as string & ", " & (if (exists value of (results (computer of it, (bes property “RAM”))) of it ) then (value of (result (computer of it, bes property “RAM”))) else “No”) & ", " & (number of statuses whose (it = bes action status fixed) of it as string) & ", " & (number of statuses whose (it = bes action status failed) of it as string) & ", " & (if (number of statuses whose (it = bes action status failed) of it as string > “0”) then (“FAILIDHERE”) else “NoFailIDs” ) & ", " & (number of statuses whose (it = bes action status pending restart) of it as string ) & ", " & name of action of it ) of results of bes actions whose (name of it as lowercase contains “blah” AND state of parent group of it = “Open” )

code

(imported comment written by Lee Wei)

Here is an example you can try:

( name of it & 
", " & id of it as string & 
", " & (value of property results whose (name of property of it = 
"RAM") of it | 
"None") & 
", " & (it as string) of number of action results whose ( name of action of it as lowercase contains 
"duppong" and state of parent group of action of it = 
"Open" and status of it = bes action status fixed) of it & 
", " & (it as string) of number of action results whose ( name of action of it as lowercase contains 
"duppong" and state of parent group of action of it = 
"Open" and status of it = bes action status failed) of it  & 
", " & (it as string) of number of action results whose ( name of action of it as lowercase contains 
"duppong" and state of parent group of action of it = 
"Open" and status of it = bes action status pending restart) of it ) of bes computers

Lee Wei

(imported comment written by cstoneba)

perfect! thank you very much.

(imported comment written by cstoneba)

after my 7 baselines ran, all 7 are returning in the column with a status of Fixed, however when I look at the actions in the console, 3/7 have a status of “Pending Restart”. Why does that reflect in the column counts of Fixed, Failed, Pending Restart?

(imported comment written by Lee Wei)

A baseline does not have the “fixed” status, rather individual computers will report different statuses.

What are you looking at in the Console?

(imported comment written by cstoneba)

In the console, I’m looking at the Action History tab of a bes computer. It shows 7 baseline actions. 3 have a status of Pending Restart, however the report above just shows 7 results with a status of “fixed”.

(imported comment written by cstoneba)

I guess the problem I’m having is that the report code above is returning the results of the sub components of the baseline, not the actual overall baseline status (which is what I wanted). And I only want to show the status of the baselines that have a name of “blah”). Is that possible?