Coretech Configuration Manager 2012 R2 PowerShell automation module 0.1

During the TechEd Kent showed one of our solution that allows you to save all the Collections to an Excel file or to create Collections based on Excel template. We have received a lot of emails and twitter tweets that when we are going to publish it and good news is that we will publish it now 🙂 . If you haven’t seen the Kent TechEd video, then I recommend to watch it before you use this module. This is not the latest version and it is work in progress release. We will continue to improve this PowerShell module.

Here are commands. Run these commands step by step

Download link includes also the Excel template and copy the PowerShell module to your modules folder C:\Users\YOURUSERNAME\Documents\WindowsPowerShell\Modules.

Currently this module is only tested on Windows Server 2012 R2 with Configuration Manager 2012 R2 with CU´s

You can download the module from here

Download “Coretech Configuration Manager 2012 R2 PowerShell automation module” CoretechConfigMgr2012R2AutomationModule2.zip – Downloaded 445 times – 25 KB

About the Author:

Kaido Järvemets
Configuration Manager MVP

3 Comments

  1. the hoang April 30, 2015 at 8:21 - Reply

    hi,
    when I ran this command I get the error below.
    Export-CMDataTOCSV -InputObject $CollectionData -FilePath ‘C:UsersthehoangDesktopReportsViaMonstraCollections.csv’

    Cannot validate argument on parameter ‘InputObject’. The argument is null or empty. Provide an argument that is

    not null or empty, and then try the command again

  2. Thiago August 5, 2015 at 12:32 - Reply

    Hi Kaido, After run the command

    Export-CMCollectionsInformationToExcel -ReportsFolder ‘C:UsersadministratorDesktopReports’

    I am getting the following error:

    WARNING: 2015-08-05 11:00:24:
    2015-08-05 11:00:24: ————————————————–
    2015-08-05 11:00:24: — SCRIPT PROCESSING CANCELLED
    2015-08-05 11:00:24: ————————————————–
    2015-08-05 11:00:24:
    2015-08-05 11:00:24: Error in C:CTConfigMgr2012R2AutomationCTConfigMgr2012R2Automation.psm1
    2015-08-05 11:00:24:
    2015-08-05 11:00:24: ————————————————–
    2015-08-05 11:00:24: — Error Information
    2015-08-05 11:00:24: ————————————————–
    2015-08-05 11:00:24:
    2015-08-05 11:00:24: Line Number: 319
    2015-08-05 11:00:24: Offset: 9
    2015-08-05 11:00:24: Command:
    2015-08-05 11:00:24: Line: $HeaderRange = $WorkSheet.Range($UsedRange[0],$UsedRange[-1])

  3. Open-Mike February 16, 2016 at 5:55 - Reply

    Same error:
    WARNING: 2016-02-15 23:51:00:
    2016-02-15 23:51:00: ————————————————–
    2016-02-15 23:51:00: — SCRIPT PROCESSING CANCELLED
    2016-02-15 23:51:00: ————————————————–
    2016-02-15 23:51:00:
    2016-02-15 23:51:00: Error in
    2016-02-15 23:51:00:
    2016-02-15 23:51:00: ————————————————–
    2016-02-15 23:51:00: — Error Information
    2016-02-15 23:51:00: ————————————————–
    2016-02-15 23:51:00:
    2016-02-15 23:51:00: Line Number: 319
    2016-02-15 23:51:00: Offset: 9
    2016-02-15 23:51:00: Command:
    2016-02-15 23:51:00: Line: $HeaderRange = $WorkSheet.Range($UsedRange[0],$UsedRange[-1])

    2016-02-15 23:51:00: Error Details: Exception from HRESULT: 0x800A03EC
    2016-02-15 23:51:00:

Leave A Comment