Category: Query

September 18, 2019
How to Create a Collection for Workstations

This might seem like an odd blog post to write. Why not simply search for all workstations with “Windows 7%” and “Windows 10%” in your query? Once you have this…

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 30, 2019
Visual Studio Code

You know how life gets busy and you never seem to have any time for smaller projects? Well, am I ever grateful to Julie Andreacola who reminded me about Visual…

July 24, 2019
Setting Up Security for SCCM Power BI Reports

What do I mean by, “Setting up security for SCCM Power BI reports?” First, in order to create and run Power BI reports, you need to access the SQL Server…

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…

June 5, 2019
Using a SQL Server Query to Create a PowerShell Script

This blog post is really meant for those who are better at writing SQL Server queries than at writing PowerShell scripts. I am one of those people, so recently I…

August 15, 2018
How to Leverage the Interactive Sorting Feature in SCCM Reports

Have you ever watched someone use one of your reports/dashboards? I have and it is always fascinating to see how someone will review the data. If they have prior experience…

August 8, 2018
Adding a Prompt Value to the Title of a SCCM Report

Little things do make a difference and this is especially true when it comes to SCCM reports. Oftentimes in my report writing sessions I don’t have time to show folks…

July 11, 2018
Seven Tips for Writing SCCM Dashboards

At the last Midwest Management Summit which was held at the Mall of America, I was stopped in the hallway after one of my SCCM reporting presentations. I was asked…

December 12, 2017
Getting Started with Power BI Desktop and SCCM

In this blog post I will show you how to connect Power BI Desktop to your System Center Configuration Manager (SCCM) SQL Server database. During the connection process I will…