Skip to content

spo report activityfilecounts

Gets the number of unique, licensed users who interacted with files stored on SharePoint sites

Usage

m365 spo report activityfilecounts [options]

Options

-p, --period <period>
The length of time over which the report is aggregated. Supported values D7, D30, D90, D180.
-f, --outputFile [outputFile]
Path to the file where the 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

Examples

Gets the number of unique, licensed users who interacted with files stored on SharePoint sites for the last week

m365 spo report activityfilecounts --period D7

Gets the number of unique, licensed users who interacted with files stored on SharePoint sites for the last week and exports the report data in the specified path in text format

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

Gets the number of unique, licensed users who interacted with files stored on SharePoint sites for the last week and exports the report data in the specified path in json format

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

Response

[
  {
    "Report Refresh Date": "2022-11-26",
    "Viewed Or Edited": "3",
    "Synced": "",
    "Shared Internally": "",
    "Shared Externally": "",
    "Report Date": "2022-11-26",
    "Report Period": "7"
  }
]

Report Refresh Date,Viewed Or Edited,Synced,Shared Internally,Shared Externally,Report Date,Report Period
2022-11-26,3,,,,2022-11-26,7

Report Refresh Date,Viewed Or Edited,Synced,Shared Internally,Shared Externally,Report Date,Report Period
2022-11-26,3,,,,2022-11-26,7

Report Refresh Date,Viewed Or Edited,Synced,Shared Internally,Shared Externally,Report Date,Report Period
2023-05-04,10,,,,2023-05-04,7