Category Archives: SSRS

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 | Leave a comment

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