Home
%3CLINGO-SUB%20id%3D%22lingo-sub-1031820%22%20slang%3D%22en-US%22%3EIngest%20Office%20365%20DLP%20Events%20into%20Azure%20Sentinel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1031820%22%20slang%3D%22en-US%22%3E%3CP%3EHaving%20different%20use%20cases%20for%20SIEM%20is%20very%20interesting%2C%20and%20it%20is%20incredible%20to%20work%20with%20customers%20and%20partners%20on%20them.%20In%20one%20of%20my%20engagements%2C%20a%20customer%20asked%20about%20the%20possibility%20of%20ingesting%20Office%20365%20DLP%20into%20Azure%20Sentinel.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBefore%20I%20dig%20into%20details%2C%20lets%20me%20explain%20where%20one%20can%20get%20Office%20365%20DLP%20events%20apart%20from%20Azure%20Sentinel.%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EIn%20Security%20and%20Compliance%20Center%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fcompliance%2Fview-the-dlp-reports%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Elink%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EAvailable%20via%20PowerShell%20cmdlets%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fcompliance%2Fview-the-dlp-reports%23find-the-cmdlets-for-the-dlp-reports%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Elink%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EOffice%20365%20Activity%20API%20schema%20includes%20DLP%20events%20as%20well%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Foffice-365-management-api%2Foffice-365-management-activity-api-schema%23dlp-schema%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Elink%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20blog%20post%20describes%20a%20step%20by%20step%20guide%20on%20how%20to%20ingest%20Office%20365%20DLP%20events%20into%20Azure%20Sentinel%2C%20and%20how%20to%20use%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EPreparation%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EThe%20following%20tasks%20describe%20the%20needed%20preparation%20steps%3A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3ECreate%20Office%20365%20DLP%20rules%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fcompliance%2Fcreate-a-dlp-policy-from-a-template%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Elink%3C%2FA%3E.%20For%20my%20use%20case%2C%20I%20created%20a%20default%20template%20rule%20called%20%22U.S.%20Finance%20Data%22.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F158818iF3195BE7127F7A43%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_5.png%22%20title%3D%22clipboard_image_5.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%20start%3D%222%22%3E%0A%3CLI%3EFor%20this%20blog%2C%20I%20assume%20that%20an%20Azure%20Sentinel%20instance%20is%20available%20and%20is%20used.%20If%20not%2C%20use%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsentinel%2Fquickstart-onboard%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Elink%3C%2FA%3E%20to%20onboard%20Azure%20Sentinel%20first.%3C%2FLI%3E%0A%3CLI%3EOne%20of%20the%20advantages%20of%20Azure%20Sentinel%20is%20the%20availability%20of%20out%20of%20the%20box%20Data%20Connectors%20for%20Microsoft%20services%20as%20well%20as%20for%203rd%20Party%20vendors.%20Enable%20two%20connectors%20from%20the%20Microsoft%20ecosystem%3A%3COL%3E%0A%3CLI%3E%3CEM%3EAzure%20Activity%20Directory%3C%2FEM%3E%20to%20ingest%20Sign-In%20and%20Audit%20Logs%20from%20Azure%20Active%20Directory%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsentinel%2Fconnect-azure-active-directory%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Elink%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CEM%3EOffice%20365%3C%2FEM%3E%20to%20ingest%20Office%20365%20events%20from%20Exchange%20Online%20and%20SharePoint%20Online%20services-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsentinel%2Fconnect-office-365%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Elink%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3C%2FLI%3E%0A%3CLI%3EMake%20sure%20that%20these%20connectors%20are%20healthy%20and%20events%20are%20ingested%2C%20as%20follow%20a%20sample%20status%20for%20the%20Office%20365%20data%20connector.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F158819i3060998275AA78A9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_6.png%22%20title%3D%22clipboard_image_6.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ESimulation%20and%20validation%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EOnes%20the%20DLP%20policies%20are%20configured%20and%20assigned%20to%20the%20users%2C%20and%20the%20required%20connectors%20are%20enabled%2C%20the%20simulation%20can%20be%20started%20to%20produce%20events%20for%20later%20usage.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EHow%20to%20search%20for%20events%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EOffice%20365%20DLP%20has%20three%20types%20of%20events%20that%20are%20ingested%20into%20Log%20Analytics%20workspace%20and%20are%20available%20for%20search.%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EDlpRuleMatch%20-%20This%20indicates%20a%20rule%20was%20matched.%20These%20events%20exist%20in%20both%20Exchange%20and%20SharePoint%20Online%20and%20OneDrive%20for%20Business.%20For%20Exchange%2C%20it%20includes%20false%20positives%20and%20overrides%20information.%20For%20SharePoint%20Online%20and%20OneDrive%20for%20Business%2C%20false%20positives%20and%20overrides%20generate%20separate%20events.%3C%2FLI%3E%0A%3CLI%3EDlpRuleUndo%20-%20These%20only%20exist%20in%20SharePoint%20Online%20and%20OneDrive%20for%20Business.%20They%20indicate%20a%20previously%20applied%20policy%20action%20has%20been%20%22undone%22%20%E2%80%93%20either%20because%20of%20false-positive%2Foverride%20designation%20by%20the%20user%20or%20because%20the%20document%20is%20no%20longer%20subject%20to%20policy%2C%20due%20to%20policy%20change%20or%20change%20in%20the%20document%20content.%3C%2FLI%3E%0A%3CLI%3EDlpInfo%20-%20These%20only%20exist%20in%20SharePoint%20Online%20and%20OneDrive%20for%20Business%20and%20indicate%20a%20false%20positive%20designation%2C%20but%20no%20action%20was%20%22undone.%22%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EIn%20my%20example%2C%20I%20looked%20for%20DLP%20events%20in%20SharePoint%20Online%2C%20and%20the%20%22DLPRuleMatch%22%20type.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F158820i96D965DCD6B7CCCD%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_7.png%22%20title%3D%22clipboard_image_7.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EWorkbook%20for%20interactive%20reports%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EAzure%20Sentinel%20can%20use%20the%20ingested%20data%20with%20out%20of%20the%20box%20dashboards%20as%20well%20as%20for%20customized%20dashboards.%20For%20my%20purpose%2C%20I%20used%20the%20SharePoint%20%26amp%3B%20OneDrive%20dashboard%2C%20which%20is%20available%20as%20part%20of%20the%20Office%20365%20data%20connector.%20For%20Office%20365%2C%20Azure%20Sentinel%20has%20two%20additional%20dashboards%3A%20%22Office%20365%22%20and%20%22Exchange%20Online%22.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20view%20the%20events%2C%20just%20open%20the%20SharePoint%20and%20OneDrive%20workbook%20and%20search%20for%20DLPRuleMatch%20events.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F158821i123164F21121C012%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_8.png%22%20title%3D%22clipboard_image_8.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ESummary%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EAzure%20Sentinel%20is%20limitless%20and%20can%20cover%20many%20use%20cases%2C%20for%20example%2C%20the%20one%20shown%20in%20this%20blog%20post.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1031820%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3ELearn%20how%20to%20use%20Office%20365%20DLP%20events%20in%20Azure%20Sentinel.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F158816i71D72F29BCEE2BA4%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_4.png%22%20title%3D%22clipboard_image_4.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1031820%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Sentinel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EInvestigation%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1034725%22%20slang%3D%22en-US%22%3ERe%3A%20Ingest%20Office%20365%20DLP%20Events%20into%20Azure%20Sentinel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1034725%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20450px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F159045i70F0DC8CF38920F6%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22canstockphoto8307832.jpg%22%20title%3D%22canstockphoto8307832.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83hai%20hello%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1034743%22%20slang%3D%22en-US%22%3ERe%3A%20Ingest%20Office%20365%20DLP%20Events%20into%20Azure%20Sentinel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1034743%22%20slang%3D%22en-US%22%3E%3CP%3E9854599128%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1034751%22%20slang%3D%22en-US%22%3ERe%3A%20Ingest%20Office%20365%20DLP%20Events%20into%20Azure%20Sentinel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1034751%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20634px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F159048i88D6B46934BBBE88%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22sky-earth-galaxy-universe.jpg%22%20title%3D%22sky-earth-galaxy-universe.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83Alls%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1051469%22%20slang%3D%22en-US%22%3ERe%3A%20Ingest%20Office%20365%20DLP%20Events%20into%20Azure%20Sentinel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1051469%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20code%20example%20where%20you%20are%20searching%20for%20%22DLPRuleMatch%22%20why%20do%20you%20do%20use%20%3CSTRONG%3Ewhere%20Operation%20contains%20%22DLP%22%26nbsp%3B%3C%2FSTRONG%3Ebefore%26nbsp%3B%3CSTRONG%3Ewhere%20Operation%20%3D%3D%20%22DLPRuleMatch%22%3C%2FSTRONG%3E%26nbsp%3B%20%3F%26nbsp%3B%20%26nbsp%3BDoes%20that%20make%20the%20query%20faster%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Having different use cases for SIEM is very interesting, and it is incredible to work with customers and partners on them. In one of my engagements, a customer asked about the possibility of ingesting Office 365 DLP into Azure Sentinel.

 

