Microsoft Cloud App Security (MCAS) Activity Log in Azure Sentinel

Published 12-16-2020 09:48 AM 8,171 Views
Microsoft

Overview

 

The Microsoft Cloud App Security (MCAS) connector lets you stream alerts and Cloud Discovery logs from MCAS into Azure Sentinel. This will enable you to gain visibility into your cloud apps, get sophisticated analytics to identify and combat cyberthreats, and control how your data travels, more details on enabling and configuring the out of the box MCAS connector (Connect data from Microsoft Cloud App Security)

 

MCAS3.PNG

 

Cloud App Security REST API (URL Structure , Token & Supported Actions)

 

The Microsoft Cloud App Security API provides programmatic access to Cloud App Security through REST API endpoints. Applications can use the API to perform read and update operations on Cloud App Security data and objects.

 

To use the Cloud App Security API, you must first obtain the API URL from your tenant. The API URL uses the following format:

 

 

 

https://<portal_url>/api/<endpoint>

 

 

 

 

To obtain the Cloud App Security portal URL for your tenant, do the following steps:

 

- In the Cloud App Security portal, click the question mark icon in the menu bar. Then, select About. 

 

MCAS1.PNG - In the Cloud App Security about screen, you can see the portal url.

 

MCAS2.PNG

 

Once you have the portal url, add the /api suffix to it to obtain your API URL. For example, if your portal's URL is https://m365x933168.eu2.portal.cloudappsecurity.com, then your API URL is https://m365x933168.eu2.portal.cloudappsecurity.com/api.

 

Cloud App Security requires an API token in the header of all API requests to the server, such as the following:

 

 

 

 

Authorization: Token <your_token_key>

 

 

 

 

 

Where <your_token_key> is your personal API token. For more information about API tokens, see Managing API tokens., here's an example of CURLing MCAS Activity log:

 

MCAS4.PNG

 

The following table describes the actions supported:

 

MCAS5.PNG

 

Where Resource represents a group of related entities, fore more details please visit MCAS Activities API

 

Implementation (MCAS Activity Connector)

 

  • Log in to the Azure tenant, http://portal.azure.com
  • Go to Azure Sentinel > Playbooks
  • Create a new Playbook and follow the below gif / step-by-step guide, the code being uploaded to github repo as well:
    • Add a “Recurrence” step and set the following field, below is an example to trigger the Playbook once a daily basis:
      • Interval: 1
      • Frequency: Day
    • Initialize a variable for the MCAS API Token value, make sure to generate MCAS API Token following this guide
      • Name: MCAS_API_Token
      • Type: String
      • Value: Token QhXXXXBSlodAV9AXXXXXXQlMcFhweXXXXXRXXh1OGkXXkXXkeX
    • Set an HTTP endpoints to Get MCAS Activity data:
    • Parse MCAS Activities data via Json:
      • Parse JSON - MCAS Activities:
        • Content: @{body('HTTP_-_MCAS_Activities_API')}
        • Schema: uploaded to github
    • Initialize an Array Variable:
      • Name: TempArrayVar
      • Type: Array
    • Append to array variable:
      • Name: TempArrayVar
      • Value: @{body('Parse_JSON_-_MCAS_Activities')}
    • Add For each control to iterate MCAS Activities parsed items:
      • Select an output from previous steps: @variables('TempArrayVar')
      • Send the data (MCAS Activity Log) to Azure Sentinel Log analytics workspace via a custom log tables:
        • JSON Request body: @{items('For_each')}
        • Custom Log Name: MCAS_Activity_Log

MCASActivitySentinel-Update.gif

 

Notes & Consideration

 

  • You can customize the parser at the connector's flow with the required and needed attributed / fields based on your schema / payload before the ingestion process, also you can create custom Azure Functions once the data being ingested to Azure Sentinel
  • You can customize the for-each step to iterate MCAS Activity log and send them to the Log Analytics workspace so eventually each activity log will be logged in a separate table's record / row
  • You can build your own detection and analytics rules / use cases,  a couple of MCAS Activities analytics rules will be ready to use at github, stay tuned
  • Couple of points to be considered while using Logic Apps:

 

