Get Email Activity And Mailbox Usage Details Of All Users Using Graph API

var contentType = "application/x-www-form-urlencoded; charset=utf-8";
var graphTokenError = "Failed to get graph token";
var graphToken = "";

// Call the get token method
getToken(graphAccessUrl, contentType, graphTokenBody, graphTokenError);

// This method is using to get the token from the graph token url and body
function getToken(url, type, content, errorMessage, callback) {
    var options = {
        'headers': {
            'Content-Type': type
        },
        'body': content
    };

    // Posting access parameters to the server
    var tokenResponse = httpPost(url, options);
    
    if (tokenResponse.statusCode === 200) {
        error = errorMessage;
        if (errorMessage === graphTokenError) {
            var token = JSON.parse(tokenResponse.body.toString('utf-8'));
            graphToken = token.access_token;
        }
        if (callback) {
            return callback();
        }
    } else {
        log(errorMessage);
    }
}

Step 6. Once you receive the token, make the HTTP call using endpoint and get the results.

Step 7. Email Activity Report in Graph API v1.0 provides the results in CSV format not in JSON format so we have no need to use the top. In a single API call, we can retrieve all the user results.

var reqUrl = "https://graph.microsoft.com/v1.0/reports/getEmailActivityUserDetail (period='D30')";
var usersCount = 0;

function getEmailActivityReportData(reqUrl) {
    try {
        console.log("Inside get user last logon data method!!!");
        var emailActivityRes = httpGet(encodeURI(reqUrl), GRAPH_TOKEN);
        if (emailActivityRes.statusCode == 200) {
            failIndex = 0;
            var parsedJson = convertCSVToJSON(emailActivityRes.body.toString('utf-8'));
            //add use case value to json valued array
            var parsJson = JSON.parse(parsedJson);
            if (parsJson) {
                usersCount = usersCount + parsJson.length;
                for (var i = 0; i < parsJson.length; i++) {
                    var currItem = parsJson[i];
                    if (currItem) {
                        //process your data here
                    }
                }
            }
            console.log("Email users count: " + usersCount);
        } else {
            console.log("Email user activity api received failed response: " + emailActivityRes.statusCode)
        }
    } catch (ex) {
        console.log(ex);
    }
}

//The below method is using to convert the csv values to json values
function convertCSVToJSON(csv) {
    /// <summary>This function is used to convert CSV to JSON</summary>   
    /// <param name="csv" type="String">CSV string</param>
    /// <returns type="Array">Return as JSON Array</returns>
    try {
        var lines = csv.split("\n");
        var result = [];
        var headers = lines[0].split(",");
        for (var i = 1; i < lines.length; i++) {
            var obj = {};
            if (lines[i]) {
                var currentline = lines[i].split(",");
                for (var j = 0; j < headers.length; j++) {
                    obj[headers[j]] = currentline[j];
                }
                result.push(obj);
            }
        }
        return JSON.stringify(result);
    } catch (ex) {
        console.log(ex + " in csvToJSON method...");
    }
}

Step 8. Then, bind the results based on your requirements. You will receive the below object when you call the Email Activity API.

Steps to Check the Exchange Email Activity details from the admin portal

Once you get the results, you can verify the results from O365 and also, follow the below-listed steps to verify the output.

Step 1. Log into Microsoft 365 Admin Center. Learn more here.

https://admin.microsoft.com/AdminPortal

Step 2. Provide a valid username and password to log into your account.

Step 3. From the Microsoft 365 Admin Center main menu, click the Reports option and then the Usage option.

Step 4. On the Usage pane, click the "Select a report" drop-down list, expand Exchange, and click the "Email activity" option.

Step 5. Click on the Export option; you will get the last 30 days' report for email activities with relevant data.

Using the same endpoint, you can get the reports for 7 days, 30 days, 90 days, and 180 days.

https://graph.microsoft.com/v1.0/reports/getEmailActivityUserDetail (period='D30')

Reference Link:https://docs.microsoft.com/en-us/graph/api/reportroot-getemailactivityuserdetail?view=graph-rest-1.0

Summary

In this article, we have explored how to get the activity details of Exchange users, such as read, sent, and received mail counts from the Office365 portal and using Graph API. I hope this article is useful to you. Please share your feedback in the comments section. Thanks for visiting my article.