Skip to main content

How to find if a property in a custom object has a NULL NoteProperty

This was a bit of a different problem.  How to find if a property in a custom object has a NULL value.  The client had a collection of objects that they gathered from their environment with PowerShell.  They needed a way to find out if any of the NoteProperties had a NULL value.  I created the function below.  You send it the collection of objects you are interested in probing for a NULL property value and it will return the index number of the object in the collection that has one.

 

Function Find-NullProperty

{

    [cmdletbinding(HelpUri="http://get-help-jason-yoder.blogspot.com/2012/10/find-nullproperty.html")]

    Param (

        [Parameter(Mandatory=$True)]$Object

    )

    # Check to see if an object has any NULL values in

    # its properties.

 

    # Create an object to output to the calling statement.

    $Output = @()

 

    # Index number to return for to denote the instance of an object

    # (should multiple instances be sent) that the Null value if found

    # in.

    $Index = -1

 

    # Extract the names of the properties of the object.

    $PropNames = (($Object | GM) |

      Where {$_.MemberType -eq "NoteProperty"} |

      Select-Object -Property Name).Name

 

    #Cycle through each object

    ForEach ($Obj in $Object)

    {

        # Increment the Index.

        $Index++

 

        # Set to $True is a $Null value

        #is found in a property.

        $NullFound = $False

 

        ForEach ($Prop in $PropNames)

        {     

            If ($Obj.$Prop -contains $Null)

            {

                $NullFound = $True

            }    

        }

        If ($NullFound)

        {

            # Create the object to be returned.

            $Obj = New-Object -TypeName PSObject

           

            # Add object members

            $Obj | Add-Member `

                    -MemberType NoteProperty `

                    -Name "Index" `

                    -Value $Index

           

            # Send the object to the output array.

            $Output += $Obj 

        }

    }

    Write-Output $Output

<#

.SYNOPSIS

Indicates if an object has a property that is $NULL

 

.DESCRIPTION

Search through a collection of custom objects and returns the index

number of any instance that has a $NULL value in a NoteProperty

 

.PARAMETER Object

The Object, or collection of objects that may contain a NULL value

in a note property.

 

.EXAMPLE

Find-NullProperty $Object

 

 Index

 -----

     1

     2

 

Returns the index number of instance of a collection of object in which

a NoteProperty has a NULL value.

 

.NOTES

Provided without warranty or support.

Author: Jason Yoder.

#>

}

 

Comments

Popular posts from this blog

Adding a Comment to a GPO with PowerShell

As I'm writing this article, I'm also writing a customization for a PowerShell course I'm teaching next week in Phoenix.  This customization deals with Group Policy and PowerShell.  For those of you who attend my classes may already know this, but I sit their and try to ask the questions to myself that others may ask as I present the material.  I finished up my customization a few hours ago and then I realized that I did not add in how to put a comment on a GPO.  This is a feature that many Group Policy Administrators may not be aware of. This past summer I attended a presentation at TechEd on Group Policy.  One organization in the crowd had over 5,000 Group Policies.  In an environment like that, the comment section can be priceless.  I always like to write in the comment section why I created the policy so I know its purpose next week after I've completed 50 other tasks and can't remember what I did 5 minutes ago. In the Group Policy module for PowerShell V3, th

Return duplicate values from a collection with PowerShell

If you have a collection of objects and you want to remove any duplicate items, it is fairly simple. # Create a collection with duplicate values $Set1 = 1 , 1 , 2 , 2 , 3 , 4 , 5 , 6 , 7 , 1 , 2   # Remove the duplicate values. $Set1 | Select-Object -Unique 1 2 3 4 5 6 7 What if you want only the duplicate values and nothing else? # Create a collection with duplicate values $Set1 = 1 , 1 , 2 , 2 , 3 , 4 , 5 , 6 , 7 , 1 , 2   #Create a second collection with duplicate values removed. $Set2 = $Set1 | Select-Object -Unique   # Return only the duplicate values. ( Compare-Object -ReferenceObject $Set2 -DifferenceObject $Set1 ) . InputObject | Select-Object – Unique 1 2 This works with objects as well as numbers.  The first command creates a collection with 2 duplicates of both 1 and 2.   The second command creates another collection with the duplicates filtered out.  The Compare-Object cmdlet will first find items that are diffe

How to list all the AD LDS instances on a server

AD LDS allows you to provide directory services to applications that are free of the confines of Active Directory.  To list all the AD LDS instances on a server, follow this procedure: Log into the server in question Open a command prompt. Type dsdbutil and press Enter Type List Instances and press Enter . You will receive a list of the instance name, both the LDAP and SSL port numbers, the location of the database, and its status.