Before I dig into details, lets me explain where one can get Office 365 DLP events apart from Azure Sentinel.

  • In Security and Compliance Center - link
  • Available via PowerShell cmdlets - link
  • Office 365 Activity API schema includes DLP events as well - link

 

This blog post describes a step by step guide on how to ingest Office 365 DLP events into Azure Sentinel, and how to use it.

 

Preparation

The following tasks describe the needed preparation steps:

  1. Create Office 365 DLP rules - link. For my use case, I created a default template rule called "U.S. Finance Data".

clipboard_image_5.png

 

  1. For this blog, I assume that an Azure Sentinel instance is available and is used. If not, use this link to onboard Azure Sentinel first.
  2. One of the advantages of Azure Sentinel is the availability of out of the box Data Connectors for Microsoft services as well as for 3rd Party vendors. Enable two connectors from the Microsoft ecosystem:
    1. Azure Activity Directory to ingest Sign-In and Audit Logs from Azure Active Directory - link
    2. Office 365 to ingest Office 365 events from Exchange Online and SharePoint Online services- link
  3. Make sure that these connectors are healthy and events are ingested, as follow a sample status for the Office 365 data connector.

clipboard_image_6.png

 

Simulation and validation

Ones the DLP policies are configured and assigned to the users, and the required connectors are enabled, the simulation can be started to produce events for later usage.

 

