I remember when I first started in ConfigMgr, I wasn’t sure how to easily create ConfigMgr query collections. Being able to create the collections for yourself, your team or management needs comes in very helpful. When reading the forums and other feeds I see people ask, “how to make a query for X?” The quick […]
I recently released my latest Configuration Manager Power BI current branch dashboard with PowerON last month; The ConfigMgr devices SQL query is something I’d thought I generally share as really useful. This SQL query contains the majority of the columns you’ll need to get you going from Device OS, Chassis Types, AD site, IP addresses […]
There are some excellent Excel based ConfigMgr sizing tools out there. I recently had a design request for estimating SQL sizing via PowerShell. The function I created Returns disk capacity and file estimates for: • SQL DB’s • SQL Log’s • SQL Temp The Get-CMDBSizingEstimate function is pretty simple to use. You can pass the […]
Today I want to share a quick ConfigMgr tip. A lot of administrators I have worked with ask how to create collections based on the compliance of a Configuration Baseline. Normally I see them trying to work it out manually. If that is you, stop and don’t panic. There is an easier way straight from […]
A lot of organization are moving to Microsoft Office 365 and Windows 10. This is for many reasons such as Windows 7 end of life approaching and organizations are demanding a modern workplace for end users. As part of that Microsoft OneDrive For Business (OD4B) is a common initiative. While moving to Windows 10 you […]
I experienced an issue this week with ConfigMgr cloud management gateway not communicating with the primary site. The CMG essentially looked like it died, even though the site itself looked completely healthy. The root cause is still being investigated by Microsoft, but we managed to find a workaround without losing devices which were internet only […]
