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