Readiness Toolkit - Use PowerShell to generate Readiness Report from json files?

sanderderix 76 Reputation points
2023-08-11T12:15:41.8466667+00:00

Hi!

We are in the process of migrating approx 100Tb of FileShare data to Office 365.

I use the Microsoft Readiness Toolkit to scan fileshares for macro's on those FileShares.

https://learn.microsoft.com/en-us/deployoffice/readiness-toolkit-application-compatibility-microsoft-365-apps

I do this by making use of PowerShell:

$argumentList = "-p  ""$folder"" -r -output $output"

Write-Host "Starting:" $argumentList -ForegroundColor Green

Start-Process $process -ArgumentList $argumentList -Wait

The result is 169 folders with JSON files.

Using the Readiness Toolkit User Interface I can convert these folders with JSON files to an Excel report.

My question: is there a way to automate the creation of the Readiness Reports from those JSON files. Does anybody know if the creation of readiness reports using PowerShell?

My problem: I have 169 folders with JSON files that I manually need to process using the Readiness Toolkit UI.

#MicrosoftPleaseProvideAnAPI this is an awesome tool :-)

Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,894 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,230 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.