Need your help with a custom report

(imported topic written by borat91)

Hi,

I am a beginner and have only BES console operator permissions. The BES Console version i work on is 7.1.1.315 and web reports = 7.1.7.10.

I need to create a custom report, or an Analysis inside the BES console with a property that will returns this:

Computer Name | Patch Name |

Hostname01 | MS09-001 |

Hostname02 | MS09-001 |

Hostname03 | MS09-001 |

Hostname01 | MS09-002 |

Hostname02 | MS09-002 |

Hostname03 | MS09-002 |

Hostname01 | MS09-003 |

Hostname02 | MS09-003 |

Hostname03 | MS09-003 |

Hostname0X | MS09-00N |

Hostname0Y | MS09-00N |

Hostname0Z | MS09-00N |

or

Computer Name | Patch Name |

Hostname01 | MS09-001 |

Hostname01 | MS09-002 |

Hostname01 | MS09-003 |

Hostname02 | MS09-001 |

Hostname02 | MS09-002 |

Hostname02 | MS09-003 |

Hostname03 | MS09-001 |

Hostname03 | MS09-002 |

Hostname03 | MS09-003 |

Hostname0N | MS09-00X |

Hostname0N | MS09-00Y |

Hostname0N | MS09-00Z |

If such analysis returns such data, then i will be able to generate a web report and add more properties as columns in the report.

Thank you very much for your help in advance.

(imported comment written by borat91)

Hello,

My current problem with this task is as follows, I would like to build a relevance that will return the following table (above). When I use QnA application (it simply does not support some operators), it does not recognize the following operators “bes fixlets” or “bes computer groups” for example, thus I cannot debug the relevance for analysis or custom web reports.

Thank you in advance.

(imported comment written by BenKus)

Hey borat,

The “bes fixlet”, “bes computer”, and other operators that examine multiple computers are part of “session relevance” that runs in the console (as opposed to QnA, which runs on the agent and uses “client relevance”). Here is how you can run the presentation debugger:

http://support.bigfix.com/cgi-bin/kbdirect.pl?id=508

This is going to be a very long report, but here is what you can do:

Switch your relevance debugger into “Presentation” mode, paste this in:

<?Relevance trs of ((td of item 0 of it & td of name of item 1 of it) of (names of it, relevant fixlets whose (name of it as lowercase starts with "ms") of it) of bes computers ) ?>
Hostname Patch Name

If this works for you, you can put it in a custom report to run in web reports… You can also change the html as you please…

Ben