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

SCCMDeployments1

Click on the down arrow in the upper right hand corner and choose “Connect via Windows Powershell”.  This opens PowerShell with the Configuration Manager module loaded.  Type the following command (use whatever path you want to save the output)

Get-CMDeployment | Export-csv -NoTypeInformation c:\temp\Deployments.CSV

SCCMDeployments13

 

Next, open the Deployments.CSV file using Microsoft Excel.

Highlight / select all the rows and columns with data, select the “Insert” Tab, click on “Table”

SCCMDeployments16

Make sure to tick “My table has headers”, the click OK

SCCMDeployments11

You now have an excel spreadsheet, in table format, with detailed information about all your deployments including

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

SCCMDeployments12

 

8 thoughts on “How to get a detailed list of all your Configuration Manager Deployments using Powershell

  1. Changing to the following command will eliminate most steps required to get this in a usable format

    Get-CMDeployment | Export-csv -NoTypeInformation c:\temp\Deployments.csv

    You can also pull this information from the [DeploymentSummary] table and just setup a native SQL connector via Excel to refresh as desired and it would refresh almost instantly on demand.

    • Thanks again for the feedback Erichholzhueter. With your “-NoTypeInformation” tip I was able to reduce the number of Excel steps. I’ve updated my blog accordingly. I had a look at pulling the data from the [DeploymentSummary] table using using a SQL query. While it is useful, it lacks some key information that I get when using powershell, in particular Application Name, Collection Name, Enforcement Deadline.

  2. This will launch the file in excel if excel is installed on the system AND if the file has not already been opened.
    #——— This is one line
    Get-CMDeployment | Export-csv -NoTypeInformation c:\temp\Deployments.csv ; c:\temp\Deployments.csv

  3. Unfortunately the AssignedSchedule.Starttime property is not retrieved by this cmdlet. Knowing when the assigned time the program package is set to launch would be helpful.

  4. thank you !! i needed a report where i can get all application deployment status with device collection name. its worked for me.

Leave a Reply

Your email address will not be published. Required fields are marked *