Run and Automate Reporting Jobs with PowerShell
Be able to run and schedule reports using PowerShell.

Since the ability to schedule reports has been included for a while now and with the upcoming feature to automatically export reports into a SP library (see: https://feedback.sharegate.com/forums/912880/suggestions/17768698), I was wondering if this suggestion will still be needed?
What are your thoughts on this?
-
Anonymous commented
Do you have a sample Powershell script to iterate over a subsite (and any child sites) and list out all the Groups with access and their members? This capability would be similar to the Permissions Matrix but the PermMatrix and it's output isn't very readable for average users. I was tryign something like this (not working)
##PRE-CONFIG STEPS
##REQUIRES IMPORT OF SHAREGATE MODULES
Import-Module Sharegate
$site = Connect-Site -Url https://toplevelsitecoll/subsite1/subsite2
##$web = $site.OpenWeb()
$groups =Get-Group $site
foreach ($grp in $groups) {
"Group: " + $grp.name;
$groupName = $grp.name
write-host "Group: " $groupName -foregroundcolor green
foreach ($user in $grp.users) {
"User: " + $user.name
write-host "User " $user.UserLogin -foregroundcolor red
}
}
Feedback sent from the Explorer view. -
Timothy Vvv commented
"Since the ability to schedule reports has been included for a while now and with the upcoming feature to automatically export reports into a SP library (see: https://feedback.sharegate.com/forums/912880/suggestions/17768698), I was wondering if this suggestion will still be needed?"
This is helpful, but a bit different, IMHO ShareGate should have coverage for all UI tasks from PowerShell (ideally also API), because if you have multiple thousands of site collections and you want to make some report for all of them manually it will be to long, and if I create report for whole farm it might be to big and unreadable, so ability to make reports from PowerShell will be helpful
-
mingli_ooi commented
Yes, voted as well, as seems more handy to use powershell if we want to generate permission reports for thousand of site collections and store in a defined location, and even better if there is a powershell command to allow to set the schedule to generate these permission reports.
I have been using the function in the latest version (v12.0.2) to schedule the generation of permission reports and store in a document library. No doubt it is a great feature, but does not work that well when I'm looking at generate permission reports for thousands of site collections as part of our organization audit requirements to review permissions. Imagine I have to set the schedule thousands time using the ShareGate desktop.
-
Sebastiaan Mindreau commented
Any update on this? (over a year old now)
Also looking for a way to automate the PMR, preferably even via Azure PowerShell. -
christian.arnold commented
I'm referring to a functionality to be able to request ANY ShareGate report (e.g. Permission Matrix Report) via PowerShell Cmdlets. This is not yet included but would be of great benefit.
-
stephen.wortman commented
It seems that you have added the automated export feature (which is great...) but I'm not seeing the ability run the reports via PS. That is what started this request and where most of the votes are coming from.
-
Anonymous commented
This is still a needed feature. We want to empower our SharePoint site owners to better manage their sites. A great report is the permission matrix report. Today, there are no options from Microsoft for such a report. We would like to implement a way for a site owner to make an ad hoc request for a ShareGate permission matrix report (e.g. from a PowerApps, a SP list, Flow, etc.). We would then call a script that would create the SG report and send the report to the user. Other SG reports would add value so I can imagine a pick list of SG reports, including ones I create, for a user to select at anytime.
-
Yeeehaaa commented
I would vote as well for being able to export Permission Matrix reports. In many companies, this is very common to audit the access rights on a regular base. Being able to export and to provide to each site owner an understandable Permission Matrix report would be a big plus and a true added value to the product.
-
Yeeehaaa commented
I would vote as well for being able to export Permission Matrix reports. In many companies, this is very common to audit the access rights on a regular base. Being able to export and to provide to each site owner an understandable Permission Matrix report would be a big plus and a true added value to the product.
-
kennethotto commented
Want to be able to run "check permissions" from Powershell so I can loop through users in our case to check for regulated users having too much access to perform electronic communications.
-
jeffmjones commented
Want to run PMR (permission matrix report) and give input CSV with list of target site collection URLs.
Thank you.
-
Anonymous commented
Please add support for Reporting in PowerShell.
Would help with automation. Need to generate report of permission on whole tenant. PowerShell would enable filtering to run a few hundred site collections in batches, for scale. Thank you.
-
stephen.wortman commented
Looking forward to being able to run the PMR report via PowerShell. I have many sites and these change daily, sot I could benefit from with the PMR being able to ran via PS and not having to manually do it via the GUI. Thank you...
-
Anonymous commented
Yes, If you can do that on GUI, I don't think it is a challenge for you people to give the same on powershell. Looking forward for you guys.
-
Anonymous commented
hi,
it will be great to get information of sites and also for level permissions, group permission, access, etc.. some objects very usefull on powershell
thanks -
Mike Hatheway commented
I think this is done. I have used the Export-Report Powershell command with success.
-
Jeremy Arndt commented
Is this something that your foresee being added in an upcoming version?
-
Genia commented
Is it planned to extend PowerShell to be able to create Permissions Matrix Reports ?
-
Anonymous commented
Bonjour,
Ce serait bien de pouvoir utiliser powershell pour generer des rapports d'Audit :) -
Victor commented
- script reports and export them in csv format
- set the store location
- automate audit reporting