Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««89101112»»»

Report Server Diagnostic Reports Expand / Collapse
Author
Message
Posted Thursday, January 12, 2012 8:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 5:48 AM
Points: 27, Visits: 163
Awesome stuff James!!!

This is a really great find and is in many ways a holy-grail find for what we've been trying to do!!!
Post #1234924
Posted Thursday, January 12, 2012 4:04 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 1:14 PM
Points: 12, Visits: 128
michael_davis2 (1/12/2012)
Awesome stuff James!!!

This is a really great find and is in many ways a holy-grail find for what we've been trying to do!!!


Thanks! FYI, I've updated the prior post to include one more query set that can be used to fetch the Report Data Sources that have a connection string embedded in the report as well. I've managed to work it out in such a way that the whole thing can be resolved without ever touching the database directly.
Post #1235294
Posted Wednesday, January 18, 2012 12:08 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 1:14 PM
Points: 12, Visits: 128
Another fun XML query. This one will get the command text for Datasets in the report:

Create a Query to Get the Report Datasets Using the GetReportDefintion Method


  • Right click on the Shared Datasets folder.

  • Select Add New Dataset.

  • Set the Name to ReportService2005_GetReportDefinition_ReportDataSources.

  • Set the Data source to ReportService2005WebServiceAPI.

  • Set the Query type to Text.

  • Place the following code into the Query:

    <Query>
    <Method Name="GetReportDefinition" Namespace="http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices">
    <Parameters>
    <Parameter Name="Report"/>
    </Parameters>
    </Method>
    <ElementPath IgnoreNamespaces="true">
    GetReportDefinitionResponse/Definition(Base64Encoded)/Report{}/DataSets/DataSet
    {
    @Name(string),
    }
    /Query
    {
    CommandText(string),
    DataSourceName(string)
    }
    </ElementPath>
    </Query>


  • Go to the Parameters page.

  • Click OK on the warning that about "Could not create a list of fields for the query."

  • Click Add.

  • Set the Name to Report.

  • Set the Data Type to Text.

  • Go back to the Query page.

  • Click Refresh Fields.

  • Enter the path to a data source, i.e. /MyReportsFolder/MyReport, in the Parameter Value for DataSource.

  • Enter true in the Parameter Value for Item.

  • Click OK.


Post #1238201
Posted Wednesday, February 1, 2012 3:53 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, March 31, 2014 9:19 AM
Points: 314, Visits: 677
I was looking manually in some of the report server tables just yesterday and I noticed what a wealth of useful information was contained within them. I was going to create my own reports but these are far more comprehensive!

As an additional bonus I can learn some tricks from the formatting and features in these reports to apply to my own reports.

Thanks for this most useful collection of reports and interesting article.
Post #1244956
Posted Thursday, May 24, 2012 9:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 3, 2014 1:14 PM
Points: 1, Visits: 16
Any idea if this works with SSRS 2012?
Post #1305975
Posted Thursday, May 24, 2012 1:01 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 5:48 AM
Points: 27, Visits: 163
I don't know - we're just getting ready to go to 2012 soon (and when I do, you can bet these will be one of the first things I check out).

In the reading I have done, it sounds like SSRS pretty much will be in Sharepoint Integration mode from the start (I may be wrong here but that was the impression I got). Due to that, it may be possible that the repository could be structured differently. Microsoft never blessed accessing the database directly -- so I wouldn't be surprised if there were changes.

If you come across the answer before I do, I'd appreciate hearing what it is.

Thanks!!!
Post #1306085
Posted Thursday, May 24, 2012 3:16 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, November 7, 2014 9:05 AM
Points: 54, Visits: 310
Yes, these reports will work fine in 2012. With sharepoint intergration the ExecutionlogView3 is on the farm where the reportserverdb lives.
This is the primary view for these reports.
Post #1306191
Posted Friday, May 25, 2012 6:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 5:48 AM
Points: 27, Visits: 163
Great - thanks for the info!!!
Post #1306487
Posted Tuesday, September 18, 2012 12:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 8, 2013 9:45 AM
Points: 3, Visits: 30
Hopefully you guys can help me, we have been using the diagnostics reports for a long time. But recently we started deploying reports directly from VS2010 to SSRS 2008 R2 and for some reason any of the reports deployed this way do not show up at all when we run the "ReportQueries" if we run any of the other diagnostic reports all of the reports show up.
Post #1360943
Posted Tuesday, September 18, 2012 4:17 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, November 7, 2014 9:05 AM
Points: 54, Visits: 310
Are you no longer deploying them through bids?
Post #1361052
« Prev Topic | Next Topic »

Add to briefcase «««89101112»»»

Permissions Expand / Collapse