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.
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...
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...
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...
Remote SQL Server with a Named Instance
As Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM / ConfigMgr ) administrator we wear many hats. One of those hats is SQL Server administration. We use SQL for several components within ConfigMgr including ConfigMgr, WSUS and SQL Server Reporting...
Remote SQL Server with a Non-Default Port
Sometimes people want to make life difficult for themselves. SQL deployments in a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM /ConfigMgr ) environment come to mind. In one such example, deploying a remote SQL installation with a default instance name...
“Invalid object name” in SSMS
As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM / ConfigMgr ) administrator We are not always well verse with SQL Server and its errors. Particularly within SQL Server Management Studio (SSMS). In this Article and video, we will show you how to...