web analytics

Blog

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

You can download the code examples from here

References:

Does Your Hard Work Advance the Ecosystem?



About the Author:

Kaido Järvemets is a developer, consultant, trainer specializing in Microsoft System Center Configuration Manager and PowerShell Solutions at Coretech. Kaido frequently speaks at European conferences and had his US debut as speaker at MMS April 2013. Kaido is well-known in the Configuration Manager communities where he’s a key player in the PowerShell game. Kaido host one of the most complete Configuration Manager PowerShell library’s in the world with hundreds of free code samples ready to download and implement – www.cm12sdk.net. Kaido has been awarded Microsoft Most Valuable Professional (MVP) in Microsoft Enterprise Client Management for his work with Configuration Manager from 2011 – to present. Kaido is the founder of System Center User Group Estonia in 2011.

Discussion

  1. Matt Hinson (MSFT)  July 16, 2013

    Hi Kaido,

    Good stuff, but there is an error in the script:

    $Arguments = @{DisplayName = $Item.’Display Name'; BoundaryType = $Type; Value = $Item.Value}

    Single quotes are missing around $Item.Value. It should read:

    $Arguments = @{DisplayName = $Item.’Display Name'; BoundaryType = $Type; Value = $Item.’Value’}

    Without fixing that, you’ll get a Generic Failure on the Set-WMIinstance line.

    (reply)
    • Kaido  July 17, 2013

      Hi,

      Thanks for the feedback. I have used that script on Windows Server 2008R2/Windows Server 2012 and with PowerShell 2 and 3 and I haven´t have any issues. You actually don´t need these single quotes. If your Property name contains spaces like ‘Display Name’, then you need these quotes. Which boundary actually fails on this list? I just retested this script on my test lab and it worked.

      Best,
      Kaido

      (reply)
      • John  September 25, 2013

        I’ve tried to run this a few times and every time I get a “Set-WmiInstance : Not Supported” Error. I’ve tried adding the quotes but the error persists, am I missing something?

        John

        (reply)
    • Ramon  February 12, 2014

      Script fails even with Matt’s suggestion, the script fails with the same error:

      Set-WmiInstance : Not supported

      (reply)
  2. Scott  March 4, 2015

    I commend the effort.. I could not get yours to work. Here is one that I used and liked very much.. http://ittherapist.net/2013/09/27/use-powershell-to-create-sccm-2012-site-boundaries/

    (reply)
  3. Nathan  August 3, 2015

    Worked perfectly for me

    Windows Server 2012 R2
    SCCM 2012 R2 CU4

    thanks Kaido

    (reply)

Leave a Reply to John
click here to cancel reply