License is per SSRS instance.
This software will give you complete visibility of your SSRS environments. For compliance and auditing this is the only tool to give complete visibility. Additionally for developers this is a needed tool.
·Supports multiple SSRS installations
·Supports all SSRS version native, SharePoint and PowerBI
Source control: Users can update reports. It collects and stores each RDL, dataset mobile reports, PowerBI.
Identify changes to SSRS over a time period, today, week etc.
RDL file compare on previous versions. The file comparison understands XML not just a simple file compare.
·Extract RDL information and report information on:
* Parameters not used
* Reports where fields in the dataset not used- this is a performance issue.
*Issues with fields. Eg. a dataset is updated and the report is using a field that is no longer in the dataset.
*Unused datasets- performance issue.
*Parameter differences. You can have a common parameter name across reports but is the underlying query/stored procedure the same across all reports?
Identify dataset link changes
· Collects the executionlog and log file information presenting relevant information about item usage (report, mobile reports, dataset etc)
Data can be collected in near realtime.
Errors: giving details about the errors- rather than just a message saying rendering error it will tell you where the error is eg in a text box.
§Real World error messages and alert examples (much better than rsRenderingError!!):
·Query execution failed for dataset 'REG'. Invalid object name 'customer'.
·This report requires a default or user-defined value for the report parameter 'MATERIALCODE'
·There is no data for the field at position 56. <<56 is the 56th position in the dataset.
·Cannot impersonate user for data source 'master'. Log on failed. Ensure the user name and password are correct.
·Logon attempt for user 'xxxxx' failed.
·The execution failed for the shared data set 'Dealers'. Cannot create a connection to data source ' xxxx Login failed for user ‘XXX’
·The measure named '[Measures].[P_COMPS]' has 0 corresponding columns. Exactly one should exist. There is no data for the field at position 9.;
·Processed report. Report='/WIP/a_report, Subscription f042e0d3-0a4f-4355-8cea-b4919ea31833 deleted at 07/12/2019 09:10:21 by domain\xxxx
·Call to DeleteItemAction(|mgxcyp55roqr4255zs0nm2ik|@|/xxx/a_report|). User: domain\xxxx.
oShred SSRS log files (ReportServerService… .log)
oReport Memory usage, give warnings of memory pressure.
oReport duration, rows, size etc.
oDetails dataset reporting from AdditionalInfo column
oShred parameter names and columns.
oUser activity. Who ran the report (for audit purposes)
§Users exporting data for report. Useful for control of sensitive data
§Track when items were deleted (and more importantly who deleted)
oUnused reports, and reports infrequently run
oOverview of when reports are run.
oSearch reports run by parameter name and value
oList email addresses for subscriptions.
Identify email failures