Skip to content

serviceactivity-getactiveusermetricsforexcelweb.md

Latest commit

 

History

History
126 lines (100 loc) · 5.07 KB

serviceactivity-getactiveusermetricsforexcelweb.md

File metadata and controls

126 lines (100 loc) · 5.07 KB
title serviceActivity: getActiveUserMetricsForExcelWeb
description Get all the active usage based on the number of active users who open or save Excel for the web.
author mkuninty
ms.localizationpriority medium
ms.subservice m365-monitoring-service
doc_type apiPageType
ms.date 12/02/2024

serviceActivity: getActiveUserMetricsForExcelWeb

Namespace: microsoft.graph

[!INCLUDE beta-disclaimer]

Get all the active usage based on the number of active users who open or save Excel for the web.

Permissions

Choose the permission or permissions marked as least privileged for this API. Use a higher privileged permission or permissions only if your app requires it. For details about delegated and application permissions, see Permission types. To learn more about these permissions, see the permissions reference.

[!INCLUDE permissions-table]

HTTP request

GET /reports/serviceActivity/getActiveUserMetricsForExcelWeb

Function parameters

In the request URL, provide the following query parameters with values.

Parameter Type Description
aggregationIntervalInMinutes Int32 Aggregation interval in minutes. The default value is 15, which sets the data to be aggregated into 15-minute sets. Allowed values are 5, 10, 15, and 30. Optional.
exclusiveIntervalEndDateTime DateTimeOffset The ending date and time in UTC. Required.
inclusiveIntervalStartDateTime DateTimeOffset The starting date and time in UTC. The earliest start time allowed is 30 days in the past. Required.

Request headers

Name Description
Authorization Bearer {token}. Required. Learn more about authentication and authorization.

Request body

Don't supply a request body for this method.

Response

If successful, this function returns a 200 OK response code and a serviceActivityValueMetric collection in the response body.

Examples

Request

The following example shows a request.

HTTP

GET https://graph.microsoft.com/beta/reports/serviceActivity/getActiveUserMetricsForExcelWeb(inclusiveIntervalStartDateTime=2024-10-02T10:30:00Z,exclusiveIntervalEndDateTime=2024-10-02T10:59:59Z,aggregationIntervalInMinutes=10)

C#

[!INCLUDE sample-code] [!INCLUDE sdk-documentation]

Go

[!INCLUDE sample-code] [!INCLUDE sdk-documentation]

Java

[!INCLUDE sample-code] [!INCLUDE sdk-documentation]

JavaScript

[!INCLUDE sample-code] [!INCLUDE sdk-documentation]

PHP

[!INCLUDE sample-code] [!INCLUDE sdk-documentation]

PowerShell

[!INCLUDE sample-code] [!INCLUDE sdk-documentation]

Python

[!INCLUDE sample-code] [!INCLUDE sdk-documentation]

Response

The following example shows the response.

Note: The response object shown here might be shortened for readability.

HTTP/1.1 200 OK
Content-Type: application/json

{
    "@odata.context": "https://graph.microsoft.com/beta/$metadata#Collection(microsoft.graph.serviceActivityValueMetric)",
    "value": [
        {
            "intervalStartDateTime": "2024-10-02T10:30:00Z",
            "value": 1783
        },
        {
            "intervalStartDateTime": "2024-10-02T10:40:00Z",
            "value": 1674
        }
    ]
}