Advanced Windows PowerShell Scripting Video Training

Advanced Windows PowerShell Scripting Video Training
Advanced Windows PowerShell Scripting Video Training

Wednesday, April 3, 2013

Filter an Object to Help Send Data to a Cmdlet via the Pipeline.

I took a question posted on this blog about a unique Exchange issue that an administrator was having.  They needed to take a CSV file containing names and pipe it to cmdlets for Exchange Server to take actions on.  The problem is that one of the parameters of a cmdlet would not accept the input. 

The code below is designed to take any object and get a list of its properties.  (In the Exchange Administrators case, the object was created using the Import-CSV cmdlet.) This cmdlet also took a look at the cmdlet that you intend to pipe the final data to.  It will extract the parameters of this cmdlet.  It then compares the each property of the object with the parameters of the cmdlet.  If there is a match, the property will be passed to the pipeline.  If not, it will be dropped. 

In the help file, two examples are given.  One that has a cmdlet in which all parameters accept values via the pipeline and one that does not.  To read more about passing parameters that do not accept input via the pipeline, read here.

And now for the good stuff:


Function Merge-ParameterData















        Write-Verbose "==== Cmdlet: Merge-ParameterData ===="


        Function Get-ParameterList



            Param ($Cmdlet)

                Write-Verbose "== Function: Get-ParameterList =========================="

                Write-Verbose "Parameter - `$Cmdlet: $Cmdlet"

                $List = (get-help $Cmdlet -parameter * |

                    Select-Object -Property Name |

                    ForEach -Process {$})


                Write-Verbose "Sending $($List.count) Items to the pipeline."

                Write-Output $List

                Write-Verbose "__ End Function: Get-ParameterList ____________________"



            Extracts cmdlet parameters



            Extracts the parameters from a supplied cmdelt and sends then as a collection

            into the PowerShell Pipeline.


            .PARAMETER Cmdlet

            The name of the cmdlet whose parameters you want to extract.



            Get-ParameterList Set-MailContact


            Sends a collection of strings containing the names of all of the parameters

            avaliabe to the cmdlet Set-MailContact.


        } # End: Function - Get-ParameterList =========================================



        Function Merge-Objects



        Param ($ParamList,$Data)

            Write-Verbose "== Function: Merge-Objects =="


            # Create a new object to hold the data.

            $OutputObj = New-Object -TypeName PSObject


            # Cycle through the data to find properties that

            # match.  If matching properties are found, add them to the

            # $OutputObject.


            ForEach ($Item in $ParamList)


               If ($Data.($Item) -ne $Null)


                $OutputObj | Add-Member -MemberType NoteProperty `

                    -Name $Item -Value $Data.($Item)




            Write-Output $OutputObj

        } # End: Function - Merge-Objects =========================================


    } # End: Begin Block ----------------------------------------------------------




        Write-Verbose "Process Block Started"

        Write-Verbose "Getting list of parameters from $($Cmdlet)"   


        # Get a list of parameters from the supplied cmdlet.

        $ParamList = Get-ParameterList -Cmdlet $Cmdlet


        # Write the object to the pipeline.

        Write-Output (Merge-Objects -ParamList $ParamList -Data $Data)


    } # End: Process Block ----------------------





        Write-Verbose "-------------------------------------------------------"

        Write-Verbose "-- Cmdlet: Merge-ParameterData Completed             --"

        Write-Verbose "-- Copyright 2013 MCTExpert, Inc.                    --"

        Write-Verbose "-- All Rights Reserved                               --"

        Write-Verbose "-------------------------------------------------------"              





Compares the properties of an object with the parameters of a cmdlet.



Takes an object and examines the properties of the object and the parameters

of a cmdlet.  It then produces an object in the pipeline of any properties

from the object that match a parameter of the cmdlet.  Any properties from the

object that do not have a matching parameter in the cmdlet will be dropped.



== Cmdlet: Merge-ParamarterData                                              ==

== Version 1.0                                                               ==


== Author: Jason A. Yoder                                                    ==

== Company: MCTExpert, Inc.                                                  ==

== Blog:                                              ==

== Twitter: @JasonYoder_MCT                                                  ==


== License Information:                                                      ==

== Copyright 2013 - MCTExpert, Inc.                                          ==

== This code is licensed for personal use only.  This code may not be        ==

== re published or distributed in whole or in part without the express       ==

== written consent of MCTExpert, Inc.  All rights reserved.                  ==


== Disclaimer: The user takes full responsibility for the execution of any   ==

== PowerShell code.  This code is provided without warranty or support.      ==

== As with all PowerShell code, review it and test it in a test environment  ==

== prior to using it in a production environment.  The user takes complete   ==

== responsibility for the results of executing this code.                    ==




The object that you want to example to send to the cmdlet.



The cmdlet that you want to send the object to.



IMPORT-CSV "C:\Process.csv" |

Merge-ParameterData -Cmdlet Get-Process|



Handles  NPM(K)    PM(K)      WS(K) VM(M)   CPU(s)     Id ProcessName                                                                                      

-------  ------    -----      ----- -----   ------     -- -----------                                                                                      

    398      30    10664      11580   156    44.98   3472 ANT Agent                                                                                        

     76      18     6560       7052    84     0.64   7024 calc                                                                                             

   1157      70    64452      94348   399    27.28   7504 explorer


Takes a CSV file and compares the property names of the imported objects

to the parameter list of Get-Process.  It them pipes the results to




Import-Csv C:\PS\Contacts.csv | Mearger-ParameterData -Cmdlet New-MailContact |

ForEach -Process {New-MailContact -Name $_.Name -DisplayName $_.DisplayName `

 -ExternalEmailAddress $_.ExternalEmailAddress}


Creates mail contacts from a CSV file. The New-MailContact cmdlet

does not accept input from the pipeline on the Name or the ExternalEmailAddress

Parameters.  This example shows you how to get around this issue.



} # End: Cmdlet: Merge-ParameterData




No comments: