List of Procedures used in RDL on Production site

Is there a way to search all of the RDL's that have been deployed out to a
Reporting Services site? I am looking for what stored procedures are being
used on our production reporting site.
Any help would be appreciated.All the deployed reports are stored in a table called "catalog" you can get a
list by querying the table.
Amarnath
"LostinSpace" wrote:
> Is there a way to search all of the RDL's that have been deployed out to a
> Reporting Services site? I am looking for what stored procedures are being
> used on our production reporting site.
> Any help would be appreciated.|||I appreciate the response, but this is not what I am looking for.
I need to search the content inside every single rdl to see what stored
procedures are being used. If there isn't a way to do this in RS, is there a
way to do this from vss?
"Amarnath" wrote:
> All the deployed reports are stored in a table called "catalog" you can get a
> list by querying the table.
> Amarnath
> "LostinSpace" wrote:
> > Is there a way to search all of the RDL's that have been deployed out to a
> > Reporting Services site? I am looking for what stored procedures are being
> > used on our production reporting site.
> > Any help would be appreciated.|||OK You said "deployed" so I gave that answer...
You can search for "<CommandType>StoredProcedure</CommandType>" and the next
line will be the stored procedure name. and select look in "Current project"
from the find dialog box.
Hey this looks very basic, is this what you want ?
Amarnath
"LostinSpace" wrote:
> I appreciate the response, but this is not what I am looking for.
> I need to search the content inside every single rdl to see what stored
> procedures are being used. If there isn't a way to do this in RS, is there a
> way to do this from vss?
> "Amarnath" wrote:
> > All the deployed reports are stored in a table called "catalog" you can get a
> > list by querying the table.
> >
> > Amarnath
> >
> > "LostinSpace" wrote:
> >
> > > Is there a way to search all of the RDL's that have been deployed out to a
> > > Reporting Services site? I am looking for what stored procedures are being
> > > used on our production reporting site.
> > > Any help would be appreciated.|||Deployed is correct. I need to search every single rdl deployed to our RS site.
I need to find what stored procedures are used in each rdl. I do not seem to
be able to
do this from the ReportServer database. I know how to do this from the rdl
when in working with the rdl on its own in Visual Studio, but I have over 500
reports in RS. I need a quick and painless way to search all of the rdlâ's at
the same time to see their stored procedures.
I do appreciate the response, I just have a feeling this can not be done...
"Amarnath" wrote:
> OK You said "deployed" so I gave that answer...
> You can search for "<CommandType>StoredProcedure</CommandType>" and the next
> line will be the stored procedure name. and select look in "Current project"
> from the find dialog box.
> Hey this looks very basic, is this what you want ?
> Amarnath
>
> "LostinSpace" wrote:
> > I appreciate the response, but this is not what I am looking for.
> > I need to search the content inside every single rdl to see what stored
> > procedures are being used. If there isn't a way to do this in RS, is there a
> > way to do this from vss?
> >
> > "Amarnath" wrote:
> >
> > > All the deployed reports are stored in a table called "catalog" you can get a
> > > list by querying the table.
> > >
> > > Amarnath
> > >
> > > "LostinSpace" wrote:
> > >
> > > > Is there a way to search all of the RDL's that have been deployed out to a
> > > > Reporting Services site? I am looking for what stored procedures are being
> > > > used on our production reporting site.
> > > > Any help would be appreciated.