Powershell How to Use Dictionary/Hash Table

-
Dictionary/Hash Table is a "Key, Value" pair. It can make a list of key and value. So its very easy to relate which key belongs to which value. Below is the example of hash table.

clear
Remove-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
Add-PSSnapin Microsoft.SharePoint.Powershell 
$SiteUrl = "http://pps-dd-lite:9595/Sites/IPM"
$LobSystemInstance = "IPM.BCS.ReferenceDataInstance"
$EntityNamespace = "IPM.BCS.ReferenceData"
$myHash = @{}
$myHash["Key_1"] = "Value_1_ABC"
$myHash["Key_2"] = "Value_2_DEF"
$myHash["Key_3"] = "Value_3_GHI" 

 foreach($key in $($myHash.keys))
{
 Write-Host "For key"  $key  " value is "  $myHash[$key]
}
 
Result:



Comments

Post a Comment

Popular posts from this blog

C# Copy files from one server to another

-
Sometimes we need to copy files from one sever and paste those files to another server programmatically. So for that we can use below code but we should have admin credentials of that server where we want to paste files. In below method we need to pass source path of the server, from where we want to copy and destination path of the server, where we want to paste. Also we need to provide UserName, Domain, Password of the server where we want to paste those files. public void CopyFiles(string sourcePath, string destinationPath)         {             try             {                  IntPtr admin_token = new IntPtr();                 // use LOGON32_LOGON_NEW_CREDENTIALS as Lo...
Read more

Export SharePoint Online Group Users to Excel using Powershell

-
Sometimes, we have a requirement to generate user reports from SharePoint groups or validate which user is added to which groups etc. If we do this activity manually, it may take forever (obviously based on the user added to group 😉).  Classic example, recently in my project i got a requirement where i need to find all the users who are added to multiple SharePoint groups. Now i have 2500 users added to my SP Groups and it is difficult to check one by one. So i generated CSV/Excel for each group and added a vlookup in excel and got my report. Below is the Powershell script, which helps to generate CSV file based on group name.  Note: All the input variables are mentioned in Green Color, Please update before executing this script. $aClient = [ System.Reflection.Assembly ]:: LoadWithPartialName( "Microsoft.SharePoint.Client" ) $aClientRuntime = [ System.Reflection.Assembly ]:: LoadWithPartialName( "Microsoft.SharePoint.Client.Runtime" )   Function Get-UserInfo...
Read more