AAD Connect Phone/Fax Mappings

Yesterday, while working with my colleague Michael Anderson, I needed to investigate where a particular on-premises value was being synced in AAD.  The result is this table:

AD Property Get-MsolUser Get-AzureADUser Get-User Get-CSOnlineUser
Friendly name ldapDisplayName
Telephone number telephoneNumber PhoneNumber TelephoneNumber Phone Phone
Pager pager Pager
Mobile mobile MobilePhone Fax MobilePhone
Fax facsimileTelephoneNumber Fax FacsimileTelephoneNumber Fax Fax
IP Phone ipPhone IPPhone
Home homePhone HomePhone HomePhone
{otherMobile} {AlternateMobilePhones}
{otherHomePhone} {OtherHomePhone}
{otherFacsimileTelphoneNumber} {OtherFax}
{otherTelephone} {OtherTelephone} {OtherTelephone}

It’s important to note that values displayed in braces { } are multivalued attributes, so if there’s something stored in one on-premises that you need or want to map to a a different attribute in Azure AD, you’ll need to either map it to another multivalued attribute or extract the value so you can write it to a single-valued string attribute. … [ Continue reading ]


Flashback to what it took to do math in DOS batch files

While working on a script for an upcoming project, I wanted to test for the presence of various Office versions, including 32-bit and 64-bit components before initiating setup. Here’s one way I found:

SET CURRLOCATION32="C:\Program Files (x86)\MicrosoftOffice\root\Office16"
SET CURRLOCATION64="C:\Program Files\MicrosoftOffice\root\Office16"
SET PREV1LOCATION32="C:\Program Files (x86)\MicrosoftOffice\root\Office15"
SET PREV1LOCATION64="C:\Program Files\MicrosoftOffice\root\Office15"
SET PREV2LOCATION32="C:\Program Files (x86)\MicrosoftOffice\root\Office14"
SET PREV2LOCATION64="C:\Program Files\MicrosoftOffice\root\Office14"

REM Check for 64-bit versions
[ Continue reading ]

Export Credential Manager to PowerShell

If you ever find yourself in a sticky wicket and need to extract usernames and passwords from Credential Manager (usually because you forgot them), you can use this handy-dandy little function from PowerShell:

function ExportCredMan
    # Dump local passwords from credential manager
[ Continue reading ]