Tips & Tricks
Which Security Accounts Are Used within ConfigMgr SSRS Report Execution?
In a recent tweet, S. D’Souza @sdsouza78 said, "It always confuses me which account/security context gets used where when running reports from within SCCM/SSRS environment." I found his admission interesting and my first reaction was to say that SSRS always uses your...
How Does the ConfigMgr SSRS Report Execution Workflow Operate?
Recently S. D’Souza @sdsouza78 sent me a tweet asking: “Is there an SCCM/SSRS article which explains the report execution flow starting at SCCM console ending with SQL Report displayed?” I’ll try to answer this question by saying right off the bat that you should...
Holy Cow, 4.5 Million Extra Rows…! Wow.
The title of this post, "Holy cow, 4.5 million extra rows...! Wow," is a quote from Alexander Phu when we were discussing the differences between Power BI and SSRS for ConfigMgr reporting. In my last blog post, I talked about how the SQL Server Team believes that...
Android VM Setup Tips
You finally setup your Android VM! Congratulations! Here are a few tips that I found useful and I think that you will too. Turn Off the Screensaver I know this one might seem like a dumb tip, but seriously, this one will save you from a lot of frustration. Why? If you...
How to Configure a First-Time Android VM
In my last two blog posts, I showed you how to create a VM and then how to install an Android 4.4 R5 within that VM. In this blog post I will show you how to configure a first-time Android device. 1. After the initial boot, the Android logo will appear on the screen...
How to Install Android 4.4 R5 on a VM
In this blog post I will continue to show you how to create an Android virtual machine (VM). Once the VM is created, you need to install Android 4.4 R5. 1. Download Android 4.4-R5 ISO. 2. Ensure that the Android ISO is attached to the VM. 3. Start the VM and then...

How to Install AD Certificate Services
A Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM / ConfigMgr) administrator wears many hats. One of the hats means that we need to know about Certificate. This is becoming more import as thing move to the cloud and become more secure. Most ConfigMgr...
How to Install AD Certificate Services
A Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM / ConfigMgr) administrator wears many hats. One of the hats means that we need to know about Certificate. This is becoming more import as thing move to the cloud and become more secure. Most ConfigMgr...
How to Create a Color Palette for Your ConfigMgr Reports
I often get asked how someone without a visual arts background can choose or create a color palette. For Microsoft Configuration Manager (ConfigMgr / SCCM) reports. ConfigMgr Reporting Points use either Power BI Report Server (PBRS / PBIRS) or SQL Server Reporting...
How to Create Computer based on Users’ Department Collection
This is a fairly common request but goes against the idea of Microsoft Endpoint Configuration Manager (MECM / SCCM / MEMCM/ConfigMgr). You should either target a user or a computer. But not the computers of a Users. I know the first thing you will say is but software...