Report to show all actions by a Computer Name Specified

Reporting
1

(imported topic written by troz)

Hi. I’m trying to create a custom report to check the status of all actions ran against a certian Computer Name. I’m using the Excel Connector to cheat but it won’t let me double dip by querying both bes property and bes actions. Can anyone help me?

2

(imported comment written by Lee Wei)

Here is a statement to get you started:

( name of action of it, status of it, name of computer of it, values of results from (bes property 
"OS") of computer of it, values of results from (bes property 
"CPU") of computer of it ) of results from (bes actions) of (bes computers whose (name of it = 
"TRADERS"))

The key is to have access to a reference so that you know what object you are working with, and what Properties are available for the Object.

In the case above, the last line produces “BES Action Results”.

http://support.bigfix.com/cgi-bin/inspectorsearch/inspector_search.cgi

If you use the Inspector Search and look for Type as BES Action Results, then we see that BES Action, BES Computer and BES Action are all properties returned from BES Action Result.

Note that the construct BES Property “OS” is dangerous in that if you have duplicate property names, the results become un-deterministic. This is why the Excel Connector uses the ID when it detects that you have duplicates.

Also note that if a property returns no data, you will get empty results, this is also why the Excel Connector has a bunch of IF-THEN-ELSE statements to ensure that even if a property has no data, if will return an alternate value.

Lee Wei