Export Report to PDF, Email, SP library, etc.
Export Report results to...
- a SharePoint list or library instead of to Excel so all users can see it and set up alerts on it
- in a CSV format
- a PDF file
- send by email, even automatically send some of the reports to the site owners for example
- a fileshare, or drive of your choice
Also able to do so with Custom Reports.
We have started working on being able to automatically export to a SharePoint Library once an operation is done. We feel that this will allow you to, in conjunction with Workflows or MS Flows, to automate a lot of work.
We’ll keep you updated when this is released.
Jin Sui commented
Please, i want this feature for automation.
This would be great
I can't wait as this will make my job a lot easier. Can you fix one issue with the reporting while your working on this? Where there is a space in the URL place a %20 so that when a user clicks the link in the report it will take them to the site or file instead of a message that it can't locate the page due to the space in the URL?
Ayush Singh commented
To be able to operate against thousands of sites, the ability to assess the site structure and permissions is integral. Having to do that through the UI is both tedious and labor intensive. That is counter-productive.
It would be great if the aforementioned capability of generating custom reports from powershell.
It would also be helpful to be able to export a report or migration settings to a powershell script.
For all of my sites, I have data owners. They ask randomly for Permission Matrix reports. I see where I can schedule the Permission Matrix reports, but it would be great to be able to expand all colums, and export it to a site within SharePoint. This would make it more self service to the users.
I don't know how tall of an order this might be, but it would be useful to be able to export the permissions matrix report as a PDF file, as well as a spreadsheet.
The hierarchical view on the screen is useful to some to wrap their brains around the permissions. Thanks for your consideration.
Perhaps re-iterating some points from the comments but it would be great to be able to
- email the reports out to certain users. eg to email reports to the site owners
- able to specify "Or" parameters when creating reports. eg "List Template Is "Document Library" OR "Custom List"
- Have the results exported to Excel already grouped so that the Excel view looks the same as the view displayed in the UI (eg Permissions matrix grouped by site and permission group)
Karl Gerd Schneider commented
Also need export to library or email for Flow trigger
Robert Holloway commented
Anyway to have any report exported to a Document Library via scheduled task in O365 and then up to the user to setup Flow to do the necessary custom action i.e. email to specific users. Just having the functionality to export a report to a designated location would be great!
Email, Email, Email!!!
Would it be possible to email reports after they are ran or scheduled? Point it to an SMTP server and email the XLS?
Matt Hawkins commented
In my environment I would like to setup predefined reports on specific sites/libraries where the results are saved to a defined library as Excel files. My users can then set alerts of them and take a look whenever I update.
We use Sharegate to audit our access to sensitive SP sites. These reports need to run daily and have to be reviewed and approved in SP. But the only way to get the reports into SP is to manually download them and then upload to SP. Need to be able to schedule automated export of reports to file share at a minimum, to SP would be ideal.
Need this to automate SP/SPO management and reporting
The excel export is not very easy to understand but the report within SharePoint is simple and easy to read. It would be good to have the ability to export the screen view to PDF.
As I am using your reporting more and more, I would really like the ability to schedule a report where the results are loaded direclty into an SPO list. If we can't get it to a list, can we have the results exported automatically to a Ondrive folder?
Hi Shargate team,
Thanks for the great application. i used it in the past and I'm happy we'll probably soon buy a license so I can use it again in my new job.
I would like to participate to make Sharegate even more better than it already is. Personally I think the reporting part is not used a lot by many people. Atleasted if I talk about it with fellow SharePoint people not a lot heard of it.
One thing I would like to see is the scheduling of reports to be improved. In some cases like audits we delegated the control and would like to send the CSV on a timed basis to a person.
Now I can schedule it but not sent it to a owner.
Thanks in advanced,
I run this report for managers to verify permissons for employees but it only allows me to export it in excel format which is hard for a manager to read. What would be helpful is to get out a PDF that looks exactly like what comes out on the Sharegate screen.
Need this to automate SP/SPO management and reporting
Hi there, this is nothing dire - just a request. I love the audit report that you offer. Since this information is typically requested by a site owner (usually of a sub-site where they don't have access to this feature), it would be great if email functionality could be added so that scheduled reports can be automatically emailed to the requester., eliminating SharePoint Farm Admins from having to act as middle man.