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.
A reporting function helps generate HTML/PDF reports for individual sites.
The add-in uses the Visual Studio Tools for Office (VSTO) function that natively embeds the solution into Microsoft Excel.
It is only available on Windows.
Requirements
- An account on Malwarebytes OneView.
- Use this link to create the 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. The latest version is v1.4.0.
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.
- DNS Filtering
- Endpoints
- Events
- Exclusions
- Groups
- Installers
- Patch Management
- Policies
- Quarantine
- Schedules
- Sites
- Subscriptions
- Suspicious Activities
- Tasks
- Users
- Vulnerabilities
- Generate summary reports for individual sites.
- Generate an HTML or PDF report that is targeted at end customers.
- The reports are emailed to different recipients.
Releases
The latest version is v1.4.0.
- Changes in version 1.4.0 (2022-10-13)
- Added importing Patch Management, Vulnerabilities, and DNS Filtering data.
- Changes in version 1.3.0 (2022-08-31)
- Fixed errors exporting Subscription data. The server load causes an error that stops the export. Now the Add-in will retry, which usually continues successfully.
- Changes in version 1.2.0 (2022-05-22)
- Removed .tlb file, which was causing an error during installation due to admin permission required.
- Changes in version 1.1.0 (2022-02-18)
- Added first name, last name, and email to Subscription export.
- Fixed bug where feedback HTML is missing from distribution.
- Changed how subscriptions are shown (status and expiration) in the HTML report.
- Changes in version 1.0.0 (2022-02-15)
- Added additional properties to User export, including sites, status, and MFA.
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 help determine 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 loaded when Excel starts.
Screenshots
- Site data is imported from the OneView Cloud server.
- For most objects, a wizard is used to select the sites.
- HTML and PDF summary reports are generated for individual sites.
