Category Archives: SSRS

SSRS ReportServer log file uncontrolled growth

Posted on January 22, 2019 by ConfigMgrMVP

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

Posted on October 27, 2015 by ConfigMgrMVP

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

Posted on October 7, 2015 by ConfigMgrMVP

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

Posted on September 18, 2015 by ConfigMgrMVP

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

Posted on August 27, 2015 by ConfigMgrMVP

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

Posted on April 6, 2015 by ConfigMgrMVP

  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

Posted on October 10, 2014 by ConfigMgrMVP

  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

Posted on February 5, 2014 by ConfigMgrMVP

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

Posted on September 24, 2013 by ConfigMgrMVP

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

Posted on July 3, 2013 by ConfigMgrMVP

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