If you have a bulk of SharePoint sites, it becomes difficult to check which ShortPoint version is installed on each site ( /site collection / subsite). This is why we have created a PowerShell script which will generate a report with site URL and ShortPoint version in CSV format.
Please clone the repository (or you can download the zip): https://github.com/ShortPoint/add-in-version-check
- You have Admin rights to SharePoint Online (Note: This script does not work for SharePoint On-Premise environment)
- You have a basic understanding on how to run PowerShell script;
- You have cloned the repository OR downloaded the PowerShell script .zip file and extracted it to your local drive;
- You have admin rights at the machine you plan to run the script on;
- Your PowerShell ExecutionPolicy is set to RemoteSigned (From your PowerShell console, you can run Set-ExecutionPolicy RemoteSigned –Force)
Open PowerShell console as Administrator, just as shown below:
Navigate to the folder where you cloned the repository or extracted the downloaded zip above:
Execute the script by following command:
./VersionExtractorShortPoint.ps1 -SharePointAdminUrl "https://<TenancyName>-admin.sharepoint.com" -SharePointAdminUser "<Global Admin Username>" -SharePointAdminPassword "<Global Admin Password>" -CSVExportFilePath "<Full Path Name of the CSV file where you want to get the report>" -sharePointAssembliesPath "<Path where the SharePoint Client Assemblies are located>"
Here is a description of all the parameters:
|SharePointAdminUrl||String||Specify the URL of your SharePoint Online Admin center. URL should be in the following format: https://<tenancyName>-admin.sharepoint.com|
|SharePointAdminUser||String||Specify the SharePoint Online Administrator user name. Ex. email@example.com|
|SharePointAdminPassword||String||Specify the SharePoint Online Administrator password.|
|CSVExportFilePath||String||Specify the path with filename where you want the Script to output the results. E.g.: c:\ShortPoint\versions.csv|
Note: The file should not already exist. If it does, this script will overwrite it.
|sharePointAssembliesPath||String||We required following assemblies to make the script work:|
You can either download SharePoint Online client assemblies from MSDN OR you can use the one provided in the repository -> assemblies folder, here in this parameter you will have to specify path of the folder which contains above three assemblies.
Note: Sometimes while downloading the DLLs, operating system blocks the DLL files. You need to unblock the files before executing the PowerShell from file properties of each DLL one by one.
Once above script is executed successfully, you can now see the CSV file generated. It will look something like this:
Thank you for your attention!
How to enable Scripting Capabilities with PowerShell