List all report on report server

Question

Post reply

List all report on report server

krypto69

SSChampion

Points: 13604
More actions
October 8, 2009 at 9:15 am

#212014

Is there a query out there that will show me all of the reports on my report server...and who has access to these reports?
If I use 'select name, path from catalog' gives me everything I need
except
user access info

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Express12 SSCoach Points: 18514 More actions · Answer 1

I have a similar need here - Is there a way to get:

- a list of ALL reports on the Report Server (we have SSRS 2008)

- the last time each was run

- who created it

thanks in advance

BT

peterzeke SSCrazy Eights Points: 9003 More actions · Answer 2

krypto69 (10/8/2009)
Is there a query out there that will show me all of the reports on my report server...and who has access to these reports?
If I use 'select name, path from catalog' gives me everything I need
except
user access info

Check out Michael Davis's Report Server Diagnostic Report Pack[/url] here on SSC -- it's a series of SSRS 2005 reports that lists reports, last accessed, permissions, etc. Not sure how well it translates to SSRS 2008, though, but might be worth looking at.

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

most excellent, this has been book marked and a copy of the zip uploaded to my drop box so I dont forget about it.

Express12 SSCoach Points: 18514 More actions · Answer 4

thanks Peter. I will review these. Much appreciated.

BT

P Jones SSChampion Points: 12361 More actions · Answer 5

Check out Michael Davis's Report Server Diagnostic Report Pack here on SSC -- it's a series of SSRS 2005 reports that lists reports, last accessed, permissions, etc. Not sure how well it translates to SSRS 2008, though, but might be worth looking at.

It works fine on 2008 - I may have had to do a minor tweak but it was obviously so minor I've forgotten it. I have it running on all report servers, both 2005 and 2008. You may need to adjust the report server logging properties to change the "remove log entries after x days" setting.