This feature is needed when you are automating Sharegate report generation while working for multiple migration project. This will simplify analysis phase and can save lot of time than spending time over UI.

Dear Team, I am facing huge challenge to retrieve site permission details from multi-Geo tenant sites. We have a business transition, wherein specific sub-division business getting separated as independent entity. now among 150k sites, if I want to get specific site's (6000) permission details, it is very difficult and annoying with existing feature. Please provide a specific feature with Sharegate PowerShell, which can receive input from a csv file and can generate site permission report(s).

I want to automate my process and run permissions matrix reports for specific users when they transfer to new departments. I can't do that with a scheduled report.

I have a tenant of 4000+ sites (MS Teams) and I need to pull Permissions Matrix reports for about 400 of these teams. Choosing them one-by-one in the UI is going to be a real pain. If there was a PowerShell command, I could fee it a URL and options to set these up in Bulk. It would take minutes instead of hours in the UI.

My company only allows MFA authentication to SP. I can easily create scheduled jobs using 1-time browser authentication. Although possible it is very difficult to automate powershell jobs with this authentication method.
Having the flexibility to run a job that is scheduled from powershell once or 10 times a day would help me tremendously. Plus all the migration jobs are in one place - the schedule section

This is definitely still needed to be able to do automatic reports at scale (e.g. for all sites connected to a specific hub site) and to authenticate against multiple, specific sites, without being SP Admin, in an efficient way

Being able to run Matrix reports for all of our site owners without inputting thousands of individual requests would enable access reviews with less work on our owner's part. This would be incredibly beneficial to our security. It is obviously a highly sought addition, with so many users asking for so long!

We have a fair number of report requests coming through, especially permission matrix reports and source analysis reports. It would be good if we could drop a text file with a list of UNC paths and have our PowerShell script feed that to ShareGate. We could get so much more done!

Agent suggested i upvote this when working on ticket: 425582. We have 80k + OneDrive, and running the report takes 5+ days the Agent suggested breaking the OneDrive in smaller clumps when running the report the help wiht speed.

So to keep from having to select a large # of sites for a report run a commandlet seems like a better option to employ the agent's workaround.

We have many Permission matrix report jobs to do, but only one Excel per Site. So instead of making a new permission matrix report for each site it would be really helpful to just run a PowerShell with given Sites.

We have several client companies instead of one tenant. Each company has 100+ SharePoint sites that need reporting done. Being able to run these reports on bulk amount of sites without having SharePoint admin access to the admin center.

To add a similar use case to those already mentioned, we have 3,000+ teams/SharePoint Online sites, but I'm regularly asked to report on specific sub-sets of them, sometimes containing 300+ sites. I have a spreadsheet with a list of sites that I want to target, but it's incredibly tedious to search for each URL one at a time to add them to my report targets. It would be great if I could write a PowerShell script to add these 300+ URL's to an existing report, as targets, and execute it, without having to select hundreds of sites through the GUI. Currently, it takes longer for me to select the targets than for the report to actually run and produce the results.

Any movement on this? As many have already stated, it would be extremely helpful to be able to run reports using PowerShell.

Use case: We need to run quarterly permissions matrix reports on all sites in a tenant. As you can imagine this takes some time manually running (even scheduling) these reports. As the greatest time frame allowed for scheduled reports is monthly, we have to run or schedule these reports every quarter.

I have also noted that the report that is exported to the SP Library is different that the report that is exported manually. MS365 Groups are listed twice as a SP Group and as a Security Group in the report that is exported directly to SP Library. This is VERY confusing for those reading the reports.

Please update the API to allow us to run reports using PowerShell and fix the exported reports.

As far as I can tell, reports have to be created manually through the UI. Since I need to be able to run a hundred or so Audit Reports, it would be really nice to be able to schedule it all through Powershell like I do for the migrations. the Usecase previously listed is exactly what I need:
- create a Report in ShareGate UI, call the report via PowerShell and pass parameters like URL to call the same report multiple time for multiple sites
- create a report via PowerShell completely equally to the UI

Usecases:
- create a Report in ShareGate UI, call the report via PowerShell and pass parameters like URL to call the same report multiple time for multiple sites

- create a report via PowerShell completely equally to the UI

Does Sharegate give you the ability to export a task to PowerShell like Content Matrix? I am not seeing that option.

I'm using Sharegate's Powershell modules to automate our migrations. We migrate in batches of 50-100 site collections. It would be great if we could run the 'Checked out documents report' across these sites using Powershell and be able to automate document check-in before kicking off the migration

Jean-Philippe Beaulieu - Oh my gosh, why has this not been completed yet? This has been a hindrance as you have to have the desktop open for scheduled reports to run. Please implement this feature asap. I can have other triggers for Powershell to run. You are limiting this product without this feature set.

Our requirements are as follows:

1. For every Site Collection in a SharePoint on-premise farm (later also for SPO) we need to create a Permissions matrix report (one report per site collection, not all in one).

2. Also, we have the need to automatically export this to a DocLib (which is possible by ShareGate GUI) or better: by mail to the site collection admins (not possible so far I think).

3. We need to setup such report for every single site collection (currently about 250, will be thousands of them soon) and on a regular, monthly base. We need individual reports per site collection, not all site collections in one report.

4. We understand that all this – more or less – can be achieved by clicking around in ShareGate all day long, if you have many, automatically created site collections.

You have some PowerShell cmdlets and of course API, mainly facing migration challenges. Now here another challenge: Would it be possible to create s script that is running on a daily or weekly schedule:

• discover all site collections
• create such report schedule for Permission matrix report for every site collection (if it does not exist yet)
• again, if possible these reports should not only be exported to a defined DocLib but also be sent to the individual site collection admins

Can we somehow achieve this? I did not find an answer on this in your tool nor in your documentation. Thanks in advance!

-------

I had a support call on this and the engineer recommended to post into this thread. Now, are there any plans to integrate such features anytime soon? Thanks for your feedback.

We can schedule report from share gate GUI for tenant level permissions report but it gets failed because of many site collection.
Can we have option to schedule report using share gate PowerShell to generate permission report at tenant level.