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 use PowerShell to query SQL Database?
This question comes up from time to time, where someone want to query MEMCM using WQL and runs into problems. I have done allot of work with WQL recently. What you will find when you query WMI with WQL is that you will easily hit WMI timeouts or Quota Violation from...
How to use PowerShell to query SQL Database?
This question comes up from time to time, where someone want to query MEMCM using WQL and runs into problems. I have done allot of work with WQL recently. What you will find when you query WMI with WQL is that you will easily hit WMI timeouts or Quota Violation from...
How to Backup BitLocker Recovery Key to AD
Recently, I was helping someone troubleshoot and issue with BitLocker and is storing its key within AD. In other words, to help troubleshoot this issue, we needed to ensure that we could manually backup BitLocker recovery key to AD. They asked how do you do that?...
How to Backup BitLocker Recovery Key to AD
Recently, I was helping someone troubleshoot and issue with BitLocker and is storing its key within AD. In other words, to help troubleshoot this issue, we needed to ensure that we could manually backup BitLocker recovery key to AD. They asked how do you do that?...
How to Write a WQL Query
You know I always like to help those who try to help themselves. While reading Reddit post entitled SCCM Collection missing machines... the person was looking for all computers that follow a particular naming convention. Their results were not that they expected. This...
How to Write a WQL Query
You know I always like to help those who try to help themselves. While reading Reddit post entitled SCCM Collection missing machines... the person was looking for all computers that follow a particular naming convention. Their results were not that they expected. This...
Does SQL Server Database Compatibility Level Matter?
Not long ago, I was dealing with a performance problem involving a very simple SQL Server query. To give you an idea about what I mean, this query took over six hours to complete! This didn’t make any sense to me especially when its “twin” query took only 25-seconds...
Why is Using a SQL Server Alias for Column Names Important?
Here’s the error message that I kept getting, “Could not update a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct.” Within the detailed part of the error message it said, “An item with the same key has...
What Are the Four-Part Names of a SQL Server Object?
The purpose of this blog post is to help you identify the four possible parts of a SQL Server object. System Center Configuration Manager (SCCM) reports are created by querying the SCCM database. Most often SQL Server Reporting Services (SSRS) is used to display SCCM...