Powershell script to list the file types uploaded in SharePoint 2013 online sites.

Question

Hi,

Please help me with a script to list all the file types uploaded by the users to the sharepoint 2013 online sites.

Thanks in advance

Answer 1

Hi Priya,

To run the PowerShell script downloaded from this link normally, please make sure:

1. The following paths to SDK in the script file are collect for your computer:

Add-Type -Path "c:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll"

Add-Type -Path "c:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"

2. You have imported this module with command below:

Import-Module C:\test\GetSPOListItems9.psm1 -Verbose

Meanwhile, based on my test, we can use the following command to list all unique file types in a document library:

*Get-SPOListItems -Username *****@contoso.onmicrosoft.com -Url https://contoso.sharepoint.com/sites/test/ -AdminPassword Pass -ListTitle Documents -IncludeAllProperties $true -Recursive | select -Property File_x0020_Type -Unique

 

Note: It will take a while to finish running the command.

Regards,

Jiaxing

Answer 2

Hi Jiaxing,

Thank you and it worked as you said.

How do I check for all the site collection.?

• Priya

Answer 3

Hi ,

I tried that script and received below error

Get-SPOListItems : The term 'Get-SPOListItems' is not recognized as the name of a cmdlet, function, script file, or 

operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

At line:2 char:1

Could you help me with it.

Answer 4

Thank you Jiaxing

Answer 5

Hi Priya,

We’d suggest you post the question in our MSDN SharePoint forum, which is a specific support channel for PowerShell script for SharePoint Online related issues.

For your reference, I found a PowerShell script that can list all items with extensions in a specific library.

GetSpoListItems and GetSPOListFields (Refer to the section Get a list of all documents in a document library)

Regards,

Jiaxing