How to search for events

Office 365 DLP has three types of events that are ingested into Log Analytics workspace and are available for search.

  • DlpRuleMatch - This indicates a rule was matched. These events exist in both Exchange and SharePoint Online and OneDrive for Business. For Exchange, it includes false positives and overrides information. For SharePoint Online and OneDrive for Business, false positives and overrides generate separate events.
  • DlpRuleUndo - These only exist in SharePoint Online and OneDrive for Business. They indicate a previously applied policy action has been "undone" – either because of false-positive/override designation by the user or because the document is no longer subject to policy, due to policy change or change in the document content.
  • DlpInfo - These only exist in SharePoint Online and OneDrive for Business and indicate a false positive designation, but no action was "undone."

In my example, I looked for DLP events in SharePoint Online, and the "DLPRuleMatch" type.

clipboard_image_7.png

 

 

Workbook for interactive reports

Azure Sentinel can use the ingested data with out of the box dashboards as well as for customized dashboards. For my purpose, I used the SharePoint & OneDrive dashboard, which is available as part of the Office 365 data connector. For Office 365, Azure Sentinel has two additional dashboards: "Office 365" and "Exchange Online".

 

To view the events, just open the SharePoint and OneDrive workbook and search for DLPRuleMatch events.

 

clipboard_image_8.png

 

Summary

Azure Sentinel is limitless and can cover many use cases, for example, the one shown in this blog post.

1 Comment
Contributor

In the code example where you are searching for "DLPRuleMatch" why do you do use where Operation contains "DLP" before where Operation == "DLPRuleMatch"  ?   Does that make the query faster?