Microsoft Secure Tech Accelerator
Apr 03 2024, 07:00 AM - 11:00 AM (PDT)
Microsoft Tech Community
Create richer reports with Microsoft Information Protection and Azure AD login data
Published Apr 01 2019 08:29 PM 10.1K Views

Having visibility into all your documents and emails in one place is very powerful on its own but how can you make it even better? That’s where this blog post comes in. Today, we want to show you how to combine Microsoft Information Protection (MIP) audit events with sign in activity from Azure Active Directory to produce richer and more interesting reports.

 

Microsoft Information Protection central reporting helps IT professionals gain greater visibility into sensitive data across the organization.  Starting with version 1.41.51.0, the Azure Information Protection (AIP) client can send user activity events to an Azure Log Analytics workspace in your Azure tenant. Of course, the AIP client is not the only way MIP helps you discover sensitive data. The AIP Scanner, Microsoft Defender ATP as well as Microsoft Cloud App Security (MCAS) are other solutions that help provide full visibility into your critical documents across on-premises, user end points as well as SaaS providers.

 

For more information, read the following blog posts:

Prerequisites:

  1. Azure Information Protection already enabled in your tenant with labels configured and published to a policy
  2. One of the following AIP clients:
    1. Version 1.41.51.0 and higher or
    2. Unified labeling client (currently in preview)
  3. AIP Analytics configured in the AIP Azure portal
  4. Integrated Azure AD activity logs with Azure Monitor (Make sure to select the same Log Analytics workspace being used for AIP)

Confirm Setup

With the above requirements out of the way, let’s confirm that your logs are available within Log Analytics before we proceed.

 

There are several ways to get to your Log Analytics workspace but for now, just find Azure Monitor and click on Logs and you should land on the below view.

pic1.png

Next, make sure you select your AIP Log Analytics workspace (somosaiplogs in this example) and expand the LogManagement group.

pic2.png

Finally, scroll down until you find SigninLogs as shown below.

pic3.png

Optional: Double click on SigninLogs and run the default query.

 

Let’s run some reports:

Now that we have both AIP and Azure AD sign in logs in one place, let’s begin by running some simple reports from MIP.

 

Run the following query to obtain a list of label downgrade activities by a user:

 

InformationProtectionEvents

| where Time >= ago(30d)

| where Activity == "DowngradeLabel"

| where User == "adelev@deda.us"

pic4.png

 

This report is a good way to find all the different locations being used by a user given AIP keeps track of the location for each file affected by a user.

TIP: Although not the focus of this post, you can create an alert based on any of the queries you create in Azure Monitor.

 

Here is another report that gets rendered in a chart by default:

 

InformationProtectionEvents

| where Time >= ago(30d)

| where isnotempty(Activity)

| summarize Activity_count=count() by Activity

| sort by Activity asc nulls last

| render columnchart

pic5.png

Another useful report you may want to consider is getting a list of files with a Confidential or Highly Confidential label that are not protected (RMS encrypted). This is helpful when you start implementing protection for some of your data.

 

Here is a list of files with a label that contains “Confidential” but have no protection.

 

InformationProtectionEvents

| where LabelName contains "Confidential" and IsProtected == "false"

| summarize dcount(ItemPath) by ItemPath, User, IsProtected, Time, MachineName

| project ItemPath, User, IsProtected, Time, MachineName

pic6.png

 

Here we'll count the number of events by hour to see which hour of the day has the most events.

Note: Excluding the “Discover” activity type is of course optional.

 

// By Activity trend over time by hour

InformationProtectionEvents

| where Time >= ago(7d)

| where Activity != 'Discover'

| extend dummy = 1

| summarize ActivityCount=sum(dummy) by (bin(Time, 1h)), Activity

| render timechart

pic7.png

 

Combined Reports

Time to go pro. Let’s run some advanced reports that combine data from both AIP and Azure AD logs. This is the gist of this blog. We want to give you a taste of how you can enhance all the MIP audit events you are already collecting with properties from other data sources. In the example below we want to understand how many label downgrade actions have been performed in a country. This is possible because the sign in activity from Azure AD contains the user Location/Country which was captured during the logon process.

 

