{"id":3273,"date":"2019-09-19T09:22:51","date_gmt":"2019-09-19T08:22:51","guid":{"rendered":"https:\/\/www.lieben.nu\/liebensraum\/?p=3273"},"modified":"2019-09-19T09:22:51","modified_gmt":"2019-09-19T08:22:51","slug":"exporting-all-file-info-in-o365-sharepoint-teams-onedrive-groups","status":"publish","type":"post","link":"https:\/\/lieben.nu\/liebensraum\/2019\/09\/exporting-all-file-info-in-o365-sharepoint-teams-onedrive-groups\/","title":{"rendered":"Exporting ALL file info in O365 (Sharepoint, Teams, Onedrive, Groups)"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1208\" height=\"518\" src=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2019\/09\/2019-09-19-10_20_54-fullFileIndex.csv-Excel.png\" alt=\"\" class=\"wp-image-3275\" srcset=\"https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2019\/09\/2019-09-19-10_20_54-fullFileIndex.csv-Excel.png 1208w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2019\/09\/2019-09-19-10_20_54-fullFileIndex.csv-Excel-300x129.png 300w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2019\/09\/2019-09-19-10_20_54-fullFileIndex.csv-Excel-1024x439.png 1024w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2019\/09\/2019-09-19-10_20_54-fullFileIndex.csv-Excel-768x329.png 768w\" sizes=\"auto, (max-width: 1208px) 100vw, 1208px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">For a recent customer case, we needed a meta-data export of ALL files in the entire O365 tenant, filenames, dates, modifications, sizes and unique ID&#8217;s. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It is tricky to actually get everything (Teams especially) and to handle any MFA you may (SHOULD!!) have configured on your admin accounts, but here you are:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/gitlab.com\/Lieben\/assortedFunctions\/blob\/master\/export-allO365FilesToCsv.ps1\">https:\/\/gitlab.com\/Lieben\/assortedFunctions\/blob\/master\/export-allO365FilesToCsv.ps1<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Note that your admin account does have to have <a rel=\"noreferrer noopener\" aria-label=\"permissions on all sources (opens in a new tab)\" href=\"https:\/\/www.lieben.nu\/liebensraum\/2015\/08\/setting-administrative-permissions-on-all-your-onedrive-for-business-accounts\/\" target=\"_blank\">permissions on all sources<\/a> the script identifies.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For a recent customer case, we needed a meta-data export of ALL files in the entire O365 tenant, filenames, dates, modifications, sizes and unique ID&#8217;s. It is tricky to actually get everything (Teams especially) and to handle any MFA you may (SHOULD!!) have configured on your admin accounts, but here you are: https:\/\/gitlab.com\/Lieben\/assortedFunctions\/blob\/master\/export-allO365FilesToCsv.ps1 Note that &hellip; <a href=\"https:\/\/lieben.nu\/liebensraum\/2019\/09\/exporting-all-file-info-in-o365-sharepoint-teams-onedrive-groups\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Exporting ALL file info in O365 (Sharepoint, Teams, Onedrive, Groups)<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[4,27,32,34,39,44],"tags":[],"class_list":["post-3273","post","type-post","status-publish","format-standard","hentry","category-automation","category-microsoft-teams","category-office-365","category-onedrive-for-business","category-powershell","category-sharepoint-online"],"_links":{"self":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts\/3273","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/comments?post=3273"}],"version-history":[{"count":0,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts\/3273\/revisions"}],"wp:attachment":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/media?parent=3273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/categories?post=3273"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/tags?post=3273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}