Microsoft Azure AD Inventory

The Sumo Logic app for Microsoft Azure AD Inventory provides enhanced security monitoring by offering visibility into user activities and device management. The app provides built-in dashboards that help security teams track sign-in activities, monitor user demographics, and manage devices. It supports proactive threat detection by identifying unauthorized access, tracking device compliance, and ensuring all devices meet security standards. This app is vital for maintaining a secure and compliant Azure AD environment, enabling continuous oversight and governance of organizational resources.

info

This app includes built-in monitors. For details on creating custom monitors, refer to Create monitors for Microsoft Azure AD Inventory app.

Log types

This app uses Sumo Logic’s Microsoft Azure AD Inventory Source to collect Users and Devices from the Microsoft Graph API.

Sample log messages

Users

{
  "businessPhones": [
    "800-555-0101"
  ],
  "displayName": "Ava",
  "givenName": "Ava",
  "jobTitle": "Financial Analyst",
  "mail": "Ava.abss@finserve.com",
  "mobilePhone": "111-222-3333",
  "officeLocation": "USA TX Dallas 234567",
  "preferredLanguage": "English",
  "surname": "abss",
  "userPrincipalName": "Ava.abss@finserve.com",
  "id": "d2c19c55-6f30-40c6-a5f7-bb345c1293c4",
  "signInActivity": {
    "lastSignInDateTime": "2024-08-27T16:11:35Z",
    "lastSignInRequestId": "cb56ef78-b78c-44aa-9123-e12d456789bc",
    "lastNonInteractiveSignInDateTime": "2024-08-26T09:21:47Z",
    "lastNonInteractiveSignInRequestId": "de78fg90-bc12-56de-7890-ij45kl678901",
    "lastSuccessfulSignInDateTime": "2024-08-27T16:11:35Z",
    "lastSuccessfulSignInRequestId": "cb56ef78-b78c-44aa-9123-e12d456789bc"
  }
}

Devices

{
  "id": "3344aabb-ccdd-eeff-8899-1234567890ab",
  "deletedDateTime": null,
  "accountEnabled": true,
  "approximateLastSignInDateTime": "2024-08-28T17:45:00Z",
  "complianceExpirationDateTime": null,
  "createdDateTime": "2024-08-27T19:30:00Z",
  "deviceCategory": null,
  "deviceId": "qwerty12-3456-7890-abcd-efghijklmnop",
  "deviceMetadata": null,
  "deviceOwnership": "company",
  "deviceVersion": 4,
  "displayName": "Yealink-T58A",
  "domainName": null,
  "enrollmentProfileName": "Office Phone",
  "enrollmentType": "windowsBulkAzureDomainJoin",
  "externalSourceName": null,
  "isCompliant": true,
  "isManaged": true,
  "isRooted": false,
  "managementType": "eas",
  "manufacturer": "Yealink",
  "mdmAppId": "11223344-5566-7788-99aa-bbccddeeff00",
  "model": "T58A",
  "onPremisesLastSyncDateTime": null,
  "onPremisesSyncEnabled": null,
  "operatingSystem": "Android",
  "operatingSystemVersion": "10.0",
  "physicalIds": [],
  "profileType": "Printer",
  "registrationDateTime": "2024-08-27T19:30:00Z",
  "sourceType": null,
  "systemLabels": [],
  "trustType": "AzureAD",
  "extensionAttributes": {
    "extensionAttribute1": null,
    "extensionAttribute2": null,
    "extensionAttribute3": null,
    "extensionAttribute4": null,
    "extensionAttribute5": null,
    "extensionAttribute6": null,
    "extensionAttribute7": null,
    "extensionAttribute8": null,
    "extensionAttribute9": null,
    "extensionAttribute10": null,
    "extensionAttribute11": null,
    "extensionAttribute12": null,
    "extensionAttribute13": null,
    "extensionAttribute14": null,
    "extensionAttribute15": null
  },
  "alternativeSecurityIds": [
    {
      "type": 2,
      "identityProvider": null,
      "key": "eWVhbGluay1kZXZpY2Uta2V5"
    }
  ]
}

Sample queries

Total Devices

_sourceCategory="Azure_AD_Inventory" deviceId
| json "deviceId", "isCompliant", "isManaged", "isRooted", "manufacturer", "deviceOwnership", "managementType", "profileType", "operatingSystem", "enrollmentType", "complianceExpirationDateTime", "deviceCategory", "trustType", "registrationDateTime", "onPremisesSyncEnabled", "onPremisesLastSyncDateTime", "approximateLastSignInDateTime" as device_id, is_compliant, is_managed, is_rooted, manufacturer, device_ownership, management_type, profile_type, operating_system, enrollment_type, compliance_expiration_date_time, device_category, trust_type, registration_date_time, on_premises_sync_enabled, on_premises_last_sync_date_time, approximate_last_sign_in_date_time nodrop

