Microsoft 365 Compliance Mod

Run individual configuration, compliance and security controls or full CIS compliance benchmarks across all your Microsoft 365 tenants.

References

Microsoft 365 provides office apps, extra cloud storage, advanced security, and many more in one convenient subscription basis.

Azure provides on-demand cloud computing platforms and APIs to authenticated customers on a metered pay-as-you-go basis.

CIS Microsoft 365 Benchmark provide a predefined set of compliance and security best-practice checks for Microsoft Office 365 usage.

Steampipe is an open source CLI to instantly query cloud APIs using SQL.

Steampipe Mods are collections of named queries, and codified controls that can be used to test current configuration of your cloud resources against a desired configuration.

Documentation

Benchmarks and controls →
Named queries →

Getting started

Installation

Download and install Steampipe (https://steampipe.io/downloads). Or use Brew:

brew tap turbot/tap
brew install steampipe

Install the Azure Active Directory and the Microsoft 365 plugins with Steampipe:

steampipe plugin install azuread
steampipe plugin install microsoft365

Clone:

git clone https://github.com/turbot/steampipe-mod-microsoft365-compliance.git
cd steampipe-mod-microsoft365-compliance/

Usage

Start your dashboard server to get started:

steampipe dashboard

By default, the dashboard interface will then be launched in a new browser window at http://localhost:9194. From here, you can run benchmarks by selecting one or searching for a specific one.

Instead of running benchmarks in a dashboard, you can also run them within your terminal with the steampipe check command:

Run all benchmarks:

steampipe check all

Run a benchmark:

steampipe check benchmark.cis_v140

Run a specific control:

steampipe check control.cis_v140_1_1_3

Different output formats are also available, for more information please see Output Formats.

Credentials

This mod uses the credentials configured in the Steampipe Azure AD and Microsoft 365 plugins.

Configuration

No extra configuration is required.

Common and Tag Dimensions

The benchmark queries use common properties (like connection_name and tenant_id) and tags that are defined in the form of a default list of strings in the mod.sp file. These properties can be overwritten in several ways:

Copy and rename the steampipe.spvars.example file to steampipe.spvars, and then modify the variable values inside that file

Pass in a value on the command line:

steampipe check benchmark.cis_v140_1_1 --var 'common_dimensions=["connection_name", "tenant_id"]'

steampipe check benchmark.cis_v140_1_1 --var 'tag_dimensions=["Department", "Environment"]'

Set an environment variable:

SP_VAR_common_dimensions='["connection_name", "tenant_id"]' steampipe check control.cis_v140_1_1

SP_VAR_tag_dimensions='["Department", "Environment"]' steampipe check control.cis_v140_1_1_12

Contributing

If you have an idea for additional controls or just want to help maintain and extend this mod (or others) we would love you to join the community and start contributing.

Join our Slack community → and hang out with other Mod developers.

Please see the contribution guidelines and our code of conduct. All contributions are subject to the Apache 2.0 open source license.

Want to help but not sure where to start? Pick up one of the help wanted issues:

turbot/microsoft365_compliance