A couple of points on this before we go on. It’s important to keep in mind that location data may or may not be available to you depending on your Azure AD authentication flow. Another important point to remember is that the below examples are just the beginning. You can certainly combine MIP audit events with one or more data sources to create even richer reports.

 

Let’s start by seeing total activity by user in a single country (Brazil in this case):

 

let SpecifiedTime = totimespan(31d);

InformationProtectionEvents

| where Time >= ago(SpecifiedTime)

| where Activity == "DowngradeLabel"

| project Activity, Time, User

| extend dummy = 1

| summarize ActivityCount=sum(dummy) by User, Activity

| join kind=inner (

    SigninLogs

    | where Location == "BR" 

    | summarize arg_max(TimeGenerated, *) by UserPrincipalName

    | project UserPrincipalName , LocationDetails , UserDisplayName 

) on $left.User == $right.UserPrincipalName

| project User=UserDisplayName, Activity, ActivityCount, UPN=UserPrincipalName ,Country=todynamic(LocationDetails).countryOrRegion , State=todynamic(LocationDetails).state, City=todynamic(LocationDetails).city

 pic8.png

 

The sign in logs contain other interesting data points like City and State which we leverage on the query below to get more context about the activity for all users.

 

let SpecifiedTime = totimespan(31d);

InformationProtectionEvents

| where Time >= ago(SpecifiedTime)

| where Activity == "DowngradeLabel"

| project Activity, Time, User

| extend dummy = 1

| summarize ActivityCount=sum(dummy) by User, Activity

| join kind=inner (

    SigninLogs

    | summarize arg_max(TimeGenerated, *) by UserPrincipalName

    | project UserPrincipalName , LocationDetails , UserDisplayName 

) on $left.User == $right.UserPrincipalName

| project User=UserDisplayName, Activity, ActivityCount, UPN=UserPrincipalName ,Country=todynamic(LocationDetails).countryOrRegion , State=todynamic(LocationDetails).state, City=todynamic(LocationDetails).city

 

Here is the result in table format:

pic9.png

And here is the chart view:

pic10.png

 

Call to action and final thoughts

This was just a quick primer to illustrate some of what’s possible with the rich data set provided by Microsoft Information Protection. If you haven’t already, we encourage you to enable AIP centralized logging with Azure Monitor today or If you already have, start building your favorite reports.

 

Of course, we realize that most of you have on-premises solutions where you do your log aggregation and reporting. Not to worry.  Azure Monitor allows you to stream all logs to the SIEM of your choice. If SIEM in the cloud is your cup of tea, we encourage you check out the recently announced Azure Sentinel where you can run these queries as it uses Azure Monitor.

 

You may also be interested to know that Azure Monitor allows you to export these queries directly into Power BI as shown here: https://docs.microsoft.com/en-us/azure/azure-monitor/platform/powerbi

 

Finally, in case you are not familiar, the query language we use above is called Kusto. Below is a great resource to help you get up to speed.

Kusto query overview: https://docs.microsoft.com/en-us/azure/kusto/query/

 

We hope this has been helpful and we encourage you to give us feedback and share your favorite queries with us and the community.

4 Comments
Copper Contributor

@Rafael Dominguez - It is something i look forward to work on - my question to you is about the cost and the amount of logs ingested to my WorkSpace from AAD Diagnostics - we need to make sure that it does not cost a lot.

 

Any suggestion or help for such calculations - 350K Users/Endpoint environment

Hi @Mhassan and thanks for your question. Please refer to this link for Azure Monitor pricing: https://azure.microsoft.com/en-us/pricing/details/monitor/

Copper Contributor

For audit data generated by Azure Information Protection clients only: 2 GB per 10,000 active users. For audit data generated by Azure Information Protection clients, scanners, and Microsoft Defender ATP: 20 GB per 10,000 active users.

Copper Contributor

Can you tell me how ican query by user ,  User Department , user city 

Version history
Last update:
‎May 11 2021 03:14 PM
Updated by: