Datamining Reports (DMRs) – Overview & Quick Start

Datamining Reports (DMRs) in ManagementStudio provide a powerful and flexible way to extract, analyse, and visualise data across key modules such as Applications, User Migrations (commonly referred to as Users), Devices, Mailboxes, Deployment Units, Defects, and Bespoke items.

DMRs allow teams to explore data at scale, combine information across modules, apply logic and calculations, and share results through saved reports, dashboards, exports, or published web views.

This page is the starting point for:

• New users creating their first Datamining Report
• Experienced users refreshing their understanding of DMR concepts
• Support teams and AI agents answering “how does this work?” questions

When Should I Use a Datamining Report?

Use a Datamining Report when you need to:

• Report on hundreds or thousands of items at once
• Combine data from multiple modules (for example Users and Applications)
• Understand readiness, process state, or time in process
• Apply calculations, conditional logic, or visual indicators
• Share consistent, repeatable reports with your team

Quick Start (5 Minutes)

Example 1: Your First Datamining Report

Scenario
You are viewing the main Devices grid and want to analyse SCCM or Intune data across hundreds or thousands of devices. While this data is available on individual device records, you need it in bulk.

Steps

1. Select the Devices you want to report on in the main grid.
2. Click the Datamining Report button in the ribbon above the grid.
3. In the Reporting Tier panel on the left, select Device detail fields. Expand the SCCM / Intune field tree and choose the fields you want to include.
4. Click Run Datamining Report.

You now have a report showing SCCM / Intune data across all selected devices.

Example 2: Linking Users to Applications

Scenario
You are reviewing a list of Users (officially called User Migrations in ManagementStudio) and need to understand which Applications they use.

Steps

1. Select the Users on the main grid.
2. Click the Datamining Report button.
3. Add an Applications Reporting Tier to the report.
4. Select the required fields from both the Users and Applications tiers.
5. Click Run Datamining Report.

The result is a report listing Users and the Applications they are linked to.

Tip
If you only need to know whether a User’s Applications are ready, add an Applications Readiness Tier instead of an Applications Reporting Tier.

Understanding Datamining Tiers

Datamining Tiers are evaluated at report runtime and can be combined to produce highly flexible reports without modifying underlying data.

Reporting Tier

The Reporting Tier provides direct data from the primary module and any linked secondary modules. It is always the top-level tier in a Datamining Report and defines the core dataset.

Reporting Tiers allow you to include:

• Detail fields and Custom Form fields
• Tasks, Defects, Surveys, Attachments, and Emails
• Linked module data (for example User–Application or User–Device reports)

See: Datamining Tiers – Reporting Tier

Readiness Tier

The Readiness Tier derives readiness indicators from the underlying status of Processes and Sub Processes.

Readiness can be calculated:

• Directly per item (for example, whether an Application is Ready)
• As an aggregate score (for example, User readiness based on assigned Applications)

See: Datamining Tiers – Readiness Tier

Time In Process Tier

The Time In Process Tier analyses how long items have spent in Processes and Process Statuses, using units such as work days, hours, or minutes.

Common use cases include identifying stalled items and monitoring SLA compliance.

See: Datamining Tiers – Time In Process

Blueprint Columns Tier

The Blueprint Columns Tier adds Blueprint membership information to a report, allowing hierarchical classification such as Department, Location, or Deployment Ring.

See: Datamining Tiers – Blueprint Column Tier

Dynamic Columns Tier

The Dynamic Columns Tier adds real-time logic, actions, and visual enhancements to a report.

• Expression Columns – calculated fields and conditional logic
• Web Button Columns – interactive actions in published web reports
• Colour Rule Columns – conditional formatting such as RAG indicators

See: Datamining Tiers – Dynamic Columns

Saving, Loading & Sharing Datamining Reports

Saving a Report

Datamining Reports can be run ad-hoc or saved for reuse and sharing.

After building a report, click the Save icon in the report window toolbar or use the Menu button and select Save.

You can provide a name and description. By default, reports are private to you. Enabling Make report public to all users allows others to run the report but not edit it.

If another user edits and saves a public report, their changes are saved as a separate copy.

Loading a Report

Open a new Datamining Report and use the Menu button to browse:

• Your own reports
• Public reports shared by others

If the saved Data Source differs from the currently selected grid items, you will be prompted to choose which Data Source to use.

Favouriting Reports

Click the heart icon next to a report to favourite it.

Favourited reports:

• Appear at the top of the report list
• Are accessible from the Datamining Report dropdown on module grids
• Appear in the left-hand navigation for quick access

Report Versioning

Each save creates a new version of the report schema.

Use the clock icon in the report toolbar to load a previous version. Loading a previous version replaces the current report definition.

Datamining Ribbon Tabs

Build Report

Used to add Tiers and configure report structure. Includes tools such as pivot views, hidden field toggles, and internal column name display.

See: Datamining Tools - Ribbon, Tool Bar & Context Menu

See: Datamining Tools - Column Layout, Filter and Sort

Data Source

Defines which items are in scope for the report, such as all items, selected items, items in a process, or results from another report.

See: UI Basics - Data Source

Advanced Filter & Sort

Provides server-side filtering, sorting, and column removal using internal column names.

See: Datamining - Advanced Filter & Sort

Link Metadata & Behaviour

Surfaces link-level metadata and controls how relationships between module items are resolved and displayed in the report.

See: Datamining Tools - Link Metadata & Behaviour Tab