I'd like to export the list of those that my report has been shared with. The list has gotten rather long and exporting is the most efficient way. Is there a way to do this? I am already at the list of recipients, I just don't see a way to export.
You can proably use the REST API to get this using some PowerShell.
You can of course query the backend database (ReportServer DB) if you have access with something like this
All our security is applied at a folder level (hence the Type=1) if its an indivuidual report you would need to figure out how to query for that within the dbo.catalog table.
SELECT u.UserName ,r.RoleName FROM dbo.PolicyUserRole pur LEFT OUTER JOIN dbo.Roles r ON r.RoleID = pur.RoleID LEFT OUTER JOIN dbo.Users u ON u.UserID = pur.UserID WHERE pur.PolicyID = ( SELECT PolicyID FROM dbo.Catalog WHERE Type = 1 AND Path = '<PATH_TO_FOLDER>' );
If you install the ReportingServicesTools PowerShell module from here
you can get the data back pretty easily.
Import-Module ReportingServicesTools $CatItemRoles = Get-RsCatalogItemRole -Path "/ThisFolderOrItem" -ReportServerUri "http://yourServerName/ReportServerPBI" $CatItemRoles | Export-Csv -LiteralPath "C:\CatItemRoles.csv"