About Garth Jones

How to Combine Two Views into one Query

by Garth Jones | Dec 20, 2023 | ConfigMgr, SQL Server, Tips

In this blog post, I will show you how to How to Combine Two Views into one Query. The other day, I was reading one of the various groups that I answer questions in. There was an interesting post that asked. (Edited) “I have been asked to see if there is a way to see...

How to Remove Port 80 from PBRS

by Garth Jones | Dec 13, 2023 | ConfigMgr, How-To, Reporting, SQL Server Reporting Services

This article shows you how to removed port 80 from PBRS Power BI Report Server. In this article, I will complete the process of setting up PBRS to use certificates. Note Although this blog say for PBRS it 100% applies to SQL Server Reporting Services (SSRS), therefore...

How To Configure Pbrs To Use Network Service Account

by Garth Jones | Dec 6, 2023 | ConfigMgr, How-To, SQL Server Reporting Services

When I originally wrote this topic, it was included within another blog. This made the original post long and this section buried within the blog, which made it hard to find. But over the years I have to reference this one section and as such it make sense to make it...

How to use WMI Explorer!

by Garth Jones | Oct 18, 2023 | odds and ends

As a ConfigMgr administrator understand WMI is important part of the job. ConfigMgr Hardware inventory using WMI to collect data. On top of that, ConfigMgr itself use WMI to interface with its backend and SQL server using WMI too. Using Wbemtest or WMIC or PowerShell...

Changing ConfigMgr Report Account Password, How do I do it?

by Garth Jones | Feb 1, 2023 | ConfigMgr, How-To, SQL Server, SQL Server Reporting Services

This comes of fairly often within Reddit or other forums, Changing ConfigMgr Report Account Password, How do I do it? What people do is change the account password within Active Directory (AD). Then they change the dataset password and everything works great for 10...