Skip to main content

How to Splat a Value with Multiple Arguments

Tonight I came upon a little different problem than usual.  Normally about this time of the night (9:00 PM in a different time zone than normal) I begin making all kinds of interesting logic errors.  Not tonight.  This evening I needed to splat a value with multiple arguments.  Yes, I know.  When I’m on these long business trips I can be absolutely boring.  I’m back home again in Indiana, and it is not the interesting part of the state.  That would be Brown County State Park.  No wilderness hiking this week. Back on topic, splatting allows you to provide a list of parameters and values to a PowerShell cmdlet in an organized way that prevents horizontal scrolling.  Best of all, no use of the back tick character. 

In this example, I am looking at splatting the Property parameter of Get-CIMInstance  here is the help file for this parameter.

PS C:\> Get-help Get-CimInstance -Parameter Property


-Property <String[]>

    Specifies a set of instance properties to retrieve.


    Use this parameter when you need to reduce the size of the object returned, either in memory or over the network.


    The object returned always has key properties populated, irrespective of the set of properties listed by the

    Property parameter. Other properties of the class are present but they are not populated.


    Required?                    false

    Position?                    named

    Default value               

    Accept pipeline input?       True (ByPropertyName)

    Accept wildcard characters?  false

We can see that this property accepts multiple values.  Take a look at –Property <String[ ]>.  Those [ ] square brackets tells us that we can provide multiple values separated by commas.  I’ve never actually tried to splat more than 1 value per parameter so this took a few attempts to get it right.  Here we go!

   $Splat = @{

        'ClassName' = 'Win32_NetworkAdapterConfiguration'

        'Property' =Description’,IPAddress’,IPSubnet’   


    Get-CimInstance @Splat


When you need to splat a parameter with multiple arguments, just make sure that each argument is encapsulated in its’ own set of quotes, then separate with a comma.  If you need to, press enter after a comma and add more arguments on the next line.  Again, a great way to avoid horizontal scrolling.

Time for bed.  I’ve got to teach Windows 8.1 in the morning.  Happy scripting!!!


Popular posts from this blog

How to force a DNS zone to replicate

For many implementations of DNS in a Windows environment, DNS is configured as being Active Directory integrated.  In other words, the DNS zone information is actually stored as a partition in the active directory database.  When Active Directory replicates, the zone data transfers.  For standard DNS deployments, the data is stored in a file.  You have to configure zone transfers manually in the DNS console.   The question in class was how to initiate replication manually.  Once you have properly configured a Primary and secondary DNS server and configured the Primary server to allow zone transfers, you can manually initiate a zone transfer.   Below you can see our test environment.  The image is of to RDP sessions to two different servers.  The DNS console on the left is the primary.  You can see and entry for Test2 that is not in the secondary database.  The servers are named NYC-DC2 (Primary DNS) and NYC-DC1 (Secondary DNS).  The DNS zone is named . On the se

Export Your Performance Monitor Data to Excel

Updated: 2016MAY04 To clarify when this functionality is available, you can only save the view when you are viewing a Data Collection Set.  The "live" data cannot be saved in this way. Performance Monitor in Windows Server give us the ability to see when our servers are having some issues.  Analyzing that data into something meaningful can be a problem.  You can export your data to Excel so you can better see what your performance data represents.  First collect your data. Right click the graph and select Save Data As . Change the Save as type to Text file (comma delimited)(*.csv) . Give the file a name and save it where you want to store it. Now open that file on a client with Excel installed on it.  By using excel, you will be able to present the data in a more meaningful format.

Determine which Domain Controller a client is connected to with PowerShell

When a Windows client comes online, it must find a domain controller to bind to.  Either through a static configuration or DHCP, the client will request a list of all Domain Controllers in the domain from a DNS server.  Once the list is received, the client will randomly go through the list to find a DC that will respond.  Once the client has authenticated itself with the DC, the DC will transmit the site information to the client.  The site information will contain the site name, the subnet(s) associated with that site, and any domain controllers in that site.  The client will then take a look at it’s own IP address to determine which site it is in.  From the list of DCs in the same site, it will attempt to bind to one of those DCs to receive it’s Group Policies.   You can use PowerShell and WMI to locate the domain controller that a client is connected to.   Get-WMIObject Win32_NTDomain   Look for the DomainControllerName property.