April 5, 2019 at 12:38 pm
I am trying to get a listing of all my SSRS reports along with the underlying stored procedure. I found some code, I appologize to the author for not remembering his name, that extracts the CommandType and CommandText to get "StoredProcedure" and the name of the stored procedure. The problem is...many of the report xml files are missing the CommandType and CommandText tags/nodes. I'm not very familiar with xml. Any thoughts?
April 8, 2019 at 2:11 pm
I found the author, Ben Gribaudo. I'm not sure you understood my issue. I have several hundres stored procedures and only a little over a hundred show up in the query and I don't know why.
April 12, 2019 at 5:38 pm
Check this: https://gallery.technet.microsoft.com/scriptcenter/42440a6b-c5b1-4acc-9632-d608d1c40a5c
--Vadim R.
April 12, 2019 at 5:45 pm
Thanx
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy