Category Archives: SSRS

SSRS ReportServer log file uncontrolled growth

When installing SSRS, there are two databases that get installed (default); ReportServer and ReporServerTempDB. With SSRS, whether for SCCM or reporting in general, by default the ReportServer database Recovery model is enabled as FULL. Which means that all activity in … Continue reading

Posted in SCCM, SQL Server, SSRS | Leave a comment

Create Custom Report User Role for ConfigMgr 2012 R2

Most of the information you need to create the Report User role is contained in Kent’s blog: http://blog.coretech.dk/kea/creating-the-reporting-user-role-in-configmgr-2012/ To make things a little easier, from the ConfigMgr console > Administration > Security > Security Roles, right click and import the … Continue reading

Posted in ConfigMgr, SSRS | Leave a comment

ConfigMgr 2012 – Identify Custom SSRS Reports

Working through an upgrade / migration on a client site and needed to be able to identify custom reports created within the ConfigMgr 2012 reporting structure. The following query will provide that information, change the DOMAIN below to match your … Continue reading

Posted in ConfigMgr, SQL, SQL Server, SSRS | Leave a comment

System Center 2012 Configuration Manager: A Practical Handbook for Reporting

Since I’ve had a number of people ask where they can find it, this book is now available on Amazon. Thank you for your support! http://www.amazon.com/dp/9187445174 Print only at this point, Kindle version should be available in a week or … Continue reading

Posted in ConfigMgr, SQL, SSRS | Leave a comment

Practical Handbook for Configuration Manager 2012 R2 Reporting

This project has been in the works for a few months, very proud of this work. More details to follow.

Posted in ConfigMgr, SQL Server, SQL Server 2012, SQL Server 2014, SSRS | 10 Comments

2015 IT Dev Connections Session

  It is official! Garth Jones (@GarthMJ) and I (@Steve_TSQL) and I will be presenting:  Advanced SSRS reports for ConfigMgr 2012 Admins at IT/Dev Connections 2015 for more information and to register please visit, http://www.devconnections.com/ Watch our blogs and twitter … Continue reading

Posted in 2015 Dev Connections, SSRS | Leave a comment

How to list SSRS Report permissions

  Have you ever needed to know which groups or users have access to your reports? Use the following query to get a comprehensive list of who has access to what. USE ReportServer GO select u.UserName, r.RoleName, r.Description, c.Path, c.Name … Continue reading

Posted in SQL, SQL Server, SQL Server 2012, SSRS | Leave a comment