SQL Archives

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...

What Is Parsename and 4 Part Version String?

by Garth Jones | Jan 18, 2023 | How-To

In my article from last week, What Is A 4-Part Version Numbers? I showed you how Add Remove Program (ARP) versions are actually a string and not a number, like most people think it is. But how can you query the 3rd octet of a version string, if the math function don’t...

What is a 4-part version numbers?

by Garth Jones | Jan 11, 2023 | SQL Server

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...

Calculating ConfigMgr Custom Inventory Database Size

by Garth Jones | Nov 2, 2022 | How-To

The other day, a good friend of mine reached out and asked if I had an article on Calculating ConfigMgr Custom Inventory Database Size. I told him that I didn’t have an article on the subject. He told he that it would be a good topic, so here is this article. As a...

I want to Learn SQL Querying!

by Garth Jones | Oct 12, 2022 | Reporting

As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM /ConfigMgr ) administrator, you will be asked to create reports. MECM Reporting really really SQL Server Reporting Services (SSRS) reporting. In some case it is Power BI Desktop or Power BI Report...

« Older Entries