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” )
( 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
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?
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”.
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?