Office 365 usage reports in Microsoft Graph over specific period

Please update me on this

Hi Neo,

Thanks for your reply.

I also have some other questions regarding Microsoft usage APIs as below:

I am accessing below API of Microsoft graph usage report:

API Name: getOneDriveUsageAccountDetail

Method: GET

Response parameters: 

• Report Refresh Date (Please explain brief about this parameter)
• Site URL
• Owner Display Name
• Is Deleted
• Last Activity Date (Please explain brief about this parameter)
• File Count
• Active File Count
• Storage Used (Byte)
• Storage Allocated (Byte)
• Report Period (Please explain brief about this parameter)

API: https://graph.microsoft.com/beta/reports/getOneDriveUsageAccountDetail(period='D7') 

Query 1: Expected Result is I should get data of last 7 days

but I am getting data from past 2 years.

Last Activity Date of user ranges from 5/12/2018 to 2/5/2016 but Expected is 5/12/2018  to 5/06/2018.

Query 2: Response contains Report Refresh date 5/12/2018 which is 48 hours lagging Expected date is todays date which is 5/14/2018

Query 3:

API that gives JSON response: https://graph.microsoft.com/beta/reports/getOneDriveUsageAccountDetail(period='D7')?%24format=application%2Fjson

count of total data items if response format is json : 220

API that gives csv file in response:

https://graph.microsoft.com/beta/reports/getOneDriveUsageAccountDetail(period='D7')

count of total data items if response format is csv: 9928

why count is different?

Hi Manali,

I'd like to explain that it is not feasible to get the report over 180 days. If you have any concern about that, please create a new UserVoice to improve our products better for you and others. This is the best way to improve our products. I appreciate your understanding.

Thanks,

Neo

Hi,

I am accessing below API of Microsoft graph usage report:

API Name: getOneDriveUsageAccountDetail

Method: GET

Response parameters: 

• Report Refresh Date (Please explain brief about this parameter)
• Site URL
• Owner Display Name
• Is Deleted
• Last Activity Date (Please explain brief about this parameter)
• File Count
• Active File Count
• Storage Used (Byte)
• Storage Allocated (Byte)
• Report Period (Please explain brief about this parameter)

API: https://graph.microsoft.com/beta/reports/getOneDriveUsageAccountDetail(period='D7') 

Expected Result is I should get data of last 7 days

but I am getting data from past 2 years.

Response contains Report Refresh date 5/12/2018 which is 48 hours lagging Expected date is todays date which is 5/14/2018

And Last Activity Date ranges from 5/12/2018 to 2/5/2016 but Expected is 5/12/2018  to 5/06/2018.

What Parameter I should pass if I want data from past 7, 30, 90 or 180 days?

I have one more doubt:

https://graph.microsoft.com/beta/reports/getOneDriveUsageAccountDetail(period='D7')?%24format=application%2Fjson

I am getting different count of total items in data if I give response format as json

total data items in excel:  9928 items

total data item in json: 203

why it is so?

I am getting data of past 180days not more than that.

is there any solution that will give data of more than 180 days?

Hi,

I am accessing below API of Microsoft graph usage report:

API Name: getOneDriveUsageAccountDetail

Method: GET

Response parameters: 

• Report Refresh Date (Please explain brief about this parameter)
• Site URL
• Owner Display Name
• Is Deleted
• Last Activity Date (Please explain brief about this parameter)
• File Count
• Active File Count
• Storage Used (Byte)
• Storage Allocated (Byte)
• Report Period (Please explain brief about this parameter)

API: https://graph.microsoft.com/beta/reports/getOneDriveUsageAccountDetail(period='D7') 

Expected Result is I should get data of last 7 days

but I am getting data from past 2 years.

Response contains Report Refresh date 5/12/2018 which is 48 hours lagging Expected date is todays date which is 5/14/2018

And Last Activity Date ranges from 5/12/2018 to 2/5/2016 but Expected is 5/12/2018  to 5/06/2018.

What Parameter I should pass if I want data from past 7, 30, 90 or 180 days?

I have one more doubt:

https://graph.microsoft.com/beta/reports/getOneDriveUsageAccountDetail(period='D7')?%24format=application%2Fjson

I am getting different count of total items in data if I give response format as json

total data items in excel:  9928 items

total data item in json: 203

why it is so?