Microsoft Endpoint Configuration Management Data Warehouse Policy Compliance Analytics

Version 1.0.0

Correlate Data Warehouse policies with their device activity and the device population.

1 workflow 2 source APIs 1 provider
View Spec View on GitHub ComplianceConfiguration ManagementDevice ManagementEndpoint ManagementMobile Device ManagementPatch ManagementSoftware DeploymentArazzoWorkflows

Provider

microsoft-endpoint-configuration-management

Workflows

warehouse-policy-compliance-analytics
List policies, their device activity facts, and the device population.
Lists policy dimension records, lists policy device activity facts, and lists device records, all bounded by the supplied history window.
3 steps inputs: accessToken, apiVersion, maxHistoryDays, top outputs: devices, policies, policyActivities
1
listPolicies
List compliance and configuration policy dimension records.
2
listPolicyActivities
List policy device activity facts that track compliance counts over time.
3
listDevices
List device records to contextualize the compliance activity counts.

Source API Descriptions

Arazzo Workflow Specification

Raw ↑
arazzo: 1.0.1
info:
  title: Microsoft Endpoint Configuration Management Data Warehouse Policy Compliance Analytics
  summary: Correlate Data Warehouse policies with their device activity and the device population.
  description: >-
    A historical analytics flow over the Intune Data Warehouse. The workflow
    lists policy dimension records, pulls the policy device activity facts that
    track compliance counts over time, and lists the device population so the
    counts can be put in context. Together these give an analyst the inputs to
    build a compliance trend report. Every step spells out its request inline so
    the flow can be read and executed without opening the underlying OpenAPI
    description.
  version: 1.0.0
sourceDescriptions:
- name: devicesApi
  url: ../openapi/microsoft-endpoint-configuration-management-devices-api-openapi.yml
  type: openapi
- name: policiesApi
  url: ../openapi/microsoft-endpoint-configuration-management-policies-api-openapi.yml
  type: openapi
workflows:
- workflowId: warehouse-policy-compliance-analytics
  summary: List policies, their device activity facts, and the device population.
  description: >-
    Lists policy dimension records, lists policy device activity facts, and
    lists device records, all bounded by the supplied history window.
  inputs:
    type: object
    required:
    - apiVersion
    properties:
      accessToken:
        type: string
        description: OAuth 2.0 bearer token for the Intune Data Warehouse resource.
      apiVersion:
        type: string
        description: API version to use (v1.0 or beta).
      maxHistoryDays:
        type: integer
        description: Maximum number of days of history to retrieve.
      top:
        type: integer
        description: Maximum number of records to return per list.
  steps:
  - stepId: listPolicies
    description: List compliance and configuration policy dimension records.
    operationId: listPolicies
    parameters:
    - name: api-version
      in: query
      value: $inputs.apiVersion
    - name: $top
      in: query
      value: $inputs.top
    - name: Authorization
      in: header
      value: "Bearer $inputs.accessToken"
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      policies: $response.body#/value
  - stepId: listPolicyActivities
    description: List policy device activity facts that track compliance counts over time.
    operationId: listPolicyDeviceActivities
    parameters:
    - name: api-version
      in: query
      value: $inputs.apiVersion
    - name: maxhistorydays
      in: query
      value: $inputs.maxHistoryDays
    - name: $top
      in: query
      value: $inputs.top
    - name: Authorization
      in: header
      value: "Bearer $inputs.accessToken"
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      policyActivities: $response.body#/value
  - stepId: listDevices
    description: List device records to contextualize the compliance activity counts.
    operationId: listDevices
    parameters:
    - name: api-version
      in: query
      value: $inputs.apiVersion
    - name: maxhistorydays
      in: query
      value: $inputs.maxHistoryDays
    - name: $top
      in: query
      value: $inputs.top
    - name: Authorization
      in: header
      value: "Bearer $inputs.accessToken"
    successCriteria:
    - condition: $statusCode == 200
    outputs:
      devices: $response.body#/value
  outputs:
    policies: $steps.listPolicies.outputs.policies
    policyActivities: $steps.listPolicyActivities.outputs.policyActivities
    devices: $steps.listDevices.outputs.devices

Work with this as data

Every workflow here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for arazzo workflows

4 MCP tools reach this
  • find_arazzoBrowse and filter every workflow in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This workflow
curl "https://apis.io/api/v1/arazzo/microsoft-endpoint-configuration-management-warehouse-policy-compliance-analytics-workflow"
All arazzo workflows
curl "https://apis.io/api/v1/arazzo?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.