cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Exporting list of those with access to the Report

Hi, 

 

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.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Open the Manage permissions page of the dataset  in Chrome, and then start a developer mode using F12

 

in the console area type the following command:

 

$('span.emailColumn').each(function() { console.log ($(this).text())})

 

This will give you all the mail addresses 🙂 in a list

 

or.... even cooler:
$('.permissionTable li').each(function() { console.log ( $(this).children('span.nameColumn').text(),",",$(this).children('span.emailColumn').text(),",",$(this).children('span.memberAccessColumn').text())})

 

which will give you a CSV list in the console to be copy/pasted

 

View solution in original post

15 REPLIES 15
Impactful Individual
Impactful Individual

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>' );
Impactful Individual
Impactful Individual

If you install the ReportingServicesTools PowerShell module from here

 

https://github.com/Microsoft/ReportingServicesTools

 

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"

 

from where i can get the access of the db

Impactful Individual
Impactful Individual

When you install PBI Reporting Server it has to be setup with a database backend. You can see where this is by running the PBI Reporting Server config tool on your PBI Reporting server. You will need permissions to go query that server and DB.

 

 

Open the Manage permissions page of the dataset  in Chrome, and then start a developer mode using F12

 

in the console area type the following command:

 

$('span.emailColumn').each(function() { console.log ($(this).text())})

 

This will give you all the mail addresses 🙂 in a list

 

or.... even cooler:
$('.permissionTable li').each(function() { console.log ( $(this).children('span.nameColumn').text(),",",$(this).children('span.emailColumn').text(),",",$(this).children('span.memberAccessColumn').text())})

 

which will give you a CSV list in the console to be copy/pasted

 

View solution in original post

Hi,

 

Where do you get from the Report Server URI parameter?

 

Thanks!

Cristina

You don't need the  Report Server when you use the trick with the debugging tools

No? What do you need then? I write this on Power Shell: Import-Module ReportingServicesTools; Get-RsCatalogItemRole this is what I'm getting:

Failed to establish proxy connection to http://localhost/reportserver/ : Failed to establish proxy connection to http://localhost/reportserver/ReportService2010.asmx : There was an error
downloading 'http://localhost/reportserver/ReportService2010.asmx'

 

 

The first lines of code are part of this: 

Import-Module ReportingServicesTools
$CatItemRoles = Get-RsCatalogItemRole -Path "/ThisFolderOrItem" -ReportServerUri "http://yourServerName/ReportServerPBI"
$CatItemRoles | Export-Csv -LiteralPath "C:\CatItemRoles.csv"

 

That's why I was asking for the ReportServerUri parameter.

 

Please, help me 🙂 

 

Kind regards, 

Cristina Simion

Sorry, but I don't know... I took a different approach

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors