SOLVED

report

%3CLINGO-SUB%20id%3D%22lingo-sub-184663%22%20slang%3D%22en-US%22%3Ereport%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-184663%22%20slang%3D%22en-US%22%3E%3CP%3Ewe%20are%20using%20office%20365%3CBR%20%2F%3Ehow%20to%20pull%20the%20report%20for%20number%20of%20users%20using%20one%20drive.%3CBR%20%2F%3Ethe%20size%20of%20their%20one%20drive%20and%20when%20did%20they%20access%20last%20time%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-184663%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOneDrive%20for%20Business%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-184966%22%20slang%3D%22en-US%22%3ERe%3A%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-184966%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20the%20assigned%20quota%2C%20you%20will%20have%20to%20run%20a%20PowerShell%20script%20against%20SPO%2C%20either%20to%20get%20the%20default%20quota%20or%20check%20each%20ODFB%20site%20individually.%20That%2C%20or%20use%20some%20of%20the%20third-party%20reporting%20tools%20that%20come%20with%20more%20customizable%20reports%20(but%20might%20cost%20you%20some%20%24%24%24).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-184701%22%20slang%3D%22en-US%22%3ERe%3A%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-184701%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20can%20see%20username%2C%20user%20last%20activity%2C%20storage%20used%2C%20but%20i%20want%20to%20see%20how%20much%20one%20drive%20capacity%20allocated%20to%20him.%20when%20i%20export%20the%20report%20storage%20used%20shows%20in%20kbs%20%2C%20at%20least%20if%20i%20can%20pull%20in%20gbs%2C%20it%20will%20be%20helpful%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-184699%22%20slang%3D%22en-US%22%3ERe%3A%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-184699%22%20slang%3D%22en-US%22%3ETake%20a%20look%20%40%20those%20report%20and%20you%20will%20get%20the%20answer%20to%20all%20your%20questions.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-184691%22%20slang%3D%22en-US%22%3ERe%3A%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-184691%22%20slang%3D%22en-US%22%3E%3CP%3Eis%20it%20not%20possible%20to%20pull%20custom%20report%3C%2FP%3E%3CP%3Elike%20user.name%20last%20activity%20data%2C%20drive%20size(in%20GB)%2C%20drive%20usage(in%20GB)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-184676%22%20slang%3D%22en-US%22%3ERe%3A%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-184676%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20thanks%20alot%20but%20i%20want%20to%20know%20how%20much%20size%20of%20their%20one%20drive%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-184665%22%20slang%3D%22en-US%22%3ERe%3A%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-184665%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F139420%22%20target%3D%22_blank%22%3E%40Rising%20Flight%3C%2FA%3E%26nbsp%3Bit%20is%20very%20easy.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOffice%20365%20portal%20has%20inbuilt%20reporting%20features.%20You%20can%20download%20reports%20for%20all%20office%20365%20workloads.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efollow%20the%20article%20to%20download%20the%20desired%20reports%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Factivity-reports-in-the-office-365-admin-center-0d6dfb17-8582-4172-a9a9-aed798150263%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Factivity-reports-in-the-office-365-admin-center-0d6dfb17-8582-4172-a9a9-aed798150263%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

we are using office 365
how to pull the report for number of users using one drive.
the size of their one drive and when did they access last time

6 Replies
Highlighted
Solution

@Rising Flight it is very easy.

 

Office 365 portal has inbuilt reporting features. You can download reports for all office 365 workloads.

 

follow the article to download the desired reports

 

https://support.office.com/en-us/article/activity-reports-in-the-office-365-admin-center-0d6dfb17-85...

Highlighted

Hi thanks alot but i want to know how much size of their one drive

Highlighted

is it not possible to pull custom report

like user.name last activity data, drive size(in GB), drive usage(in GB)

Highlighted
Take a look @ those report and you will get the answer to all your questions.
Highlighted

i can see username, user last activity, storage used, but i want to see how much one drive capacity allocated to him. when i export the report storage used shows in kbs , at least if i can pull in gbs, it will be helpful

Highlighted

For the assigned quota, you will have to run a PowerShell script against SPO, either to get the default quota or check each ODFB site individually. That, or use some of the third-party reporting tools that come with more customizable reports (but might cost you some $$$).