// Global filters
| where manufacturer matches "{{manufacturer}}"
| where device_ownership matches "{{device_ownership}}"
| where management_type matches "{{management_type}}"
| where profile_type matches "{{profile_type}}"
| where operating_system matches "{{operating_system}}"

| count by device_id
| count

Collection configuration and app installation

Depending on the set up collection method, you can configure and install the app in three ways:

• Create a new collector and install the app. Create a new Sumo Logic Cloud-to-Cloud (C2C) source under a new Sumo Logic Collector and later install the app; Or
• Use an existing collector and install the app. Create a new Sumo Logic Cloud-to-Cloud (C2C) source under an existing Sumo Logic Collector and later install the app; Or
• Use existing source and install the app. Use your existing configured Sumo Logic Cloud-to-Cloud (C2C) source and install the app.

info

Use the Cloud-to-Cloud Integration for Microsoft Azure AD Inventory to create the source and use the same source category while installing the app. By following these steps, you can ensure that your Microsoft Azure AD Inventory app is properly integrated and configured to collect and analyze your Microsoft Azure AD Inventory data.

Create a new collector and install the app

To set up collection and install the app, do the following:

1. Select App Catalog.
2. In the 🔎 Search Apps field, run a search for your desired app, then select it.
3. Click Install App.
   note

   Sometimes this button says Add Integration.

4. In the Set Up Collection section of your respective app, select Create a new Collector.
   1. Collector Name. Enter a Name to display for the Source in the Sumo Logic web application. The description is optional.
   2. Timezone. Set the default time zone when it is not extracted from the log timestamp. Time zone settings on Sources override a Collector time zone setting.
   3. (Optional) Metadata. Click the +Add Metadata link to add custom log Metadata Fields. Define the fields you want to associate, each metadata field needs a name (key) and value.
      • A green circle with a check mark is shown when the field exists and is enabled in the Fields table schema.
      • An orange triangle with an exclamation point is shown when the field doesn't exist, or is disabled, in the Fields table schema. In this case, an option to automatically add or enable the nonexistent fields to the Fields table schema is provided. If a field is sent to Sumo that does not exist in the Fields schema or is disabled it is ignored, known as dropped.
   4. Click Next.
5. Use the new Cloud-to-Cloud Integration to configure the source.
6. In the Configure section of your respective app, complete the following fields.
   1. Key. Select either of these options for the data source.
      • Choose Source Category and select a source category from the list for Default Value.
      • Choose Custom, and enter a custom metadata field. Insert its value in Default Value.
7. Click Next. You will be redirected to the Preview & Done section.

Post-installation

Once your app is installed, it will appear in your Installed Apps folder, and dashboard panels will start to fill automatically.

Each panel slowly fills with data matching the time range query and received since the panel was created. Results will not immediately be available, but will update with full graphs and charts over time.

Use an existing collector and install the app

To setup source in the existing collector and install the app, do the following:

1. Select App Catalog.
2. In the 🔎 Search Apps field, run a search for your desired app, then select it.
3. Click Install App.
   note

   Sometimes this button says Add Integration.

4. In the Set Up Collection section of your respective app, select Use an existing Collector.
5. From the Select Collector dropdown, select the collector that you want to setup your source with and click Next.
6. Use the new Cloud-to-Cloud Integration to configure the source.
7. In the Configure section of your respective app, complete the following fields.
   1. Key. Select either of these options for the data source.
      • Choose Source Category and select a source category from the list for Default Value.
      • Choose Custom, and enter a custom metadata field. Insert its value in Default Value.
8. Click Next. You will be redirected to the Preview & Done section.

Post-installation

Once your app is installed, it will appear in your Installed Apps folder, and dashboard panels will start to fill automatically.

Each panel slowly fills with data matching the time range query and received since the panel was created. Results will not immediately be available, but will update with full graphs and charts over time.

Use an existing source and install the app

To skip collection and only install the app, do the following:

1. Select App Catalog.
2. In the 🔎 Search Apps field, run a search for your desired app, then select it.
3. Click Install App.
   note

   Sometimes this button says Add Integration.

4. In the Set Up Collection section of your respective app, select Skip this step and use existing source and click Next.
5. In the Configure section of your respective app, complete the following fields.
   1. Key. Select either of these options for the data source.
      • Choose Source Category and select a source category from the list for Default Value.
      • Choose Custom, and enter a custom metadata field. Insert its value in Default Value.
6. Click Next. You will be redirected to the Preview & Done section.

Post-installation

Once your app is installed, it will appear in your Installed Apps folder, and dashboard panels will start to fill automatically.

Each panel slowly fills with data matching the time range query and received since the panel was created. Results will not immediately be available, but will update with full graphs and charts over time.

Viewing the Microsoft Azure AD Inventory dashboards

All dashboards have a set of filters that you can apply to the entire dashboard. Use these filters to drill down and examine the data to a granular level.

