ConfigMgr Archives

Why are Collections Not Updating on the CAS?!

by Garth Jones | Feb 15, 2017 | ConfigMgr, Tips

While I was working on my new lab, I noticed that collections were not refreshing. But why Collections Not Updating on the CAS? So I dug deep into the server and noticed that the link state of Database Replication was Link Degraded. I ran the Replication Link...

How to Setup Report Caching for a SSRS Report

by Garth Jones | Jan 26, 2017 | ConfigMgr, How-To, SQL Server Reporting Services, Tips

Some of the reporting questions that I get asked have to do with the burden reporting puts on servers and how this can be reduced or controlled. In general, the burden for most reports and organizations is minimal as reporting is generally an underused feature....

Avoid Installing WID and SQL on the Same Server

by Garth Jones | Jan 12, 2017 | ConfigMgr, How-To, Tips

Recently I built a new test lab. As an aside, in my opinion, this is one of the most complicated labs that you could have, but I’ll write more about that at a later date. While building this lab, I needed to setup WSUS on my new CAS server. This post tells you about...

I Want My Reports In Full Screen!

by Garth Jones | Dec 19, 2016 | ConfigMgr, How-To, Tips

I work with a lot of clients to help them create ConfigMgr dashboard reports. As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM / ConfigMgr ) Administrator, you will at some point want to create a Dashboard! ConfigMgr Reporting is really SQL Server...

Does Your OS Architecture (x86 or x64) Matter within a Query?

by Garth Jones | Dec 6, 2016 | ConfigMgr, Tips

When ConfigMgr administrators are creating a collection query to find all computers with a particular application for both x86 and x64 computers, almost everyone falls into the same mistake. That mistake is querying for both x86 and x64 software titles using an Inner...

Why is SQL Server Indexing Important?

by Garth Jones | Nov 16, 2016 | ConfigMgr, Tips

This is one of those questions where the answer should seem obvious to everyone. But it is surprising how many ConfigMgr environments don’t have SQL Server indexing enabled nor the ConfigMgr Rebuild Indexes task in use. Let’s start by defining SQL Server indexing. In...