Searching T-Sql embedded in SSRS reports

Question

Post reply

Searching T-Sql embedded in SSRS reports

rehman-615909

Ten Centuries

Points: 1360
More actions
March 19, 2017 at 9:14 am

#323012

Hi,
Is there a way to search SQL script inside SSRS reports?
One of our linked server name is changing. I do not know how many reports reference that linked server. Going into each report and checking will obviously be very time consuming. What are my options here?
TIA
Thanks,
kr

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

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

Jeffrey Williams SSC Guru Points: 90252 More actions · Answer 1

http://bretstateham.com/extracting-ssrs-report-rdl-xml-from-the-reportserver-database/

Found this - should get you started...

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Phil Parkin SSC Guru Points: 246695 More actions · Answer 2

rehman-615909 - Sunday, March 19, 2017 9:14 AM
Hi,
Is there a way to search SQL script inside SSRS reports?
One of our linked server name is changing. I do not know how many reports reference that linked server. Going into each report and checking will obviously be very time consuming. What are my options here?
TIA
Thanks,
kr

SSRS reports (.RDL files) are comprised of XML and are therefore quite easy to search across.
Use something like FileSeek to do the search for you. It is fast and allows Regex searching, which I've found very useful on several occasions.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

rehman-615909 Ten Centuries Points: 1360 More actions · Answer 3

Thanks Jeffrey, the linked article provided me what I was looking for.
Phil, I knew about the .rdl files. However, I was looking for a way to search all the reports just like we can search stored procedures in a database or a server for any text.
Thanks,
kr

Phil Parkin SSC Guru Points: 246695 More actions · Answer 4

rehman-615909 - Monday, March 20, 2017 12:23 PM
Thanks Jeffrey, the linked article provided me what I was looking for.
Phil, I knew about the .rdl files. However, I was looking for a way to search all the reports just like we can search stored procedures in a database or a server for any text.
Thanks,
kr

...Then you should have stated as much in your original post 😛

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.