Category Archives: SCCM 2012

SCCM Report – Count All Computers by Model

How to create a MS Configuration manager report that will Count All Computers for each Model

This guide will show you how to create a report in Microsoft System Center Configuration Manager 2012(R2) / Current branch 1702. In this example we will be creating a report which lists all system models and displays a count of each model.

SCCM 2012 (last checked on build 1702) does not have a prebuilt report that will simply return a list of all the distinct manufacturer/model numbers for all the computers in the environment and a count of each type.

This SCCM report will retrieve all the computer models  in one column and count of each model in the the adjacent column:

SELECT        Model0 AS Model, COUNT(*) AS Count, Domain0

FROM            dbo.v_GS_COMPUTER_SYSTEM

GROUP BY Model0, Domain0

Output of the report:

sccm report Count Computer by Model

If you happen to have Lenovo models in your organisation, you will find it useful to translate the Lenovo’s models to real model names. The following query will do that:

SELECT COUNT(*) No_Of_Items, 

CASE WHEN MODEL0 IN('10AXS2PX00') THEN 'Lenovo M73'

WHEN MODEL0 IN('10ahs00d00') THEN 'Lenovo M83'

WHEN MODEL0 IN('10FCS06W00','10FCS0W500','10FHS00D00','10FHS07Q00','10FHS0AK00') THEN 'Lenovo M900'

WHEN MODEL0 IN('10MKS03H00','10MKS04G00','10MKS04H00') THEN 'Lenovo M910s '

WHEN MODEL0 IN('10A7A00P00','10A7S00P00','10A7A00L00','10A7CTO','10A7S00D00',

'10A7S00S00','10A7S02700','10A7S02800','10A7S02D00','10A8A02H0C',

'10A8S2E100','10A9003PIV','10A9S02X00') THEN 'Lenovo M93p'

WHEN MODEL0 IN('SLIC-BPC') THEN 'HP Compaq Elite 8300 BPC'

WHEN MODEL0 = 'To be filled by O.E.M.' THEN 'WeyTech'

ELSE Model0 END [Model]

FROM v_GS_COMPUTER_SYSTEM


WHERE model0 like '%hp%' or model0 like '%think%' or model0 like '%10%' or model0 like '%O.E.M%' or model0 like '%SLIC-BPC%'

GROUP BY CASE WHEN MODEL0 IN('10AXS2PX00') THEN 'Lenovo M73'

WHEN MODEL0 IN('10ahs00d00') THEN 'Lenovo M83'

WHEN MODEL0 IN('10FCS06W00','10FCS0W500','10FHS00D00','10FHS07Q00','10FHS0AK00') THEN 'Lenovo M900'

WHEN MODEL0 IN('10MKS03H00','10MKS04G00','10MKS04H00') THEN 'Lenovo M910s '

WHEN MODEL0 IN('10A7A00P00','10A7S00P00','10A7A00L00', '10A7CTO','10A7S00D00',

'10A7S00S00','10A7S02700','10A7S02800',  '10A7S02D00','10A8A02H0C',

'10A8S2E100','10A9003PIV','10A9S02X00') THEN 'Lenovo M93p'

WHEN MODEL0 IN('SLIC-BPC') THEN 'HP Compaq Elite 8300 BPC'

WHEN MODEL0 = 'To be filled by O.E.M.' THEN 'WeyTech'

ELSE Model0 END


ORDER BY No_Of_Items DESC, model

 Download the .rdl file for this report from here: All Computers in specific Collection

Windows update fails with Error 0x80072efd

Windows update is one of the more important features of SCCM. Keeping all servers and workstations in your environment up to date is most important.

I met the following error while SCCM 2012 was trying to update one of my servers.

The problem

You try to push Windows security updates to a remote machine, but Windows update fails.

Continue reading Windows update fails with Error 0x80072efd

Create SCCM Distribution Point with Powershell

Hi Sysadmins

You need to create multiple SCCM 2012 Distribution points fast and accurate!

Maybe you decided on upgrading your  environment to SCCM 2012 or your company purchased another organisation. In any case,

The reasonable way will be to use a script, and not use the GUI to do the task over and over.

The preferred scripting environment is Powershell, since it already has many Configuration Manager commandlets that can be helpful.

You do have to work with at least SCCM 2012 sp1 version for the following script to work.

