Tips & Tricks
Wild Card Prompts
Question: Can the input variable that is query based be searchable similar to the native SCCM Web Reporting interface? i.e. Can the Collection ID be searched using a wild card rather than having to select one from a drop down only? Background: Let us assume that we...
How To Setup an RDL for ConfigMgr?
I fell down a rabbit hole when I was updating a blog set to show you how to update your reporting Point to HTTPS and Power BI Report Server (PBRS). As I updated the original post, I noticed that some of the other post needed to be updated too. This is one of those...
Tip of The Day – Desktop Icons
I am back from TechDays Ottawa. Where I was using my laptop to give a presentation on Hyper-v live migration. Anyways Rick walked into the room as I was just about to “clean” my desktop of folders and icons. I always do before a giving a presentation. Who wants...
Mailing list / Newsgroup / Forum Etiquette
Since I have not seen anyone else post this to their blog I will. I wonder what happened to Mailing list / Newsgroup / Forum Etiquette? There is some good advices listed within these links for everyone. How to ask a question https://support.microsoft.com/kb/555375 How...
Using Datediff & GetDate in WQL
As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM / ConfigMgr) Adminstrators. Knowing WQL is important! But How do you use Datediff & GetDate in WQL? This blog will talk about for you. Normally I wouldn’t post a reply to blog post but in this case...
Patch Compliance Progression Report
This is the Patch Compliance Progression Report for MECM. This is one of those Software Update (SU) SQL queries that you want. It will grab the MECM software update status compliance of the device. As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM )...
How to Create an Intune Data Warehouse Readers Group
Many Intune administrators are either Azure Global Administrators or Intune Service Administrator. But what you do when you have someone who needs to create Power BI dashboard and reports? Do you really want to give them Intune Service Administrator? Doubtful. In...
How to Create an Intune Data Warehouse Readers Group
Many Intune administrators are either Azure Global Administrators or Intune Service Administrator. But what you do when you have someone who needs to create Power BI dashboard and reports? Do you really want to give them Intune Service Administrator? Doubtful. In...
Unleashing the Power of GetColor Advanced Techniques for PBRS Chart Customization
This blog is the continuation of “How to Utilize Color Palette Function in PBRS for Stunning Visualization”. I will show you how to unleashing the power of GetColor advanced techniques for PBRS chart customization. Thereby allowing your report to be on brand. If you...
How to Utilize Color Palette Function in PBRS for Stunning Visualization
I’m updating my blog post to create a color palette for Ask Garth logo. So, I thought that I would show you the Power BI Report Server (PBRS/PBIRS) or SQL Server Reporting Services (SSRS) function that I use. This function will allow me to apply a defined color...