{"id":3311,"date":"2009-12-04T20:30:25","date_gmt":"2009-12-04T20:30:25","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/powershell\/2009\/12\/04\/new-object-psobject-property-hashtable\/"},"modified":"2019-02-18T13:06:04","modified_gmt":"2019-02-18T20:06:04","slug":"new-object-psobject-property-hashtable","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/powershell\/new-object-psobject-property-hashtable\/","title":{"rendered":"New-Object PSObject –Property [HashTable]"},"content":{"rendered":"
Let me start of by suggesting you take a few minutes and read Laerte Junior\u2019s excellent blog 
entry Exceptional PowerShell DBA Pt1 Orphaned Users<\/a>.  Laerte does a great job describing the 
scenario, the approach he took to solving it and then he included the scripts!  Really good
stuff Laerte! <\/pre>\n
When I looked at Laerte\u2019s code, I recognized one of my least favorite PowerShell V1isms:<\/pre>\n
\t\t$Object<\/span> =<\/span> New-Object<\/span> PSObject<\/span>\n               $Object<\/span> |<\/span> add-member<\/span> Noteproperty<\/span> LineNumber<\/span>       $LineNumber<\/span>\n               $Object<\/span> |<\/span> add-member<\/span> Noteproperty<\/span> Date<\/span>             $TodayDate<\/span>\n               $Object<\/span> |<\/span> add-member<\/span> Noteproperty<\/span> ServerName<\/span>       $svr<\/span>\n               $Object<\/span> |<\/span> add-member<\/span> Noteproperty<\/span> DatabaseName<\/span>     $Database<\/span>\n               $Object<\/span> |<\/span> add-member<\/span> Noteproperty<\/span> UserName<\/span>         $user<\/span>.<\/span>name<\/span>\n               $Object<\/span> |<\/span> add-member<\/span> Noteproperty<\/span> CreateDate<\/span>       $CreateDate<\/span>\n               $Object<\/span> |<\/span> add-member<\/span> Noteproperty<\/span> DateLastModified<\/span> $DateLastModified<\/span>\n               $Object<\/span> |<\/span> add-member<\/span> Noteproperty<\/span> AsymMetricKey<\/span>    $user<\/span>.<\/span>AsymMetricKey<\/span>\n               $Object<\/span> |<\/span> add-member<\/span> Noteproperty<\/span> DefaultSchema<\/span>    $user<\/span>.<\/span>DefaultSchema<\/span>\n               $Object<\/span> |<\/span> add-member<\/span> Noteproperty<\/span> HasDBAccess<\/span>      $user<\/span>.<\/span>HasDBAccess<\/span>\n               $Object<\/span> |<\/span> add-member<\/span> Noteproperty<\/span> ID<\/span>               $user<\/span>.<\/span>ID<\/span>\n               $Object<\/span> |<\/span> add-member<\/span> Noteproperty<\/span> LoginType<\/span>        $user<\/span>.<\/span>LoginType<\/span>\n               $Object<\/span> |<\/span> add-member<\/span> Noteproperty<\/span> Login<\/span>            $user<\/span>.<\/span>Login<\/span>\n               $Object<\/span> |<\/span> add-member<\/span> Noteproperty<\/span> Orphan<\/span>           (<\/span>$user<\/span>.<\/span>Login<\/span> -eq<\/span> ""<\/span>)<\/span>\n                                <\/pre>\n
Gosh that is a horrible looking thing.  This is one of the things we fixed with PowerShell V2 so you take a few minutes to\n  
learn this so you never have to do that mess again.  Let\u2019s get some help:\n  <\/p>\n
PS> Get-Help New-Object -Parameter Property<\/strong> <\/font><\/p>\n
-Property <hashtable>\n    
    Sets property values and invokes methods of the new object.\n    
    Enter a hash table in which the keys are the names of properties or methods and the values are property value\n    
    s or method arguments. New-Object creates the object and sets each property value and invokes each method in\n    
    the order that they appear in the hash table.\n    
    If the new object is derived from the PSObject class, and you specify a property that does not exist on the o\n    
    bject, New-Object adds the specified property to the object as a NoteProperty. If the object is not a PSObjec\n    
    t, the command generates a non-terminating error.\n    
    Required?                    false\n    
    Position?                    named\n    
    Default value                
    Accept pipeline input?       false\n    
    Accept wildcard characters?  false<\/font> <\/p>\n
  <\/p>\n
Thats right \u2013 you can now specify a hashtable and we\u2019ll set these as NoteProperties on an object.  What that means is that you can now write code like this: <\/p>\n
\n
    $Object<\/span> =<\/span> New-Object<\/span> PSObject<\/span> -Property<\/span> @{<\/span>\n        LineNumber<\/span>       =<\/span> $LineNumber<\/span>\n        Date<\/span>             =<\/span> $TodayDate<\/span>\n        ServerName<\/span>       =<\/span> $svr<\/span>\n        DatabaseName<\/span>     =<\/span> $Database<\/span>\n        UserName<\/span>         =<\/span> $user<\/span>.<\/span>name<\/span>\n        CreateDate<\/span>       =<\/span> $CreateDate<\/span>\n        DateLastModified<\/span> =<\/span> $DateLastModified<\/span>\n        AsymMetricKey<\/span>    =<\/span> $user<\/span>.<\/span>AsymMetricKey<\/span>\n        DefaultSchema<\/span>    =<\/span> $user<\/span>.<\/span>DefaultSchema<\/span>\n        HasDBAccess<\/span>      =<\/span> $user<\/span>.<\/span>HasDBAccess<\/span>\n        ID<\/span>               =<\/span> $user<\/span>.<\/span>ID<\/span>\n        LoginType<\/span>        =<\/span> $user<\/span>.<\/span>LoginType<\/span>\n        Login<\/span>            =<\/span> $user<\/span>.<\/span>Login<\/span>\n        Orphan<\/span>           =<\/span> (<\/span>$user<\/span>.<\/span>Login<\/span> -eq<\/span> ""<\/span>)<\/span>\n    }<\/span>\n                                    <\/pre>\n<\/blockquote>\n
or if you prefer:<\/p>\n
\n
   $hash<\/span> =<\/span> @{<\/span>\n        LineNumber<\/span>       =<\/span> $LineNumber<\/span>\n        Date<\/span>             =<\/span> $TodayDate<\/span>\n        ServerName<\/span>       =<\/span> $svr<\/span>\n        DatabaseName<\/span>     =<\/span> $Database<\/span>\n        UserName<\/span>         =<\/span> $user<\/span>.<\/span>name<\/span>\n        CreateDate<\/span>       =<\/span> $CreateDate<\/span>\n        DateLastModified<\/span> =<\/span> $DateLastModified<\/span>\n        AsymMetricKey<\/span>    =<\/span> $user<\/span>.<\/span>AsymMetricKey<\/span>\n        DefaultSchema<\/span>    =<\/span> $user<\/span>.<\/span>DefaultSchema<\/span>\n        HasDBAccess<\/span>      =<\/span> $user<\/span>.<\/span>HasDBAccess<\/span>\n        ID<\/span>               =<\/span> $user<\/span>.<\/span>ID<\/span>\n        LoginType<\/span>        =<\/span> $user<\/span>.<\/span>LoginType<\/span>\n        Login<\/span>            =<\/span> $user<\/span>.<\/span>Login<\/span>\n        Orphan<\/span>           =<\/span> (<\/span>$user<\/span>.<\/span>Login<\/span> -eq<\/span> ""<\/span>)<\/span>\n    }<\/span>\n    $Object<\/span> =<\/span> New-Object<\/span> PSObject<\/span> -Property<\/span> $hash<\/span>            <\/pre>\n<\/blockquote>\n
 <\/p>\n
This is SO much better than V1 \u2013 be sure to use it and to tell all your friends about it as well!  <\/p>\n
Experiment!  Enjoy!  Engage! <\/p>\n
Jeffrey Snover [MSFT]\n  
Distinguished Engineer\n  
Visit the Windows PowerShell Team blog at:    http:\/\/blogs.msdn.com\/PowerShell<\/a>\n  
Visit the Windows PowerShell ScriptCenter at:  http:\/\/www.microsoft.com\/technet\/scriptcenter\/hubs\/msh.mspx<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Let me start of by suggesting you take a few minutes and read Laerte Junior\u2019s excellent blog entry Exceptional PowerShell DBA Pt1 Orphaned Users. Laerte does a great job describing the scenario, the approach he took to solving it and then he included the scripts! Really goodstuff Laerte! When I looked at Laerte\u2019s code, I […]<\/p>\n","protected":false},"author":600,"featured_media":13641,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3311","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powershell"],"acf":[],"blog_post_summary":"
Let me start of by suggesting you take a few minutes and read Laerte Junior\u2019s excellent blog entry Exceptional PowerShell DBA Pt1 Orphaned Users. Laerte does a great job describing the scenario, the approach he took to solving it and then he included the scripts! Really goodstuff Laerte! When I looked at Laerte\u2019s code, I […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/posts\/3311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/users\/600"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/comments?post=3311"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/posts\/3311\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/media\/13641"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/media?parent=3311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/categories?post=3311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/tags?post=3311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}