Category: Role-Based Administration

August 21, 2019
No Rows – What It Is and Why You Should Use It

Instead of showing empty report sections because a query produced no results, I wanted to add some text to explain the outcome. I turned to an option called, No Rows,…

July 10, 2019
RBA and Non-RBA Queries: When is Slower Actually Faster?

Up until now, my experience working with SCCM’s Role-Based Administration (RBA) queries showed them to be slower than the normal SQL Server views. My thoughts changed, however, when I recently…

May 22, 2019
What Are the Supported SQL Server Views to Use with SCCM Reporting?

Have you ever wondered what SQL Server views you can use with SCCM current branch reporting? You wouldn’t be alone in asking this question because the views are not clearly…

February 13, 2019
Non-Printable Characters in SCCM

Recently, the Enhansoft Team was made aware of an issue with non-printable characters in several System Center Configuration Manager (SCCM) SQL Server views. What does this mean? SCCM reports with…

June 27, 2018
How to Start Editing SCCM Reports with Report Builder

Did you know that you need a Role-Based Administration (RBA) security role when you want to edit System Center Configuration Manager (SCCM) Current Branch or 2012 R2 reports with Report…