Get started today!

 

We encourage you to try it now!

You can also contribute new connectors, workbooks, analytics and more in Azure Sentinel. Get started now by joining the Azure Sentinel Threat Hunters GitHub community.

9 Comments
Occasional Contributor

Azure Sentinel is becoming more and more the SIEM to be :) Thanks @Hesham Saad for the clear blog post

Occasional Contributor

Do MCAS API Tokens need to be stored using Key Vault?

Microsoft

Hi @shoando - yes you can for security reasons.

New Contributor

Awesome stuff, although will there be a part 2 of this? Covering the "considerations" section?

Occasional Contributor

Hi @Hesham Saad 

Great Blog - thanks a lot.

 

I have successful implemented the app in my test environment and built another one for the entitity endpoint.

As a next step I'd like to separate the logs to different rows but so far I'm not successful because the for each loop tells me that it needs an array not an object :(

Have you already done this successful and can give me a hint?

 

Thanks Chris

Senior Member

Is there a connector to ingest Workday HCM logs into Sentinel ? 

Senior Member

Hi @Hesham Saad 

 

Is there a connector to ingest Workday HCM logs into Sentinel ? 

Senior Member

Hi @Hesham Saad 

 

Is there a way to ingest  only "Workday HCM" logs from MCAS  into Sentinel ?

 

 

Thanks

Occasional Contributor

Hi @Hesham Saad 

 

Does this also work for the other MCAS URIs, specifically Files?  If it does, does it overcome the 5000 item export limit that is present with the UI export of File policy matches?

%3CLINGO-SUB%20id%3D%22lingo-sub-1849806%22%20slang%3D%22en-US%22%3EMicrosoft%20Cloud%20App%20Security%20(MCAS)%20Activity%20Log%20in%20Azure%20Sentinel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1849806%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EOverview%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThe%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcloud-app-security%2Fwhat-is-cloud-app-security%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-linktype%3D%22absolute-path%22%3EMicrosoft%20Cloud%20App%20Security%3C%2FA%3E%3CSPAN%3E%26nbsp%3B(MCAS)%20connector%20lets%20you%20stream%20alerts%20and%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcloud-app-security%2Ftutorial-shadow-it%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-linktype%3D%22absolute-path%22%3ECloud%20Discovery%20logs%3C%2FA%3E%3CSPAN%3E%26nbsp%3Bfrom%20MCAS%20into%20Azure%20Sentinel.%20This%20will%20enable%20you%20to%20gain%20visibility%20into%20your%20cloud%20apps%2C%20get%20sophisticated%20analytics%20to%20identify%20and%20combat%20cyberthreats%2C%20and%20control%20how%20your%20data%20travels%2C%20more%20details%20on%20enabling%20and%20configuring%20the%20out%20of%20the%20box%20MCAS%20connector%20(%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsentinel%2Fconnect-cloud-app-security%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EConnect%20data%20from%20Microsoft%20Cloud%20App%20Security%3C%2FA%3E)%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MCAS3.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F240689iCA84AA6E7030066A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MCAS3.PNG%22%20alt%3D%22MCAS3.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ECloud%20App%20Security%20REST%20API%20(URL%20Structure%20%2C%20Token%20%26amp%3B%20Supported%20Actions)%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20Microsoft%20Cloud%20App%20Security%20API%20provides%20programmatic%20access%20to%20Cloud%20App%20Security%20through%20REST%20API%20endpoints.%20Applications%20can%20use%20the%20API%20to%20perform%20read%20and%20update%20operations%20on%20Cloud%20App%20Security%20data%20and%20objects.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ETo%20use%20the%20Cloud%20App%20Security%20API%2C%20you%20must%20first%20obtain%20the%20API%20URL%20from%20your%20tenant.%20The%20API%20URL%20uses%20the%20following%20format%3A%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%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3Ehttps%3A%2F%2F%3CPORTAL_URL%3E%2Fapi%2F%3CENDPOINT%3E%3C%2FENDPOINT%3E%3C%2FPORTAL_URL%3E%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ETo%20obtain%20the%20Cloud%20App%20Security%20portal%20URL%20for%20your%20tenant%2C%20do%20the%20following%20steps%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E-%20In%20the%20Cloud%20App%20Security%20portal%2C%20click%20the%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Equestion%20mark%20icon%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bin%20the%20menu%20bar.%20Then%2C%20select%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EAbout%3C%2FSTRONG%3E%3CSPAN%3E.%3C%2FSPAN%3E%26nbsp%3B%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%20image-alt%3D%22MCAS1.PNG%22%20style%3D%22width%3A%20825px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F241047i2CEF88F1BD2C9E1E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MCAS1.PNG%22%20alt%3D%22MCAS1.PNG%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B-%26nbsp%3B%3CSPAN%3EIn%20the%20Cloud%20App%20Security%20about%20screen%2C%20you%20can%20see%20the%20portal%20url.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MCAS2.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F241048iC340D969A445D483%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MCAS2.PNG%22%20alt%3D%22MCAS2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EOnce%20you%20have%20the%20portal%20url%2C%20add%20the%26nbsp%3B%3CCODE%3E%2Fapi%3C%2FCODE%3E%26nbsp%3Bsuffix%20to%20it%20to%20obtain%20your%20API%20URL.%20For%20example%2C%20if%20your%20portal's%20URL%20is%26nbsp%3B%3CCODE%3E%3CA%20href%3D%22https%3A%2F%2Fm365x933168.eu2.portal.cloudappsecurity.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fm365x933168.eu2.portal.cloudappsecurity.com%3C%2FA%3E%3C%2FCODE%3E%2C%20then%20your%20API%20URL%20is%3CCODE%3E%3CA%20href%3D%22https%3A%2F%2Fm365x933168.eu2.portal.cloudappsecurity.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fm365x933168.eu2.portal.cloudappsecurity.com%3C%2FA%3E%3C%2FCODE%3E%3CSTRONG%3E%3CCODE%3E%2Fapi%3C%2FCODE%3E%3C%2FSTRONG%3E.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ECloud%20App%20Security%20requires%20an%20API%20token%20in%20the%20header%20of%20all%20API%20requests%20to%20the%20server%2C%20such%20as%20the%20following%3A%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%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3EAuthorization%3A%20Token%20%3CYOUR_TOKEN_KEY%3E%3C%2FYOUR_TOKEN_KEY%3E%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhere%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CCODE%3E%3CYOUR_TOKEN_KEY%3E%3C%2FYOUR_TOKEN_KEY%3E%3C%2FCODE%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eis%20your%20personal%20API%20token.%20For%20more%20information%20about%20API%20tokens%2C%20see%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcloud-app-security%2Fapi-authentication%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-linktype%3D%22relative-path%22%3EManaging%20API%20tokens%3C%2FA%3E.%2C%20here's%20an%20example%20of%20CURLing%20MCAS%20Activity%20log%3A%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%20image-alt%3D%22MCAS4.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F241051i0671E38B14DB2500%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MCAS4.PNG%22%20alt%3D%22MCAS4.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20following%20table%20describes%20the%20actions%20supported%3A%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%20image-alt%3D%22MCAS5.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F241053iA8F46F4FA285556D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MCAS5.PNG%22%20alt%3D%22MCAS5.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EWhere%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EResource%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Brepresents%20a%20group%20of%20related%20entities%2C%20fore%20more%20details%20please%20visit%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcloud-app-security%2Fapi-activities%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EMCAS%20Activities%20API%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSTRONG%3EImplementation%20(MCAS%20Activity%26nbsp%3BConnector)%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ELog%20in%20to%20the%20Azure%20tenant%2C%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22http%3A%2F%2Fportal.azure.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttp%3A%2F%2Fportal.azure.com%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EGo%20to%20Azure%20Sentinel%20%26gt%3B%20Playbooks%3C%2FLI%3E%0A%3CLI%3ECreate%20a%20new%20Playbook%20and%20follow%20the%20below%20gif%20%2F%20step-by-step%20guide%2C%20the%20code%20being%20uploaded%20to%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fhesaad%2FAzureSentinelHub%2Fblob%2Fmaster%2FMCAS_Activity_Playbook%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Egithub%20repo%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eas%20well%3A%3CUL%3E%0A%3CLI%3E%3CSPAN%3EAdd%20a%20%E2%80%9CRecurrence%E2%80%9D%20step%20and%20set%20the%20following%20field%2C%20below%20is%20an%20example%20to%20trigger%20the%20Playbook%20once%20a%20daily%20basis%3A%3C%2FSPAN%3E%3CUL%3E%0A%3CLI%3EInterval%3A%201%3C%2FLI%3E%0A%3CLI%3EFrequency%3A%20Day%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3EInitialize%20a%20variable%20for%20the%20MCAS%20API%20Token%20value%2C%20make%20sure%20to%20generate%20MCAS%20API%20Token%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcloud-app-security%2Fapi-authentication%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Efollowing%20this%20guide%3C%2FA%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CUL%3E%0A%3CLI%3EName%3A%20MCAS_API_Token%3C%2FLI%3E%0A%3CLI%3EType%3A%20String%3C%2FLI%3E%0A%3CLI%3EValue%3A%26nbsp%3BToken%20QhXXXXBSlodAV9AXXXXXXQlMcFhweXXXXXRXXh1OGkXXkXXkeX%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3ESet%20an%20HTTP%20endpoints%20to%20Get%20MCAS%20Activity%20data%3A%3C%2FSPAN%3E%3CUL%3E%0A%3CLI%3EHTTP%20-%20MCAS%20Activities%20API%3A%3CUL%3E%0A%3CLI%3EMethod%3A%20GET%3C%2FLI%3E%0A%3CLI%3EURI%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fm365x933168.eu2.portal.cloudappsecurity.com%2Fapi%2Fv1%2Factivities%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fm365x933168.eu2.portal.cloudappsecurity.com%2Fapi%2Fv1%2Factivities%2F%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EHeaders%3A%3CUL%3E%0A%3CLI%3EKey%3A%20Authorization%3C%2FLI%3E%0A%3CLI%3EValue%3A%20%40variables('MCAS_API_Token')%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3EParse%20MCAS%20Activities%26nbsp%3Bdata%20via%20Json%3A%3C%2FSPAN%3E%3CUL%3E%0A%3CLI%3EParse%20JSON%20-%20MCAS%20Activities%3A%3CUL%3E%0A%3CLI%3EContent%3A%26nbsp%3B%40%7Bbody('HTTP_-_MCAS_Activities_API')%7D%3C%2FLI%3E%0A%3CLI%3ESchema%3A%20uploaded%20to%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fhesaad%2FAzureSentinelHub%2Fblob%2Fmaster%2FMCASActivityAPI-Parser%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Egithub%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3EInitialize%20an%20Array%20Variable%3A%3CUL%3E%0A%3CLI%3EName%3A%20TempArrayVar%3C%2FLI%3E%0A%3CLI%3EType%3A%20Array%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3EAppend%20to%20array%20variable%3A%3CUL%3E%0A%3CLI%3EName%3A%20TempArrayVar%3C%2FLI%3E%0A%3CLI%3EValue%3A%26nbsp%3B%40%7Bbody('Parse_JSON_-_MCAS_Activities')%7D%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3EAdd%20For%20each%20control%20to%20iterate%20MCAS%20Activities%26nbsp%3Bparsed%20items%3A%3C%2FSPAN%3E%3CUL%3E%0A%3CLI%3E%3CSPAN%3ESelect%20an%20output%20from%20previous%20steps%3A%26nbsp%3B%40variables('TempArrayVar')%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3ESend%20the%20data%20(MCAS%20Activity%20Log)%20to%20Azure%20Sentinel%20Log%20analytics%20workspace%20via%20a%20custom%20log%20tables%3A%3C%2FSPAN%3E%3CUL%3E%0A%3CLI%3EJSON%20Request%20body%3A%20%40%7Bitems('For_each')%7D%3C%2FLI%3E%0A%3CLI%3ECustom%20Log%20Name%3A%26nbsp%3BMCAS_Activity_Log%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MCASActivitySentinel-Update.gif%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F241145i7BDC412BE00B37D5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MCASActivitySentinel-Update.gif%22%20alt%3D%22MCASActivitySentinel-Update.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ENotes%20%26amp%3B%20Consideration%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EYou%20can%20customize%20the%20parser%20at%20the%20connector's%20flow%20with%20the%20required%20and%20needed%20attributed%20%2F%20fields%20based%20on%20your%20schema%20%2F%20payload%20before%20the%20ingestion%20process%2C%20also%20you%20can%20create%20custom%20Azure%20Functions%20once%20the%20data%20being%20ingested%20to%20Azure%20Sentinel%3C%2FLI%3E%0A%3CLI%3EYou%20can%20customize%20the%20for-each%20step%20to%20iterate%20MCAS%20Activity%20log%20and%20send%20them%20to%20the%20Log%20Analytics%20workspace%20so%20eventually%20each%20activity%20log%20will%20be%20logged%20in%20a%20separate%20table's%20record%20%2F%20row%3C%2FLI%3E%0A%3CLI%3EYou%20can%20build%20your%20own%20detection%20and%20analytics%20rules%20%2F%20use%20cases%2C%26nbsp%3B%20a%20couple%20of%20MCAS%20Activities%20analytics%20rules%20will%20be%20ready%20to%20use%20at%20github%2C%20stay%20tuned%3C%2FLI%3E%0A%3CLI%3ECouple%20of%20points%20to%20be%20considered%20while%20using%20Logic%20Apps%3A%3CUL%3E%0A%3CLI%3ECost%20(%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fconnectors%2Fapis-list%3Ftoc%3D%252fazure%252flogic-apps%252ftoc.json%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Estandard%20%2F%20enterprise%20connectors%3C%2FA%3E)%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Flogic-apps%2Flogic-apps-limits-and-config%23%3A~%3Atext%3DFor%2520logic%2520apps%2520in%2520multi-tenant%2520Azure%252C%2520the%252090-day%2Cretention%2520limit%2520from%252090%2520days%2520to%252030%2520days.%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EConsiderations%20%26amp%3B%20Configurations%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3ENon%20standard%20schema%3C%2FLI%3E%0A%3CLI%3ERewriting%20rules%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EGet%20started%20today!%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20encourage%20you%20to%20try%20it%20now!%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EYou%20can%20also%20contribute%20new%20connectors%2C%20workbooks%2C%20analytics%20and%20more%20in%20Azure%20Sentinel.%20Get%20started%20now%20by%20joining%20the%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fthreathunters%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20Sentinel%20Threat%20Hunters%20GitHub%20community%3C%2FA%3E%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1849806%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EThe%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcloud-app-security%2Fwhat-is-cloud-app-security%22%20data-linktype%3D%22absolute-path%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3EMicrosoft%20Cloud%20App%20Security%3C%2FA%3E%3CSPAN%3E%26nbsp%3B(MCAS)%20connector%20lets%20you%20stream%20alerts%20and%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fcloud-app-security%2Ftutorial-shadow-it%22%20data-linktype%3D%22absolute-path%22%20rel%3D%22noopener%20noreferrer%22%20target%3D%22_blank%22%3ECloud%20Discovery%20logs%3C%2FA%3E%3CSPAN%3E%26nbsp%3Bfrom%20MCAS%20into%20Azure%20Sentinel.%20This%20will%20enable%20you%20to%20gain%20visibility%20into%20your%20cloud%20apps%2C%20get%20sophisticated%20analytics%20to%20identify%20and%20combat%20cyberthreats%2C%20and%20control%20how%20your%20data%20travels.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ECouple%20of%20SOC%20use%20cases%20require%20to%20ingest%20MCAS%20Activity%20log%20to%20Azure%20Sentinel%20for%20correlation%2C%20aggregation%2C%20detection%2C%20investigation%2C%20monitoring%20and%20analytics%20activities.%20So%20how%20to%20ingest%20MCAS%20activity%20to%20Azure%20Sentinel%2C%20let's%20get%20started!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1849806%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Sentinel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMCAS%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESecurity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2000245%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Cloud%20App%20Security%20(MCAS)%20Activity%20Log%20in%20Azure%20Sentinel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2000245%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EDo%20MCAS%20API%20Tokens%20need%20to%20be%20stored%20using%20Key%20Vault%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2004730%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Cloud%20App%20Security%20(MCAS)%20Activity%20Log%20in%20Azure%20Sentinel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2004730%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F474594%22%20target%3D%22_blank%22%3E%40shoando%3C%2FA%3E%26nbsp%3B-%20yes%20you%20can%20for%20security%20reasons.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2024077%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Cloud%20App%20Security%20(MCAS)%20Activity%20Log%20in%20Azure%20Sentinel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2024077%22%20slang%3D%22en-US%22%3E%3CP%3EAwesome%20stuff%2C%20although%20will%20there%20be%20a%20part%202%20of%20this%3F%20Covering%20the%20%22considerations%22%20section%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2106587%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Cloud%20App%20Security%20(MCAS)%20Activity%20Log%20in%20Azure%20Sentinel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2106587%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F49603%22%20target%3D%22_blank%22%3E%40Hesham%20Saad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreat%20Blog%20-%20thanks%20a%20lot.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20successful%20implemented%20the%20app%20in%20my%20test%20environment%20and%20built%20another%20one%20for%20the%20entitity%20endpoint.%3C%2FP%3E%3CP%3EAs%20a%20next%20step%20I'd%20like%20to%20separate%20the%20logs%20to%20different%20rows%20but%20so%20far%20I'm%20not%20successful%20because%20the%20for%20each%20loop%20tells%20me%20that%20it%20needs%20an%20array%20not%20an%20object%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3CP%3EHave%20you%20already%20done%20this%20successful%20and%20can%20give%20me%20a%20hint%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20Chris%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1996473%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Cloud%20App%20Security%20(MCAS)%20Activity%20Log%20in%20Azure%20Sentinel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1996473%22%20slang%3D%22en-US%22%3E%3CP%3EAzure%20Sentinel%20is%20becoming%20more%20and%20more%20the%20SIEM%20to%20be%20%3A)%3C%2Fimg%3E%20Thanks%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F49603%22%20target%3D%22_blank%22%3E%40Hesham%20Saad%3C%2FA%3E%20for%20the%20clear%20blog%20post%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2151135%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Cloud%20App%20Security%20(MCAS)%20Activity%20Log%20in%20Azure%20Sentinel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2151135%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20connector%20to%26nbsp%3B%3CSPAN%3Eingest%26nbsp%3BWorkday%20HCM%20logs%20into%20Sentinel%20%3F%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2166318%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Cloud%20App%20Security%20(MCAS)%20Activity%20Log%20in%20Azure%20Sentinel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2166318%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F49603%22%20target%3D%22_blank%22%3E%40Hesham%20Saad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20there%20a%20connector%20to%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Eingest%26nbsp%3BWorkday%20HCM%20logs%20into%20Sentinel%20%3F%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2166326%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Cloud%20App%20Security%20(MCAS)%20Activity%20Log%20in%20Azure%20Sentinel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2166326%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F49603%22%20target%3D%22_blank%22%3E%40Hesham%20Saad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20ingest%26nbsp%3B%20only%20%22Workday%20HCM%22%20logs%20from%20MCAS%26nbsp%3B%20into%20Sentinel%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2203077%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Cloud%20App%20Security%20(MCAS)%20Activity%20Log%20in%20Azure%20Sentinel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2203077%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F49603%22%20target%3D%22_blank%22%3E%40Hesham%20Saad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20this%20also%20work%20for%20the%20other%20MCAS%20URIs%2C%20specifically%20Files%3F%26nbsp%3B%20If%20it%20does%2C%20does%20it%20overcome%20the%205000%20item%20export%20limit%20that%20is%20present%20with%20the%20UI%20export%20of%20File%20policy%20matches%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Dec 16 2020 10:17 AM
Updated by: