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: 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! 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, 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 | 3 Comments

SCCM 2012 computer information query

I was recently asked to create a query based on the following requirements: On Windows XP systems only, provide the following information for each system: 1.      Processor speed and type 2.      Memory 3.      Total disk space, free space 4.      IP … Continue reading

Posted in ConfigMgr, SQL, SSRS | 5 Comments

ConfigMgr 2012 SSRS fails after upgrade to SQL 2012

I don’t often re-blog other postings, but this particular issue had me puzzled and it is worth giving this exposure. After the upgrade from SQL Server 2008 R2 to SQL 2012, if you check any of the CM SSRS reports, … Continue reading

Posted in ConfigMgr, SQL, SSRS | 3 Comments

ConfigMgr Software Update Summarization Task

By default the summarization task runs every 1 hour, on a very large sites it causes a large spike in CPU utilization. What follows is a summary of investigating this issue on a very large site of approximately 150,000 clients. … Continue reading

Posted in ConfigMgr, SQL Server, SSRS | 1 Comment