{"id":1163,"date":"2009-02-23T00:00:46","date_gmt":"2009-02-23T08:00:46","guid":{"rendered":"http:\/\/www.sapien.com\/blog\/2009\/02\/23\/hash-table-happiness\/"},"modified":"2009-02-23T00:00:46","modified_gmt":"2009-02-23T08:00:46","slug":"hash-table-happiness","status":"publish","type":"post","link":"https:\/\/dev.sapien.com\/blog\/2009\/02\/23\/hash-table-happiness\/","title":{"rendered":"Hash Table Happiness"},"content":{"rendered":"

The other day I wrote an entry<\/a> about using the Dictionary object in VBScript . I alluded to how you could use a hash table in PowerShell. Let me show you how and I think you’ll also appreciate how much more you can do with them in PowerShell with less coding.<\/p>\n

You can create a hash table with entries by specifying a key=value pair separated by semicolons.<\/p>\n

\n
\n
#create a hash table with values<\/span><\/pre>\n
$hash=@{Name=\"Jeff Hicks\"<\/span>;Title=\"Scripting Guru\"<\/span>;<\/pre>\n
Url=\"blog.sapien.com\"<\/span>;Extension=\"x123\"<\/span>}<\/pre>\n
 <\/pre>\n
#view the contents<\/span><\/pre>\n
$hash<\/pre>\n<\/div>\n<\/div>\n
Viewing the hash produces output like this:<\/p>\n
Name                           Value
—-                           —–
Name                           Jeff Hicks
Url                            blog.sapien.com
Extension                      x123
Title                          Scripting Guru <\/font><\/font><\/p>\n
Or you can create an empty hash table.<\/p>\n
\n
\n
#create an empty hash table<\/span><\/pre>\n
$hash=@{}<\/pre>\n<\/div>\n<\/div>\n
So you can compare the two approaches I’ll use the same idea as my entry on the Dictionary object. I’ll use ADSI to get all local user accounts and store the name and password age, formatted in days, in the hash table.<\/p>\n
\n
\n
$computername=$env:computername<\/pre>\n
[ADSI]$Server=\"WinNT:\/\/$computername\"<\/span><\/pre>\n
 <\/pre>\n
$users=$server.psbase.children | where {<\/pre>\n
 $_.psbase.schemaclassname -eq<\/span> \"user\"<\/span><\/pre>\n
 }<\/pre>\n
 <\/pre>\n
#add items to the hash table<\/span><\/pre>\n
foreach<\/span> ($user in<\/span> $users) {<\/pre>\n
 $hash.Add($user.name[0],($user.passwordage[0]\/86400 -as [int]))<\/pre>\n
}<\/pre>\n<\/div>\n<\/div>\n
The Add()<\/strong> method requires that you specify the key and associated item. The Count<\/strong> property will return the number of items in the hash table.<\/p>\n
\n
\n
Write-Host (\"There are {0} users in the hash table.\"<\/span> -f $hash.count)<\/pre>\n<\/div>\n<\/div>\n
To see if a key exists, use the ContainsKey<\/strong>() method which returns True or False. By the way there is also a ContainsValue()<\/strong> method.<\/p>\n
\n
\n
#see if a key exists and if so get its value<\/span><\/pre>\n
if<\/span> ($hash.containsKey(\"administrator\"<\/span>)) {<\/pre>\n
 Write-Host (\"{0} Administrator Password age = {1} days\"<\/span> -f <\/pre>\n
 $computername,$hash.Item(\"administrator\"<\/span>))<\/pre>\n
}<\/pre>\n<\/div>\n<\/div>\n
I can get the corresponding value for the “administrator” item using the Item property. This is a VBScript-like approach. PowerShell let’s me get the values using an object.property representation. Both of these will return the associated value.<\/p>\n
\n
\n
#or access items by key<\/span><\/pre>\n
$hash.Administrator<\/pre>\n
#or like this<\/span><\/pre>\n
$hash[\"administrator\"<\/span>]<\/pre>\n<\/div>\n<\/div>\n
By now you know you can view the contents by simply typing the variable name at a PowerShell prompt. Like the Dictionary object, the hash table doesn’t have a Sort method, but no matter since PowerShell has a Sort-Object<\/strong> cmdlet.<\/p>\n
\n
\n
#view the contents sorted by key<\/span><\/pre>\n
$hash.GetEnumerator() | sort <\/pre>\n
 <\/pre>\n
#or by value<\/span><\/pre>\n
$hash.GetEnumerator() | sort value -descending<\/pre>\n<\/div>\n<\/div>\n
To remove a single item it can’t get any easier than using the Remove()<\/strong> method.<\/p>\n
\n
\n
#remove an item<\/span><\/pre>\n
if<\/span> ($hash.containskey(\"guest\"<\/span>)) {<\/pre>\n
    $hash.remove(\"guest\"<\/span>)<\/pre>\n
}<\/pre>\n<\/div>\n<\/div>\n
If you forget any of these methods or properties you can always pipe your hash table to Get-Member.<\/strong><\/p>\n
Often you will want to do something with the data in the hash table. Here’s an example using the user accounts.<\/p>\n
\n
\n
$hash.keys | foreach<\/span> {<\/pre>\n
    $lastChanged=((Get-Date).AddDays(-($hash.item($_)))).ToShortDateString()<\/pre>\n
    $obj=New-Object PSObject<\/pre>\n
    $obj | Add-Member Noteproperty \"Computer\"<\/span> $computername<\/pre>\n
    $obj | Add-Member Noteproperty \"User\"<\/span> $_<\/pre>\n
    $obj | Add-Member Noteproperty \"PasswordAge\"<\/span> $hash.item($_)<\/pre>\n
    $obj | Add-Member Noteproperty \"LastChanged\"<\/span> $lastChanged<\/pre>\n
    write $obj<\/pre>\n
} | sort PasswordAge -descending | Format-Table -Autosize<\/pre>\n<\/div>\n<\/div>\n
Like the VBScript Dictionary object, the Keys<\/strong> property returns a collection of keys. Here I’m piping them to ForEach<\/strong>. Remember that $hash.item($_) will return the corresponding value. The first line is getting the date the password was last changed by using the value as a negative number in the AddDays()<\/strong> method and then formatting it as a short date. The rest of the code creates a custom object and defines properties using data from the hash table as values. The benefit is that I can pipe this output to Sort-Object<\/strong> and Format-Table.<\/strong><\/p>\n
Computer User            PasswordAge LastChanged
——– —-            ———– ———–
CHAOS    Jeff                    185 8\/18\/2008  
CHAOS    Administrator           170 9\/2\/2008   
CHAOS    MyNewUser               134 10\/8\/2008  
CHAOS    daisy                    38 1\/12\/2009  
CHAOS    lucky                    38 1\/12\/2009  
CHAOS    __vmware_user__           2 2\/17\/2009  <\/font><\/p>\n
To remove all items from the hash table simply call the Clear()<\/strong> method.<\/p>\n
\n
\n
#remove all<\/span><\/pre>\n
$hash.Clear()<\/pre>\n<\/div>\n<\/div>\n
There are many opportunities for using hash tables in PowerShell, even more in PowerShell v2.0.  See About_Associative_Array in PowerShell v1.0 and About_Hash_Tables in PowerShell v2.0 CTP3. Don’t forget there is coverage on this topic as well in Windows PowerShell v1.0: TFM 2nd Edition<\/a><\/p>\n<\/p>\n
\n
Download a script file with all these examples here.<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
The other day I wrote an entry about using the Dictionary object in VBScript . I alluded to how you could use a hash table in PowerShell. Let me show you how and I think you’ll also appreciate how much more you can do with them in PowerShell with less coding.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[283,25],"tags":[280,67,454,453,28,57],"class_list":["post-1163","post","type-post","status-publish","format-standard","hentry","category-howto","category-windows-powershell","tag-adsi","tag-array","tag-associativearray","tag-hashtable","tag-powershell","tag-scripting"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/1163","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/comments?post=1163"}],"version-history":[{"count":0,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/1163\/revisions"}],"wp:attachment":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/media?parent=1163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/categories?post=1163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/tags?post=1163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}