Issue with webreport with data from computers and Content

Reporting
1

(imported topic written by mcyclegar91)

Our report Version is: 8.0.584.0

SInce the change to new interface to the web reports we are unable to create reports which we were able to do before the upgrade.

Scenarios which are not working is.

  1. For a computer report after applying all the filters we are not able to add column for severity from content.

  2. If we create a report based on severity from content then applicable computers column cannot be added.

In other words we cannot work on content and computer together in reports.

This is what we need and any help from custom reports and or how to generate this kind of report will be greatly appreciated.

  1. Report of all applicable computers(linux, windows, Unix) with only relevent fixlets for each computer by its severity and or Category and release date.

Please help me get this report wokking.

Thanks in advance

Mohammed

2

(imported comment written by Lee Wei)

Hi Mohammad,

The attributes that you want seem to be available in Web Reports 8.0.

In the Report List, I chose the standard “Open Vulnerabilities List” report.

Using “Edit Columns” drop list, I am able to add Applicable Computers, as well as the other attributes for the Fixlets including Category, Source Severity and Source Release Date.

The Excel Connector can also extract the data using the “Results of BES Fixlets” object.

http://forum.bigfix.com/viewtopic.php?id=3564

You want to make sure to add 2 filters:

  • Fixlet Flag of Fixlet = True (this will filter out tasks, analysis and baselines)
  • Relevant Flag = True

If you need help with either one, let us know.

Lee Wei

3

(imported comment written by mcyclegar91)

Lee,

Thanks for the update.

I tried the first option and i am able to get the report i need but when i export to excel in place of computer names i get numbers where as i see the names on the web report, Looks like computer names are being replaced with their id’s.

How do i get the computer names in the excel? even if u preview for printing the computer names are being replaced with Numbers.

Looks like the excel connector is a solution for us but when i install the latest one on Vista Business and Office 2007 , i dont see the add in on excel , its neither present in excel options.

I tried installing as admin on default location as well as c:\bfconnector with same results. Logs shows successful instigation

I have installed .NET Framework 4 extended as well.

At this point seems like both the options are not giving me what i need.

Here is the installation log

Add-in Express Registrator Log File: 11/22/2010 14:08:19

Installation directory: C:\bfconnector\

Registrator version: 6.1.3044.0

14:08:19 Starting the add-in registration process.

14:08:19 Loading mscoree.dll

14:08:19 Success.

14:08:19 .NET Framework installation directory:

14:08:19 The latest version of .NET Framework: ‘v4.0.30319’

14:08:19 Loading CLR: v4.0.30319.

14:08:19 Calling CLRCreateInstance method.

14:08:19 Success.

14:08:19 Calling GetRuntime method.

14:08:19 Success.

14:08:19 Calling GetInterface method.

14:08:20 Calling GetInterface method for the CorRuntimeHost interface.

14:08:20 Success.

14:08:20 Starting CLR…

14:08:20 Success.

14:08:20 The CLR v4.0.30319 has been initialized successfully.

14:08:20 Creating a new domain setup.

14:08:20 Success.

14:08:20 Getting the add-in directory.

14:08:20 Success. The directory is ‘C:\bfconnector’

14:08:20 The configuration file is ‘(null)’

14:08:20 The ‘shadow copy’ is disabled.

14:08:20 Creating a new application domain.

14:08:20 Success.

14:08:20 Getting the base directory for the domain.

14:08:20 Success. The directory is ‘C:\bfconnector’.

14:08:20 Searching for the Add-in Express core library.

14:08:20 Success. The ‘AddinExpress.MSO.2005.dll’ file is found.

14:08:20 Creating an instance of the ‘AddinExpress.Deployment.ADXRegistrator’ class.

14:08:20 Assembly identity is ‘AddinExpress.MSO.2005’.

14:08:20 Success.

14:08:20 Unwrapping the instance of the ‘AddinExpress.Deployment.ADXRegistrator’ class.

14:08:20 Success.

14:08:20 Calling the managed registration procedure.

14:08:21 Success.

14:08:21 The add-in registration process is completed with HRESULT = 0.

Please help

Thanks

Mohammed

4

(imported comment written by Lee Wei)

Did you try right clicking on the setup.exe and “Run as administrator”?

It seems to do something different even if you are an Admin, which has to do with UAC.

Looks like you are using Excel 2007.

Please also try enabling the add-in from Excel.

  • Office Button (the big button at the top left corner)
  • Excel Options button
  • Add-Ins section
  • Change drop list from Manage Excel Add-ins to Manage COM Add-ins, click Go button
  • Enable BigFixExcelConnector

If these do not fix your problem, please send me a private message and I can arrange to look at your system.

Lee Wei