• You can change the time range for a dashboard or panel by selecting a predefined interval from a drop-down list, choosing a recently used time range, or specifying custom dates and times. Learn more.
• You can use template variables to drill down and examine the data on a granular level. For more information, see Filtering Dashboards with Template Variables.
• Most Next-Gen apps allow you to provide the scope at the installation time and are comprised of a key (_sourceCategory by default) and a default value for this key. Based on your input, the app dashboards will be parameterized with a dashboard variable, allowing you to change the dataset queried by all panels. This eliminates the need to create multiple copies of the same dashboard with different queries.

Devices Overview

The Microsoft Azure AD Inventory - Devices Overview dashboard is designed to provide security monitoring and management. It enables security teams to track device compliance, identify non-compliant devices, and monitor the distribution of devices based on critical security-related attributes like operating systems, management types, and ownership. By highlighting non-compliant devices and recent sign-in activities, the dashboard supports proactive threat detection, helping you to identify potential vulnerabilities, and ensures that only secure and compliant devices access organizational resources.

Users Overview

The Microsoft Azure AD Inventory - Users Overview dashboard provides a comprehensive security-focused view of user activities and demographics within your Azure AD environment. It tracks metrics such as office locations, job titles, preferred languages, and recent sign-in activity. By highlighting inactive users and displaying recent successful and unsuccessful sign-in attempts, the dashboard helps security teams identify potential unauthorized access, monitor user behavior, and enforce compliance with security policies. This tool is essential for maintaining a secure and well-governed Azure AD environment.

Create monitors for Microsoft Azure AD Inventory app

From your App Catalog:

1. From the Sumo Logic navigation, select App Catalog.
2. In the Search Apps field, search for and then select your app.
3. Make sure the app is installed.
4. Navigate to What's Included tab and scroll down to the Monitors section.
5. Click Create next to the pre-configured monitors. In the create monitors window, adjust the trigger conditions and notifications settings based on your requirements.
6. Scroll down to Monitor Details.
7. Under Location click on New Folder.
   note

   By default, monitor will be saved in the root folder. So to make the maintenance easier, create a new folder in the location of your choice.

8. Enter Folder Name. Folder Description is optional.
   tip

   Using app version in the folder name will be helpful to determine the versioning for future updates.

9. Click Create. Once the folder is created, click on Save.

Microsoft Azure AD Inventory alerts

The Sumo Logic app for Microsoft Azure AD Inventory includes a comprehensive set of monitors designed to enhance security monitoring and operational oversight. These alerts are triggered by critical security events, such as failed sign-ins that could indicate unauthorized access attempts and devices that are not compliant, managed, or rooted, providing immediate insights into potential vulnerabilities. These alerts help organizations quickly identify and respond to potential security threats, ensuring that only compliant, managed, and secure devices access the Azure AD environment, thereby reducing the risk of unauthorized access and security breaches.

Name	Description	Trigger Type (Critical / Warning / MissingData)	Alert Condition
Microsoft Azure AD Inventory - Failed Sign-Ins	This alert is fired when multiple failed sign-in attempts are detected without a subsequent successful login, indicating potential unauthorized access attempts.	Critical	Count > 2
Microsoft Azure AD Inventory - Device Not Compliant	This alert is fired when a device fails to meet security compliance standards, ensuring devices adhere to organizational policies.	Critical	Count > 0
Microsoft Azure AD Inventory - Device Not Managed	This alert is fired if a device is not managed, flagging potential risks from unmonitored devices.	Critical	Count > 0
Microsoft Azure AD Inventory - Device Not Rooted	This alert is fired if a device is not rooted, ensuring that all devices maintain security controls.	Critical	Count > 0

Upgrading the Microsoft Azure AD Inventory app (Optional)

To update the app, do the following:

1. Select App Catalog.
2. In the Search Apps field, search for and then select your app.
   Optionally, you can identify apps that can be upgraded in the Upgrade available section.
3. To upgrade the app, select Upgrade from the Manage dropdown.
   1. If the upgrade does not have any configuration or property changes, you will be redirected to the Preview & Done section.
   2. If the upgrade has any configuration or property changes, you will be redirected to Setup Data page.
      1. In the Configure section of your respective app, complete the following fields.
         • Key. Select either of these options for the data source.
           • Choose Source Category and select a source category from the list for Default Value.
           • Choose Custom and enter a custom metadata field. Insert its value in Default Value.
      2. Click Next. You will be redirected to the Preview & Done section.

Post-update

Your upgraded app will be installed in the Installed Apps folder, and dashboard panels will start to fill automatically.

note

See our Release Notes changelog for new updates in the app.

To revert the app to a previous version, do the following:

1. Select App Catalog.
2. In the Search Apps field, search for and then select your app.
3. To version down the app, select Revert to < previous version of your app > from the Manage dropdown.

Uninstalling the Microsoft Azure AD Inventory app (Optional)

To uninstall the app, do the following:

1. Select App Catalog.
2. In the 🔎 Search Apps field, run a search for your desired app, then select it.
3. Click Uninstall.