Skip to main content

tenant report activeuserdetail

Gets details about Microsoft 365 active users

Usage

m365 tenant report activeuserdetail [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 the 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.

-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 options.

--query [query]

JMESPath query string. See http://jmespath.org/ for more information and examples.

-o, --output [output]

Output type. json, text, csv, md, none. 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.

info

This command supports only csv and json output.

Examples

Gets details about Microsoft 365 active users for the last week

m365 tenant report activeuserdetail --period D7

Gets details about Microsoft 365 active users for May 1, 2019

m365 tenant report activeuserdetail --date 2019-05-01

Gets details about Microsoft 365 active users for the last week and exports the report data in the specified path in text format

m365 tenant report activeuserdetail --period D7 --output text > "activeuserdetail.txt"

Gets details about Microsoft 365 active users for the last week and exports the report data in the specified path in json format

m365 tenant report activeuserdetail --period D7 --output json > "activeuserdetail.json"

Response

[
{
"Report Refresh Date": "2022-10-23",
"User Principal Name": "0439A166C614C2E8C7B4075DC4752054",
"Display Name": "2236A6E43D08F619FE695DF3B163A32F",
"Is Deleted": "False",
"Deleted Date": "",
"Has Exchange License": "True",
"Has OneDrive License": "True",
"Has SharePoint License": "True",
"Has Skype For Business License": "True",
"Has Yammer License": "True",
"Has Teams License": "True",
"Exchange Last Activity Date": "2020-03-27",
"OneDrive Last Activity Date": "2020-03-27",
"SharePoint Last Activity Date": "2020-04-30",
"Skype For Business Last Activity Date": "2020-05-10",
"Yammer Last Activity Date": "2020-05-10",
"Teams Last Activity Date": "2020-05-10",
"Exchange License Assign Date": "2020-02-26",
"OneDrive License Assign Date": "2020-02-26",
"SharePoint License Assign Date": "2020-02-26",
"Skype For Business License Assign Date": "2020-02-26",
"Yammer License Assign Date": "2020-02-26",
"Teams License Assign Date": "2020-02-26",
"Assigned Products": "MICROSOFT 365 E5 DEVELOPER (WITHOUT WINDOWS AND AUDIO CONFERENCING)"
}
]
CTRL + M