Garth’s Answers
Welcome to Ask Garth, the ultimate resource for all your Intune and ConfigMgr Inventory and Reporting questions. Whether you need assistance with PBRS, SSRS, Power BI or General Intune OR ConfigMgr topics. Our expert, Garth Jones, shares his in-depth knowledge and provides step-by-step guides to help you navigate through the complexities Intune and ConfigMgr. Explore our informative articles and tutorials to enhance your skills and stay up-to-date with the latest industry trends. Join our newsletter to receive exclusive updates and never miss out on valuable insights. Follow us on social media for more useful content and stay connected with the Ask Garth community.

What is a 4-part version numbers?
The problem of querying 4-part version numbers has long been a problem. I have seen many solutions, but none are 100% fool proof, until now. But what is a 4-part version numbers? This article will go into details to explain 4-part version numbers and how SQL Server...
What is a 4-part version numbers?
The problem of querying 4-part version numbers has long been a problem. I have seen many solutions, but none are 100% fool proof, until now. But what is a 4-part version numbers? This article will go into details to explain 4-part version numbers and how SQL Server...
What is RDCM?
As a Microsoft Configuration Manager (SCCM / ConfigMgr / MCM) admin, I spend my time switching between differ servers. Over the years, I have come to LOVE Remote Desktop Connection Manager (RDCM), which is one of the Sysinternals tools! Recently I was showing a team...

What is RDCM?
As a Microsoft Configuration Manager (SCCM / ConfigMgr / MCM) admin, I spend my time switching between differ servers. Over the years, I have come to LOVE Remote Desktop Connection Manager (RDCM), which is one of the Sysinternals tools! Recently I was showing a team...

How to Code Sign PowerShell
There is a very long story about PowerShell, ConfigMgr, Jeffrey Snover, and me. The short version is that story is that I’m getting to use PowerShell to its fullest now. In today world, a Microsoft Configuration Manager (SCCM / ConfigMgr / MCM) administrator must...
How to Code Sign PowerShell
There is a very long story about PowerShell, ConfigMgr, Jeffrey Snover, and me. The short version is that story is that I’m getting to use PowerShell to its fullest now. In today world, a Microsoft Configuration Manager (SCCM / ConfigMgr / MCM) administrator must...
Adding an All Option to Your Prompt
In my blog post, Turning Three Reports into One Report, I said that I would show you how to adjust your prompt to allow for an, “All Option.” Everything you need to do is within the SQL Server queries themselves. This blog post shows you how to edit BOTH the prompt...
Enhancing GetColor to add Defined Colors
While creating the videos for the GetColor updates. It dawned on me that I should show you how to Enhancing GetColor to add Defined Colors. To do this, I will show you how to define colors for a particular string value using the GetColor function. DEFINE COLORS Before...
How to Create a Visual Filter in Power BI
Hi Everyone! Today I am talking about How to create a visual filter in Power BI and how to set them up. This post is part of a series of blog posts that we’ve done at Enhansoft about the different types of Power BI filters. Visual filter are useful for refining...