The below Powershell script will read the names of the Distribution points servers from a file. See example for the file Here 

Continue reading Create SCCM Distribution Point with Powershell

SCCM 2012 clients’ log files not created

Hi SysAdmins

In this post I am writing about a minor problem that occurs while installing a SCCM 2012 client, and how to solve it.

The Problem

You install a SCCM client on a machine.

After the installation finishes, you notice that not all logs are populated in the clients’ machine C:\windows\CCM\Logs directory.

If you check ClientIDManagerStartup.log  file, you notice the following error message:

RegTask: Failed to get certificate. Error: 0x80004005

Continue reading SCCM 2012 clients’ log files not created

How to install IIS features on SCCM 2012 Distribution Point with command line

Hi SysAdmins

Did you ever wonder how SCCM 2012 install a DP remotely from the CM console?

DISM.exe (Deployment Image Servicing and Management tool) is a command line tool that you can use to enable or disable Windows features.

In this case we use it to install all the necessary IIS features for a SCCM 2012 DP.

Command line to install IIS on DPs:

Continue reading How to install IIS features on SCCM 2012 Distribution Point with command line

The case of the nonresponsive SCCM 2012 Management Point

Hi SysAdmins

In this post I am writing about a strange case that happened in my SCCM 2012 sp1 environment. I’m not sure if its related, but it all happened after installing CU3.

The case was resolved after an intervention of Microsoft Senior Support Engineer. Maybe this will help someone since there is no solution for this on the web.

It all began when my SCCM environment just stopped working…

The Problem:

1. All Packages deployment tasks are grayed out, and stuck on Unknown status.

2. You cannot distribute Microsoft security updates to clients.

3. Might be this as well – in smsts.log you see this error: Task Sequence fails with error: There is no task sequences available to this computer.

4. Check your Management Point server under <install Drive>\Program files\SMS_CCM\Logs\MP_Policy.log for the following lines:

Continue reading The case of the nonresponsive SCCM 2012 Management Point

SCCM 2012 Client installation fails with error code 8004100E

Hi SysAdmins

In this post I want to show a solution for a  SCCM 2012 sp1 client installation problem which I met over my daily routine work.

The Problem:

You try to Install a SCCM client on a remote XP-sp3 machine, and the installation fails. In ccmsetup.log  you see the following:

Continue reading SCCM 2012 Client installation fails with error code 8004100E

Error 0x800706BA when trying to install new Distribution Point in SCCM 2012 sp1

Hi SysAdmins

I just thought to share with you something I recently was troubleshooting.

Maybe you met this as well,

This occurred  in SCCM 2012 sp1 CU1.

The problem:

You are trying to install a new DP, and the installation fails.

Also, the Distribution point configuration status under Monitoring shows red X with an error saying …cannot connect to remote DP.

When you check Distmgr.log you see the following lines:

Error:

CWmi::Connect() failed to connect to \\<<DPNAME>>\root\SCCMDP. Error = 0x800706BA

Continue reading Error 0x800706BA when trying to install new Distribution Point in SCCM 2012 sp1

Packages content status stuck on “in Progress” in SCCM 2012

Hi Sysadmins

Recently I noticed that my SCCM 2012 sp1 CU1 stopped distributing content to remote DPs.

Troubleshooting this problem has been a pain so I thought I’d share this with you.

This apply to : SCCM 2012 / SCCM 2012 sp1 / SCCM 2012 sp1 CU1

The Problem:

  1. Distribution points doesn’t get the content you distribute to them from the primary server.
  2. When you look at a package deployment status you see the package status stuck on ‘in progress’:

Continue reading Packages content status stuck on “in Progress” in SCCM 2012

Create SCCM 2012 boundaries and boundary groups

Hi SysAdmins

If you are managing your enterprises’ servers and workstations with SCCM 2012 (as you should do) ,

you probably will need to build boundaries, boundary groups and add these boundaries to boundary groups.

This will make sure that the site server DP that you join with a specific boundary group will distribute content only to workstations in its associated boundaries.

This was known as protected boundary in SCCM 2007.

If you need to create SCCM 2012 boundaries and boundary groups automatically without repeating the process over and over,

The following Powershell script will receive a list of data from a .CSV file and create boundaries and boundary groups respectively.

Continue reading Create SCCM 2012 boundaries and boundary groups