web analytics

Posts Tagged 'Excel'

Configuration Manager 2012 SP1 CU1 PowerShell Parameter Sets Excel sheet

Posted by:

I just updated the SP1 RTM version of Configuration Manager 2012 SP1 RTM PowerShell Parameter Sets Excel sheet and with SP1 CU1 we have 511 CMDLETS and 1675 parametersets :)

 ConfigMgr_SP1_CU1_ExcelSheet

You can download this Excel sheet from here

Continue Reading →

How to create boundaries using Excel file

Posted by:

To create boundaries using Excel file

  1. Create a new Excel Workbook (.XLSX)
  2. Add the necessary information
  3. Create an instance of the SMS_Boundary WMI class

Sample Input file

Examples

How to export Configuration Manager boundaries to Excel

Posted by:

To export Configuration Manager boundaries to Excel

  1. Create a new Excel Workbook using “Excel.Application” com object
  2. Query SMS_Boundary WMI Class

Example