Auditing SSRS Report
We can use the SSRS Report Server Execution Logs (link) to review who is executing reports on the server. These logs are saved directly in the SSRS database Report Server. There are three views available to us to show the information on who executed the report, how long the execution took, and parameters were used.
However by default the data in the views is only kept for 60 days. We can change that however via SSMS.
* Open SSMS.
* Connect to Reporting Instance.
* Right lick on Reporting Server Go To Properties.
* Go to Logging.
* Checking the Remove Log Entries Setting as per in screenshot below.
* Click Ok.
I would not recommend making this number large; as it will bloat your database. Also please don’t give access to people to run queries against this view. Instead develop a view with filtered set and develop a report that is published against the new view. Because the execution log contains parameter information, it might also hold sensitive information
Let me know if you have any further question and your comments will be learning point.
Microsoft Certified Solutions Associate (MCSA)
Companies Producing DWBI Software:
- Microsoft: SQL Server, PDW, SSAS, SSIS, SSRS, Crescent, Performance Point, PowerPivot. The most widely used DWBI products.
- Oracle: Oracle 11g, OBIEE (was Siebel), ODI, Hyperion, Essbase, Exadata, Golden Gate, Oracle OLAP. Widely used, good quality, good support. One of the oldest, top, respectable names in DWBI.
- IBM: Data Stage, Infosphere, Cognos, TM1, DB/2, Express. Now include Netezza. Giant in DWBI, possibly in top 3.
- Informatica: PowerCentre, IDE, IDQ. Best ETL/DI tool on the planet, features wise (and performance). One of the oldest, well respected names in BI
- SAP: BusinessObjects, Business Warehouse, Netweaver BI. Giant in DWBI, worldwide. Wow I love this particular Hana.
- Strategy Companion: offering a product called Analyzer, which is a SSAS client (cube browser) and dashboard.
- Tableau: the best SSAS client (appearance wise), in my opinion. Good charting/visualisation.
- QlikTech: appearance wise, QlikView is the slickest analytics tool on the planet.
- MicroStrategy: comprehensive reporting solution and integrated BI platform. Multidimensional and relational. One of the oldest, well respected names in BI.
- Ab Initio: ETL/DI tool.
- Teradata: a very good MPP, feature wise. Long history, proven in many customers. Wide range of products.
- Wherescape: offering a DW product called Red, which is known for its speed in building a DW in any RDBMS. In UK & US.
- SSAS clients: various companies producing SSAS tools. The most comprehensive list on the planet (by far), 74 tools and counting.
- Jaspersoft: growing rapidly in popularity. Widely known for their very low cost. Complete BI platform: DI/ETL, Reporting, Analytics.
- SAS: analytics, data mining, ETL/DI, DQ (DataFlux), MDM. One of the most complete BI platform. Historically respected as world #1 in data mining.
- Actuate: a product suite called BIRT (stands for BI Reporting Tool), which is known for its visualisation. No ETL/DI.
- Inetsoft: a product suite called Style, a reporting tool known for its visualisation. No ETL/DI.
- iQ4bis: reporting/analytics solution. Prebuilt plugins for JD Edwards & MS ERPs (Dynamics, Axapta, Great Plain, Dynamics NAV) for reporting/analysis via SSAS, SSRS, Excel Pivot tables and iQ4bis own tool.
- Board: reporting/analytics plus EPM (budget vs performance, etc).
- Trillium: considered as one of the best and widely used data quality tool in DWBI world.