“You cannot import this boot image. Only finalized boot images are supported” ConfigMgr 2012 R2

Problem

You get the following error when adding a boot image to SCCM 2012 R2

“You cannot import this boot image.  Only finalized boot images are supported.”

Solution

Check if you have McAfee VirusScan Enterprise installed on your SCCM server.

If yes, make sure you have these exclusions configured.  In my case, I also had to temporarily un-install McAfee VirusScan.

The Curious case of OSD via SCCM ConfigMgr causing a network outage

Recently I deployed SCCM 2012 R2 for a customer mainly for the purpose of deploying desktop operating systems over the network.

Setup

A site server with a local SQL was deployed in the customer’s datacentre with the management point and distribution point role.  A distribution point server was deployed in the customers head office to services content (images) to pc’s on the local area network.

SCCMv1

Issue

However, shortly into the testing phase of the OSD process, it was reported that network services were being disrupted on the LAN (e.g. access to LOB applications, file servers etc)…..and across the WAN!!  This was happening when deploying the image to less than 5 PC’s simultaneously.  The DP server in the head office and the PC’s being images (new PC’s) were all connected directly to the same switch.  The image was approx. 8GB in size.

There were lots of questions asked e.g.

  • How is SCCM deploying images?
  • Unicast or multicast enabled?
  • Is the content being deployed over the WAN?
  • How big is the image?

In a nutshell…What mis-configuration within SCCM is causing this issue??

I didn’t believe SCCM was causing the issue.  But how did I go about proving it?

Troubleshooting Approach

I hate getting caught up in network related issues cause I’m not a network guy.  So my approach to dealing with this was to isolate the issue and determine if indeed SCCM was the cause, or if it was simply the trigger.  So how did I do this….

  1. I deployed MDT on the distribution point server in the head office.
  2. I got the network team to set up the relevant network captures
  3. I then recreated the deployment scenario by deploying the same image via MDT as I used in SCCM to the same group of PC’s

MDTv1

Why did I do this?

  • If the same issue was occurring when deploying images via MDT, then it wasn’t a configuration issue within SCCM causing the problem.
  • Then hopefully, with the right network capture, the network team can identify what issue on the network is causing the problem

Outcome

The result of the test was that the same network outage symptoms occurred when deploying images over the network via MDT.  Therefore, it was not a configuration issue within SCCM 🙂

In terms of what is causing the issue, there are some theories emerging from the network team (misconfigured default gateways / DHCP / switches), but it’s still under investigation.  I’ll post an update when I hear back.  But for now, SCCM (and me) are in the clear! 🙂 🙂

 

Create Custom Reports in SCCM based on SQL Queries

Today I had a request from a customer to create a custom report in Configuration Manager to meet their specific requirements.  Specifically, a report that would include:

  • Computer Name
  • Domain
  • User
  • Serial Number
  • Make and Model
  • OS
  • Site Code
  • Memory
  • Hard disk size
  • CPU Speed

First I needed to find a SQL query that would fulfil the above criteria.  I used the following query from the SMSUG.CA blog found here

SELECT  distinct 

 CS.name0 as ‘Computer Name’, 
 CS.domain0 as ‘Domain’, 
 CS.UserName0 as ‘User’, 
 BIOS.SerialNumber0 as ‘Bios serial’, 
 SE.SerialNumber0 as ‘System Enclosure serial’,
 CS.Manufacturer0 as ‘Manufacturer’, 
 CS.Model0 as ‘model’, 
 OS.Caption0 as ‘OS’, 
 RAA.SMS_Assigned_Sites0 as ‘Site’, 
 RAM.TotalPhysicalMemory0 as ‘Total Memory’, 
 sum(isnull(LDisk.Size0,’0′)) as ‘Hardrive Size’, 
 sum(isnull(LDisk.FreeSpace0,’0′)) AS ‘Free Space’, 
 CPU.CurrentClockSpeed0 as ‘CPU Speed’ 
from  
  v_GS_COMPUTER_SYSTEM CS right join v_GS_PC_BIOS BIOS on BIOS.ResourceID = CS.ResourceID
 right join v_GS_SYSTEM SYS on SYS.ResourceID = CS.ResourceID  
 right join v_GS_OPERATING_SYSTEM OS on OS.ResourceID = CS.ResourceID  
 right join v_RA_System_SMSAssignedSites RAA on RAA.ResourceID = CS.ResourceID
 right join V_GS_X86_PC_MEMORY RAM on RAM.ResourceID = CS.ResourceID 
 right join v_GS_Logical_Disk LDisk on LDisk.ResourceID = CS.ResourceID 
 right join v_GS_Processor CPU on CPU.ResourceID = CS.ResourceID    
 right join v_GS_SYSTEM_ENCLOSURE SE on SE.ResourceID = CS.ResourceID 
where 
 LDisk.DriveType0 =3
group by 
 CS.Name0, 
 CS.domain0,
 CS.Username0, 
 BIOS.SerialNumber0, 
 SE.SerialNumber0,
 CS.Manufacturer0, 
 CS.Model0, 
 OS.Caption0, 
 RAA.SMS_Assigned_Sites0,
 RAM.TotalPhysicalMemory0, 
 CPU.CurrentClockSpeed0

 

Next I needed to create a custom report in Config Manager based on the above SQL query.  I followed the procedure detailed in this blog substituting the SQL query above.

 This worked a treat, creating a custom report in minutes, specific to my customers’ requirements

CustomReport