{"id":957,"date":"2020-03-23T11:07:52","date_gmt":"2020-03-23T10:07:52","guid":{"rendered":"http:\/\/www.vatland.no\/?p=957"},"modified":"2020-03-23T11:07:52","modified_gmt":"2020-03-23T10:07:52","slug":"hash-tables-in-powershell","status":"publish","type":"post","link":"https:\/\/www.vatland.no\/index.php\/hash-tables-in-powershell\/","title":{"rendered":"Hash tables in powershell"},"content":{"rendered":"

We all have the need to store data in some kind of arrays. I use hashtables a lot. Preferred use is as a lookup table, I can use ‘contains’ instead of looping through each item or reference an object by name instead of index number. Lookup table for licenses is where I use it the most at the time being. A table of license ID versus license name. One place for this is Microsoft licenses in partnercenter, and show licenses assigned to users. Using powershell to connect to Microsoft partnercenter to get all available skus by ID , name and displayname. When I have collected this – how do you ask?.
\nHere you go:<\/p>\n

 Import-<\/span>module partnercenter
\n Connect-<\/span>CompanyPartnerCenter
\n 
\n    $lic<\/span> =<\/span> @<\/span>{<\/span> }<\/span>
\n    $prodid<\/span> =<\/span> @<\/span>{<\/span> }<\/span>
\n    $customerstenants<\/span> =<\/span> Get-<\/span>PartnerCustomer
\n    ForEach<\/span> (<\/span>$customer<\/span> in<\/span> $customerstenants<\/span>)<\/span> {<\/span>
\n        $message<\/span> =<\/span> "Customer :$($customer.name)"<\/span>
\n        write-verbose<\/span> -Message<\/span> "$message"<\/span>
\n        $custskus<\/span> =<\/span> Get-<\/span>PartnerCustomerSubscribedSku -<\/span>CustomerId $customer<\/span>.customerid
\n        foreach<\/span> (<\/span>$custsku<\/span> in<\/span> $custskus<\/span>)<\/span> {<\/span>
\n            if<\/span> (<\/span>$lic<\/span>.ContainsKey(<\/span>$custsku<\/span>.SkuPartNumber)<\/span>)<\/span> {<\/span>
\n               
\n            }<\/span>
\n            else<\/span> {<\/span>
\n                $lic<\/span>.Add(<\/span>$custsku<\/span>.skupartnumber,<\/span> $custsku<\/span>.productname)<\/span>
\n                $prodid<\/span>.Add(<\/span>$custsku<\/span>.SkuId,<\/span> $custsku<\/span>.ProductName)<\/span>
\n            }<\/span>
\n
\n        }<\/span>  
\n }<\/span><\/div><\/div>\n

Connect-companypartnercenter is a custom function. Here is how to connect to Office partnercenter.<\/a>
\nThe script above will (hopefully , no try-catch) end up in 2 hash tables. One “skuid” and productname:<\/p>\n

"SkuID","DisplayName"
\n"WACONEDRIVEENTERPRISE","OneDrive for Business (Plan 2)"
\n"O365_BUSINESS_ESSENTIALS","Office 365 Business Essentials"
\n"MCOSTANDARD","Skype for Business Online (Plan 2)"
\n"Win10_E3_Local","Windows 10 Enterprise E3 (local only)"
\n"WACONEDRIVESTANDARD","OneDrive for Business (Plan 1)"<\/div><\/div>\n

As long as I’m using this in the same script it is ok. Exporting it to files is not that straight forward, even tried ‘convertto-json’ –not working (convertfrom-json returns an array)
\nSo I do this to crate a csv file. Creating correct columns.<\/p>\n

       $csvobject<\/span> =<\/span> (<\/span>$lic<\/span>.GetEnumerator(<\/span>)<\/span> |<\/span> Select-Object<\/span> @<\/span>{<\/span>expression =<\/span> {<\/span> $_<\/span><\/a>.name }<\/span>; label =<\/span> "SkuID"<\/span> }<\/span>,<\/span> @<\/span>{<\/span>expression =<\/span> {<\/span> $_<\/span><\/a>.value }<\/span>; label =<\/span> "DisplayName"<\/span> }<\/span> |<\/span> convertto-<\/span>csv -Delimiter<\/span> ','<\/span> -NoTypeInformation<\/span> )<\/span>
\n        $csvobject<\/span> |<\/span> Out-File<\/span><\/span> -Encoding<\/span> unicode $ExportSkuIDFile<\/span>
\n
\n        $csvobject<\/span> =<\/span> (<\/span>$prodid<\/span>.GetEnumerator(<\/span>)<\/span> |<\/span> Select-Object<\/span> @<\/span>{<\/span>expression =<\/span> {<\/span> $_<\/span><\/a>.name }<\/span>; label =<\/span> "ProductID"<\/span> }<\/span>,<\/span> @<\/span>{<\/span>expression =<\/span> {<\/span> $_<\/span><\/a>.value }<\/span>; label =<\/span> "DisplayName"<\/span> }<\/span> |<\/span> convertto-<\/span>csv -Delimiter<\/span> ','<\/span> -NoTypeInformation<\/span> )<\/span>
\n        $csvobject<\/span> |<\/span> Out-File<\/span><\/span> -Encoding<\/span> unicode $ExportProductIDFile<\/div><\/div>\n

Now that we have the file it would be great to be able to use them \ud83d\ude42
\nAnd this is how it is imported in to a hashtable.<\/p>\n

$filecontent<\/span>=<\/span>import-csv<\/span> -Path<\/span> $importfile<\/span> -Encoding<\/span> Unicode -<\/span>Header "column1"<\/span>,<\/span>"column2"<\/span>
\n$hashtable<\/span>=@<\/span>{<\/span>}<\/span>
\n$filecontent<\/span>|<\/span>ForEach-Object<\/span>{<\/span>
\n    write-verbose<\/span> -message<\/span> "$_.column1 , $_.column2"<\/span>
\n    $hashtable<\/span>.add(<\/span>$_<\/span><\/a>.column1,<\/span>$_<\/span><\/a>.column2)<\/span>
\n}<\/span><\/div><\/div>\n

Read the file line by line and build our hash-table. Now we can use : $hashtable[“MCOSTANDARD”] , this will return the full name ‘Skype for Business Online (Plan 2)’
\nI have this as functions in my default module, the module I import in all my powershell sessions. (Surely you know about powershell profiles?)
\nHope this helped.<\/p>\n","protected":false},"excerpt":{"rendered":"

We all have the need to store data in some kind of arrays. I use hashtables a lot. Preferred use is as a lookup table, I can use ‘contains’ instead of looping through each item or reference an object by name instead of index number. Lookup table for licenses is where I use it the … Continue reading Hash tables in powershell<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"Hash tables in powershell","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[74,48],"tags":[65,96,95,59],"class_list":["post-957","post","type-post","status-publish","format-standard","hentry","category-csp","category-powershell","tag-csp","tag-csv-files","tag-hashtables","tag-powershell"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"jetpack-related-posts":[{"id":899,"url":"https:\/\/www.vatland.no\/index.php\/csp-access-to-tenants-using-powershell-part-2\/","url_meta":{"origin":957,"position":0},"title":"CSP access to tenants using powershell. Part 2","author":"Atle","date":"September 20, 2019","format":false,"excerpt":"In part 1 we created the Azure Enterprise App for Partnercenter and used this information to connect using powershell and connect-partnercenter. Now we will use this to connect to one of our customers tenants. First we will use AZ module and connect-azaccount. We will use the AZ module and the\u2026","rel":"","context":"In "Azure"","block_context":{"text":"Azure","link":"https:\/\/www.vatland.no\/index.php\/category\/azure\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":875,"url":"https:\/\/www.vatland.no\/index.php\/csp-access-to-tenants-using-powershell-part-1\/","url_meta":{"origin":957,"position":1},"title":"CSP access to tenants using powershell. Part 1","author":"Atle","date":"September 18, 2019","format":false,"excerpt":"A short explanation of how to access customer tenant using a CSP tenant SPN credential connectiong to AzureAD and AZ. Have been struggling for a while to manage all our customers tenants using powershell scripts. It can be complicated to organize all the credentials, tenant domain, tenant id's password expiry.\u2026","rel":"","context":"In "Azure"","block_context":{"text":"Azure","link":"https:\/\/www.vatland.no\/index.php\/category\/azure\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":914,"url":"https:\/\/www.vatland.no\/index.php\/csp-access-to-tenants-using-powershell-part-4\/","url_meta":{"origin":957,"position":2},"title":"CSP access to tenants using powershell. Part 4","author":"Atle","date":"September 24, 2019","format":false,"excerpt":"This is a small script that connects to partnercenter list all customers tenants and let you select one. When one is selected it connects to azuread and az for that customer. All my credentials are stored in SecretServer . I use a web service request to get those credentials. I\u2026","rel":"","context":"In "Azure"","block_context":{"text":"Azure","link":"https:\/\/www.vatland.no\/index.php\/category\/azure\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":975,"url":"https:\/\/www.vatland.no\/index.php\/log-tenants-from-office-365-to-local-db\/","url_meta":{"origin":957,"position":3},"title":"Log tenants from office 365 to local Db","author":"Atle","date":"January 3, 2021","format":false,"excerpt":"Hi, I like to keep control of how many licenses our cutomers use versus how many\u00a0 have been purchased. Here is 1st part\u00a0 my PS script to copy the info from csp to the DB. I will start creating a database and table to keep a list of all the\u2026","rel":"","context":"In "Azure"","block_context":{"text":"Azure","link":"https:\/\/www.vatland.no\/index.php\/category\/azure\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1010,"url":"https:\/\/www.vatland.no\/index.php\/add-tenant-licenses-from-csp-to-database\/","url_meta":{"origin":957,"position":4},"title":"Add tenant licenses from csp to database.","author":"Atle","date":"January 17, 2021","format":false,"excerpt":"This is a followup from previus post. In this post I will populate the database with what licenses a tenant has aquired. This will add records of what aquired skus and 'usage'. For me this is how many license are bought versus how many are assigned. This does not account\u2026","rel":"","context":"In "Azure"","block_context":{"text":"Azure","link":"https:\/\/www.vatland.no\/index.php\/category\/uncategorized\/azure-uncategorized\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":902,"url":"https:\/\/www.vatland.no\/index.php\/csp-access-to-tenants-using-powershell-part-3\/","url_meta":{"origin":957,"position":5},"title":"CSP access to tenants using powershell. Part 3","author":"Atle","date":"September 23, 2019","format":false,"excerpt":"In this part 3 of CSP and powershell I will show how you can connect to azureAD of a customer tenant using your CSP app credentials and refreshtoken. This is almost the same procedure as we use to connect to az. We will start with the same variables as in\u2026","rel":"","context":"In "Azure"","block_context":{"text":"Azure","link":"https:\/\/www.vatland.no\/index.php\/category\/azure\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/posts\/957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/comments?post=957"}],"version-history":[{"count":8,"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/posts\/957\/revisions"}],"predecessor-version":[{"id":965,"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/posts\/957\/revisions\/965"}],"wp:attachment":[{"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/media?parent=957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/categories?post=957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/tags?post=957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}