March 19, 2017 at 9:14 am
March 19, 2017 at 11:09 am
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
March 19, 2017 at 11:19 am
rehman-615909 - Sunday, March 19, 2017 9:14 AMHi,
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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 20, 2017 at 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
March 20, 2017 at 12:59 pm
rehman-615909 - Monday, March 20, 2017 12:23 PMThanks 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 😛
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply