Export data with the Malwarebytes OneView Excel Add-in with Reporting

What's This?

The Malwarebytes OneView Excel Add-in is for users, typically Managed Service Providers (MSPs) who use the Malwarebytes OneView multi-tenant web console. It uses the public API to export data directly into Microsoft Excel.

There is a reporting function that is useful for generating HTML/PDF reports for individual sites.
The add-in uses the Visual Studio Tools for Office (VSTO) function that embeds the solution into Microsoft Excel natively.

It is only available on Windows.

Requirements

• An account on Malwarebytes OneView.
  • Use this link to create API credentials needed.
• Microsoft Excel 2010, 2013, 2016, 2019, or Office 365 on Windows.
  • (The add-in does not work on macOS because it uses Windows specific Microsoft Office features)
• .NET Framework v4.6.2.

Installation

Download and install the Add in. Latest version is v1.1.0.

• Download the latest Malwarebytes OneView Excel Add-in Web Installer

Support

This is a user community shared utility.
Please post questions and comments on the Malwarebytes Forum.
There is an in product Feedback form that sends emails to the author directly.

Features

• Extract and import the following OneView objects from selected sites.
  • Endpoints
  • Events
  • Exclusions
  • Groups
  • Installers
  • Policies
  • Quarantine
  • Schedules
  • Sites
  • Subscriptions
  • Suspicious Activities
  • Tasks
  • Users
• Generate summary report for individual sites.
  • Generate an HTML or PDF report that is targeted for end customers.
  • The reports be emailed to different recipients.

Releases

Latest version is v1.1.0.

• 1.1.0 (2022-02-19)
  • First release.

Troubleshooting

• The installation folder is located in the following user appdata directory.

  • C:\Users\[user-name]\AppData\Roaming\Malwarebytes\Malwarebytes OneView Excel Add-in [version]

• The installation logs are located in the following directory. They are useful to determine the reasons why the Add-in might not have been attached to Excel correctly.

  • C:\Users\[user-name]\AppData\Local\Temp\Malwarebytes OneView Excel Add-in

  • adxregistrator.log - Contains information about the Add-in being registered with Windows. This happens only once during the initial installation.
  • adxloader.log - Data is logged every time the Add-in is being loaded when Excel starts. 

Screenshots

• Site data imported from the OneView Cloud server.
  
  
  
• For most objects, a wizard is used to select the sites.
  

• HTML and PDF summary report generated for individual sites.