Microsoft Office 365 Reporting Add-on for Splunk
Splunk AppInspect Passed
Admins: Please read about Splunk Enterprise 8.0 and the Python 2.7 end-of-life changes and impact on apps and upgradeshere.
Overview
Details
This add-on collects Message Trace data from Microsoft Office 365 including the following:
Sender
Recipient
Subject
To IP Address
From IP Address
Size
Date Received
Sender
Recipient
Subject
To IP Address
From IP Address
Size
Date Received
Microsoft Office 365 Reporting Add-on for Splunk
This add-on collects Message Trace data from Microsoft Office 365 including the following:
- Sender
- Recipient
- Subject
- To IP Address
- From IP Address
- Size
- Date Received
About
- Version: 1.1.0
- Vendor Products: Microsoft Office 365 Reporting Message Trace Report
- Splunk platform versions: 6.5 and later
- Platforms: Platform independent
- Visible: Yes, this add-on contains configuration
Prerequisites
- Office 365 Subscription
- The account you use to access the reports must have administrative permissions in the Office 365 organization. This report requires the user to be assigned to the View-Only Recipients role.
Installing
Where to install this add-on
Unless otherwise noted, all supported add-ons can be safely installed to all tiers of a distributed Splunk platform deployment. See Where to install Splunk add-ons in Splunk Add-ons for more information.
This table provides a reference for installing this specific add-on to a distributed deployment of Splunk Enterprise.
| Splunk platform component | Supported | Required | Comments |
|---|---|---|---|
| Search Heads | Yes | Yes | This add-on contains search-time knowledge. It is recommended to turn visibility off on your search heads to prevent data duplication errors that can result from running inputs on your search heads instead of (or in addition to) on your data collection node. |
| Heavy Forwarders | Yes | No (but recommended) | It is recommended to install this add-on on a heavy forwarder for data collection. Data collection should be configured in only 1 place to avoid duplicates. |
| Indexers | Yes | No | Not required as the parsing operations occur on the forwarders. |
| Universal Forwarders | No | No | Universal forwarders are not supported for data collection because the modular inputs require Python and the Splunk REST handler. |
Configuration
Ensure the prerequisites are met above.
- Access Splunk Web on the node of your Splunk platform installation that collects data for this add-on.
- Launch the add-on, then click the Inputs menu item > Create New Input
- Give the input a name.
- Enter an interval (how often this input collects data).
- Select an index.
- Select an input mode.
- Continuously Monitor will poll for new data based on the interval
- Index Once requires a start date and end date and will only index the data in the given date range.
- Enter an Office 365 account with appropriate permissions to retrieve message traces.
- Enter the password for the Office 365 account.
- Specify the Query window size (minutes). When Continuously Monitor is selected, each time this input runs a start date is calculated for the Office 365 API query. The end date for the Office 365 API query will be the calculated start date plus the number of minutes specified by this parameter. For example, if the calculated start date is 2018-01-01T00:00:00 (midnight on January 1, 2018), the end date for the query will be 2018-01-01T00:01:00 (one hour after midnight) if the query window size is 60 minutes.
- Specify the Delay throttle (minutes). Microsoft may delay trace events up to 24 hours and events are not guaranteed to be sequential during this delay ( reference ). This parameter specifies how close to "now" the end date for a query may be (where "now" is the time that the input runs). Continuing from the example above, if "now" is 2018-01-01T00:02:00 (two minutes after midnight) and the delay throttle is 60 minutes, the input will exit because the end date for the query is only 1 minute away from "now". Each time the input runs, the input will exit and do nothing until the end date is at least 60 minutes away from "now".
- Select a Start date/time to specify how far back to go when initially collecting data. This parameter is optional when Continuously Monitor is selected, but the parameter is required when Index Once is selected.
- Specify an End date/time if Index Once is selected.
Query Window Logic Diagram
CIM Compliance
Version 4.8.0
- Email model
Release Notes
Version 1.1.0
- Added controls for query window size and delay throttle
- Added "Index Once" functionality
- Added proxy support
- Moved authentication parameters to the input to support multiple environments
- Changed the default query start date from 7 to 29 days in the past due to O365 API changes
- Bug fix for recursively gathering message traces
Version 1.0.0
- Initial release
Privacy
Use of this add-on is permitted subject to your obligations, including data privacy obligations, under your agreement with Splunk and Splunk's Privacy Policy.
Contributors
- Jason Conger
- Luke Netto
- Adam Balogh
- Tetsuya Uemura
Third-party software attributions
See README.md file in the package.
Release Notes
Version 1.1.0
May 24, 2018
* Added controls for query window size and delay throttle
* Added "Index Once" functionality
* Added proxy support
* Moved authentication parameters to the input to support multiple environments
* Changed the default query start date from 7 to 29 days in the past due to O365 API changes
* Bug fix for recursively gathering message traces
Version 1.0.1
Oct. 30, 2017
Updates to props.conf for better time stamp recognition.
Updated UTC timestamp handling.
Version 1.0.0
Sept. 20, 2017