spo report siteusagedetail
Gets details about SharePoint site usage
Usage
m365 spo report siteusagedetail [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 eitherdate
orperiod
, but not both.-p, --period [period]
The length of time over which the report is aggregated. Supported values
D7
,D30
,D90
,D180
. Specify eitherdate
orperiod
, but not both.
-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 isoptions
.--query [query]
JMESPath query string. See http://jmespath.org/ for more information and examples.
-o, --output [output]
Output type.
json
,text
,csv
,md
,none
. Defaultjson
.--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.
This command supports only csv and json output.
Examples
Gets details about SharePoint site usage for the last week
m365 spo report siteusagedetail --period D7
Gets details about SharePoint site usage for May 1, 2019
m365 spo report siteusagedetail --date 2019-05-01
Gets details about SharePoint site usage for the last week and exports the report data in the specified path in text format
m365 spo report siteusagedetail --period D7 --output text > "siteusagedetail.txt"
Gets details about SharePoint site usage for the last week and exports the report data in the specified path in json format
m365 spo report siteusagedetail --period D7 --output json > "siteusagedetail.json"
Response
- JSON
- Text
- CSV
- Markdown
[
{
"Report Refresh Date": "2022-11-26",
"Site Id": "002caf24-2672-4bc4-bc41-2811d5dba62c",
"Site URL": "https://contoso.sharepoint.com/sites/ElMontePythons",
"Owner Display Name": "El Monte Pythons Owners",
"Is Deleted": "False",
"Last Activity Date": "",
"File Count": "2",
"Active File Count": "0",
"Page View Count": "0",
"Visited Page Count": "0",
"Storage Used (Byte)": "1475974",
"Storage Allocated (Byte)": "27487790694400",
"Root Web Template": "Group",
"Owner Principal Name": "ElMontePythons@contoso.onmicrosoft.com",
"Report Period": "7"
}
]
Report Refresh Date,Site Id,Site URL,Owner Display Name,Is Deleted,Last Activity Date,File Count,Active File Count,Page View Count,Visited Page Count,Storage Used (Byte),Storage Allocated (Byte),Root Web Template,Owner Principal Name,Report Period
2022-11-26,002caf24-2672-4bc4-bc41-2811d5dba62c,https://contoso.sharepoint.com/sites/ElMontePythons,El Monte Pythons Owners,False,,2,0,0,0,1475974,27487790694400,Group,ElMontePythons@contoso.onmicrosoft.com,7
Report Refresh Date,Site Id,Site URL,Owner Display Name,Is Deleted,Last Activity Date,File Count,Active File Count,Page View Count,Visited Page Count,Storage Used (Byte),Storage Allocated (Byte),Root Web Template,Owner Principal Name,Report Period
2022-11-26,002caf24-2672-4bc4-bc41-2811d5dba62c,https://contoso.sharepoint.com/sites/ElMontePythons,El Monte Pythons Owners,False,,2,0,0,0,1475974,27487790694400,Group,ElMontePythons@contoso.onmicrosoft.com,7
Report Refresh Date,Site Id,Site URL,Owner Display Name,Is Deleted,Last Activity Date,File Count,Active File Count,Page View Count,Visited Page Count,Storage Used (Byte),Storage Allocated (Byte),Root Web Template,Owner Principal Name,Report Period
2023-05-04,00000000-0000-0000-0000-000000000000,2D7F5EEA85EDC827EB4E800B9843699A,9CB5FBB74CCA99D813491DF81BD9445D,False,2023-04-21,11,0,0,0,5979747,27487790694400,Group,C1B73ABEAE1BC69423799C66FE6D115F,7