Powershell calculated properties for multiple values

powershell

I am making an Outlook inventory powershell script.. I want to retrieve:

Account DisplayName
Account email
Account type (POP3, IAMP or Exchange)
Exchange mode (Online, Cached)

Code:

Add-Type -assembly "Microsoft.Office.Interop.Outlook"
$Outlook = New-Object -comobject Outlook.Application
$namespace = $Outlook.GetNameSpace("MAPI")
$namespace.Accounts |
   Select-Object DisplayName, SmtpAddress, UserName, AccountType, ExchangeConnectionMode |
   Sort-Object  -Property SmtpAddress | Format-Table

This do the job, but it would really cool if I could use calculated properties to show AccountType and ExchangeConnectionMode values as custom friendly name, instead of numeric value. For example:

AccountType
0 = Exchange
1 = IMAP
2 = POP3
Else = numeric value (real value)

ExchangeConnectionMode
700 = Cached
800 = Online
Else = N/A (or whatever similar text, for non exchange accounts)

I already used calculated properties before but only with math calcs and single value (without multiple values). I guess "foreach" or "if" will be needed… Can't figure it out how 🙁

Any clue?

Best Answer

Read and follow Using Calculated Properties and Working with Hash Tables.

Using Outlook's OlExchangeConnectionMode Enumeration and OlAccountType Enumeration, the following code snippet should do the job:

$AccntTypes = @{ '0' = 'Exchange'; 
                 '1' = 'IMAP';
                 '2' = 'POP3';
                 '3' = 'HTTP'; 
                 '4' = 'EAS';
                 '5' = 'unknown'}
$ExchConnModes = @{'0' = 'Exchange'; 
                   '800' = 'Online';
                   '700' = 'CachedConnectedFull';
                   '600' = 'CachedConnectedDrizzle'; 
  # (incomplete; please update from `OlExchangeConnectionMode` Enumeration)
                    }

Add-Type -assembly "Microsoft.Office.Interop.Outlook"
$Outlook = New-Object -comobject Outlook.Application
$namespace = $Outlook.GetNameSpace("MAPI")
$namespace.Accounts |
   Select-Object DisplayName, SmtpAddress, UserName, 
    @{Name="AccountType";
      Expression={$AccntTypes[[string]$_.AccountType]}} , 
    @{Name="ExchangeConnectionMode";
      Expression={$ExchConnModes[[string]$_.ExchangeConnectionMode]}} |
   Sort-Object  -Property SmtpAddress | Format-Table

Related Solutions

Powershell – List all user profile properties with PowerShell – PowerShell query

I've further developed the code so that it now accepts a comma delimited list of properties and writes them to a delimited file.

# Outputs a delimited file with specified user profile properties for each user in Sharepoint

# Create array of desired properties
$arProperties = 'UserName','FirstName','LastName','Title','WorkEmail','WorkPhone','Manager','AlternateContact','RoleDescription','PictureURL';
# Specify output file
$outfile = 'UserProfiles.csv';
#Specify delimiter character (i.e. not one that might appear in your user profile data)
$delim = '^';
# Specify Shared Service Provider that contains the user profiles.
$SSP = "SharedServices";

[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Server")
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Server.UserProfiles")

# Function:          Get-UserProfiles
# Description:       return a UserProfileManager object containing all user profiles
# Parameters:        SSPName          SSPName    
#
Function global:Get-UserProfiles($SSPName)
{
 $ServerContext = [Microsoft.Office.Server.ServerContext]::GetContext($SSPName);
 $UPManager = new-object Microsoft.Office.Server.UserProfiles.UserProfileManager($ServerContext);
 return $UPManager.GetEnumerator();
}
$profiles = Get-UserProfiles($SSP);

#Initialise Output file with headings
$header = [string]::join($delim,$arProperties);
Write-Output $header | Out-File $outfile

#Output the specified properties for each
$profiles | ForEach-Object {
 foreach($p in $arProperties){
  # Get the property name and add it to a new array, which will be used to construct the result string
  $arProfileProps += $_.Item($p);
 }  
 $results = [string]::join($delim,$arProfileProps);
 # Get rid of any newlines that may be in there.
 $CleanResults = $results.Replace("`n",'');
 Write-Output $CleanResults
 Remove-Variable -Name arProfileProps
} | Out-File -Append $outfile

This gets me a bit closer. I'd still really like a script that iterates through all the profile properties and puts them into a CSV or XML file more gracefully. This will do for now.

Powershell Switch statement with multiple values

$myNumber = 3
$arrA = 1, 3, 5, 7, 9
$arrB = 2, 4, 6, 8, 10
switch ($myNumber) { 
    {$arrA -contains $_} { write-host "Odd" } 
    {$arrB -contains $_} { write-host "Even" }
}

Related Topic