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.
How to Install the SQL Server WMI Provider
I wanted to install Ola Hallengren’s SQL Server Maintenance Solution on my lab’s Windows Server Update Services (WSUS). When I tried to install Ola’s script, unfortunately, I received an error message saying that the SQL Server Agent service wasn’t running. I thought...
How to Install the SQL Server WMI Provider
I wanted to install Ola Hallengren’s SQL Server Maintenance Solution on my lab’s Windows Server Update Services (WSUS). When I tried to install Ola’s script, unfortunately, I received an error message saying that the SQL Server Agent service wasn’t running. I thought...
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...
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...
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...
Business Intelligence Development Studio (BIDS) or Report Builder (RB)?
I often get asked why I always use Business Intelligence Development Studio (BIDS) instead of Report Builder (RB), so this blog post will help to identify some of the reasons why I prefer BIDS to RB. Business Intelligence Development Studio vs Report Builder BIDSRBYou...
How to Set-up an Email Subscription in SSRS
On a fairly regular basis, someone within the forums or mailing list will ask, “How can I email a copy of my SCCM report to my Manager every week?” As Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM /ConfigMgr ) Administrator, You need to...
How to Setup the Most Complicated MEMC Environment
Installing and setting-up Configuration Manager (CM) can be a long and time consuming task, but CM Admins can make this even more complicated for themselves. And yes, this is possible! For this example I am using CM12 SP1 R2. But how can you setup the Most Complicated...