Category Archives: ConfigMgr

New Power BI dashboard for CM and Intune Hybrid

This is one of the nicest offerings that I have seen for a while… using PowerBI and access to the CM database. Highly recommend! Some sample screen shots:   Details on the offering, including the download link: Exploring your System … Continue reading

Posted in ConfigMgr, PowerBI, SQL Server | 1 Comment

Use PowerShell to Install Server 2012 roles and features for CM

Using PowerShell to install the Server 2012 roles and features for Configuration Manager is really super easy. Discovered an issue installing several features as the script needed access to the server 2012 source. Open PowerShell as an administrator, modify the … Continue reading

Posted in ConfigMgr, PowerShell, Server 2012 | 1 Comment

Proper TempDB creation for Configuration Manager

As a consultant, one of the major issues I see with SQL Server configuration for Configuration Manager is allowing default settings for TempDB. The default TempDB size for all versions of SQL Server (prior to SQL 2016 – more on … Continue reading

Posted in ConfigMgr, SQL Server | 6 Comments

Integrating Intune with Configuration Manager

Our first attempt at adding the Intune subscription to the Configuration Manager console. First appearance, is that it may be a security issue. Access is denied to the user when trying to enroll. In researching this issue, it turns out … Continue reading

Posted in ConfigMgr, Intune | Leave a comment

Changes in Configuration Manager Backup Strategy

Starting with Configuration Manager 1511 and later, you’ll want to include the CD.Latest folder in your files backup. https://technet.microsoft.com/en-us/library/mt605292.aspx#bkmk_Cdlatest The site maintenance task backup will include this folder as part of its backup. Now, if we could only use SQL … Continue reading

Posted in ConfigMgr, SQL Server | Tagged | 1 Comment

PXE Boot issues – BCD Error 98

Discovered an interesting WDS PXE boot issue after upgrading to CM 2012 R2 Sp1. Side Note: it appears that this issue may have occurred before the upgrade, based on forum posts, it seems to be fairly common. May not be … Continue reading

Posted in ConfigMgr | Leave a comment

Manually Installing the CM client

For a recent POC (Proof of Concept) production deployment, I needed to manually install the Configuration Client on several clients in an environment where Active Directory schema had not been extended. After working out the command line details, I thought … Continue reading

Posted in ConfigMgr | Leave a comment

Troubleshooting client install on a site server

Had some difficulties today installing the CM client on a new site server. Now, part of the issue may have been caused by AD schema extensions not yet installed. However, the client should install. Here is the error from the: … Continue reading

Posted in ConfigMgr | Leave a comment

Create Custom Report User Role for ConfigMgr 2012 R2

Most of the information you need to create the Report User role is contained in Kent’s blog: http://blog.coretech.dk/kea/creating-the-reporting-user-role-in-configmgr-2012/ To make things a little easier, from the ConfigMgr console > Administration > Security > Security Roles, right click and import the … Continue reading

Posted in ConfigMgr, SSRS | Leave a comment

Finding Maintenance Window Collections

For workstations: — List Computers with Maintenance Window SELECT col.Name AS CollectionName, sw.Name AS [MW Name], sw.Description, sw.StartTime, sw.Duration AS ‘Duration Minutes’, sw.IsEnabled AS ‘MW Enabled’, sys.Name0 AS WorkstationName, sys.Operating_System_Name_and0 AS OperatingSystem FROM dbo.v_ServiceWindow AS sw INNER JOIN dbo.v_FullCollectionMembership AS … Continue reading

Posted in ConfigMgr, SQL Server | Leave a comment