How to get a detailed list of all your Configuration Manager Deployments using Powershell

In this blog I will show you step by step how to quickly get a detailed list of all your Configuration Manager deployments, output in Excel table format, including the following details

  • Application Name
  • Assignment ID
  • CI_ID
  • Collection
  • Collection Name
  • DeploymentID
  • Creation Time
  • Deployment Time
  • Enforcement Deadline
  • PackageID

You can also download this guide from the Technet Gallery here

First, open the System Center Configuration Manager Console read more

Links to content, scripts and tools from MSIgnite 2015

msignite

For anyone that missed MSIgnite this year in Chicago, see below for a list of links to content, scripts and tools from the sessions:

Error 0x80070003 creating standalone task sequence media in SCCM 2012 R2

Problem

Getting the following error creating standalone Task Sequence USB media in Configuration Manager 2012 R2

Error80070003-1

CreateTsMedia.log shows the following:

Error80070003-2

 

Solution

Use DISKPART to prepare USB key for standalone media as follows:

  • Attach the USB Flash Drive to a Windows Vista/7
  • As Administrator: Open a command window and run ‘DISKPART
  • At the DISKPART> type ‘List disk’
    1. Determine which disk number corresponds to the USB flash drive (make sure you correctly make this determination!)
  • DISKPART> type ‘Selectdisk <x>‘ where <x> is the disk number that the USB flash drive corresponds to
  • DISKPART> type ‘Clean
    1. WARNING!: This will wipe all the contents from the drive you selected in step 4 so make sure that the correct drive is selected and that there is nothing on the drive that is needed.
  • DISKPART> type ‘Create Partition Primary‘.
  • DISKPART> type ‘Select Partition 1’
  • DISKPART> type ‘Format FS=FAT32 QUICK’
  • DISKPART> type ‘Active
  • DISKPART> type ‘Assign
  • DISKPART> type ‘Exit
  • read more

    “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. read more

    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. read more

    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 read more