Skip to content

spo report activityuserdetail

Gets details about SharePoint activity by user.

Usage

m365 spo report activityuserdetail [options]

Options

-d, --date [date]
The date for which you would like to view the users who performed any activity. Supported date format is YYYY-MM-DD. Specify either date or period, but not both.
-p, --period [period]
The length of time over which the report is aggregated. Supported values D7, D30, D90, D180. Specify either date or period, but not both.
-f, --outputFile [outputFile]
Path to the file where the Microsoft Teams device usage by user report should be stored in.
-h, --help [help]
Output usage information. Optionally, specify which section of command's help you want to see. Allowed values are options, examples, remarks, response, full. Default is full.
--query [query]
JMESPath query string. See http://jmespath.org/ for more information and examples
-o, --output [output]
Output type. json,text,csv,md. Default json
--verbose
Runs command with verbose logging
--debug
Runs command with debug logging

Remarks

As this report is only available for the past 28 days, date parameter value should be a date from that range.

Examples

Gets details about SharePoint activity by user for the last week

m365 spo report activityuserdetail --period D7

Gets details about SharePoint activity by user for May 1, 2019

m365 spo report activityuserdetail --date 2019-05-01

Gets details about SharePoint activity by user for the last week and exports the report data in the specified path in text format

m365 spo report activityuserdetail --period D7 --output text > "activityuserdetail.txt"

Gets details about SharePoint activity by user for the last week and exports the report data in the specified path in json format

m365 spo report activityuserdetail --period D7 --output json > "activityuserdetail.json"

Response

[
  {
    "Report Refresh Date": "2022-11-26",
    "User Principal Name": "Amanda.Powell@contoso.onmicrosoft.com",
    "Is Deleted": "False",
    "Deleted Date": "",
    "Last Activity Date": "2022-09-08",
    "Viewed Or Edited File Count": "0",
    "Synced File Count": "0",
    "Shared Internally File Count": "0",
    "Shared Externally File Count": "0",
    "Visited Page Count": "0",
    "Assigned Products": "MICROSOFT 365 E5 DEVELOPER (WITHOUT WINDOWS AND AUDIO CONFERENCING)+MICROSOFT POWER AUTOMATE FREE",
    "Report Period": "7"
  }
]
Report Refresh Date,User Principal Name,Is Deleted,Deleted Date,Last Activity Date,Viewed Or Edited File Count,Synced File Count,Shared Internally File Count,Shared Externally File Count,Visited Page Count,Assigned Products,Report Period
2022-11-26,Amanda.Powell@contoso.onmicrosoft.com,False,,2022-09-08,0,0,0,0,0,MICROSOFT 365 E5 DEVELOPER (WITHOUT WINDOWS AND AUDIO CONFERENCING)+MICROSOFT POWER AUTOMATE FREE,7
Report Refresh Date,User Principal Name,Is Deleted,Deleted Date,Last Activity Date,Viewed Or Edited File Count,Synced File Count,Shared Internally File Count,Shared Externally File Count,Visited Page Count,Assigned Products,Report Period
2022-11-26,Amanda.Powell@contoso.onmicrosoft.com,False,,2022-09-08,0,0,0,0,0,MICROSOFT 365 E5 DEVELOPER (WITHOUT WINDOWS AND AUDIO CONFERENCING)+MICROSOFT POWER AUTOMATE FREE,7