Office 365 Field Data

gorgeittech · 2018-07-11T20:36:15.000Z

I am trying to extract the MobilePhone field from the contact list in Office 365, but can’t find a way to perform this, does anyone know of a cmdlet or method for extracting this information? I’ve been using Get-DistrobutionGroupMember and Get-DistrobutionGroup as part of my script, which pulls all the information I need except MobilePhone. Thanks!

Neally · 2018-07-11T20:43:28.000Z

You probably need to use ‘get-msoluser’ to get that info.

(get-msoluser -UserPrincipalName $UPN).mobilephone

gorgeittech · 2018-07-11T21:01:11.000Z

Neally:

You probably need to use ‘get-msoluser’ to get that info.
(get-msoluser -UserPrincipalName $UPN).mobilephone

That was my first thought, but can I use MsolUser pull data from the Contact List?

Neally · 2018-07-11T21:31:28.000Z

GorgeITTech:

can I use MsolUser pull data from the Contact List?

What do you mean? Depends on your code.

gorgeittech · 2018-07-11T21:34:00.000Z

I’m using the following once connected

$objDistributionGroups = Get-DistributionGroup -ResultSize Unlimited  Foreach ($objDistributionGroup in $objDistributionGroups) {         write-host "Processing $($objDistributionGroup.DisplayName)..."    #Get members of this group   $objDGMembers = Get-DistributionGroupMember -Identity $($objDistributionGroup.PrimarySmtpAddress)      write-host "Found $($objDGMembers.Count) members..."      #Iterate through each member   Foreach ($objMember in $objDGMembers)   {     Out-File -FilePath $OutputFile -InputObject "$($objDistributionGroup.DisplayName),$($objDistributionGroup.PrimarySMTPAddress),$($objMember.DisplayName),$($objMember.Phone),$($objMember.MobilePhone),$($objMember.PrimarySMTPAddress),$($objMember.RecipientType)" -Encoding UTF8 -append     write-host "`t$($objDistributionGroup.DisplayName),$($objDistributionGroup.PrimarySMTPAddress),$($objMember.DisplayName),$($objMember.Phone),$($objMember.MobilePhone)$($objMember.PrimarySMTPAddress),$($objMember.RecipientType)"  } }

Neally · 2018-07-11T21:35:05.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

gorgeittech · 2018-07-11T21:37:48.000Z

Sorry forgot about that, updated

Neally · 2018-07-11T21:39:02.000Z

Ok, and where do you want to put the phone number in therE? in the out-file?

Maybe you should rather build a custom object, that would be cleaner…

gorgeittech · 2018-07-11T21:41:15.000Z

Yes I want it in the outfile, and I thought about the custom object, just didn’t know how to pull the information, still learning

Neally · 2018-07-11T21:57:55.000Z

I haven’t tested it, but this is the idea

$objDistributionGroups = Get-DistributionGroup -ResultSize Unlimited
$OutputFile            = "$env:userprofile\desktop\export.csv"

Foreach ($objDistributionGroup in $objDistributionGroups) {   
    write-verbose "Processing $($objDistributionGroup.DisplayName)..." -verbose

    #Get members of this group 
    $objDGMembers = Get-DistributionGroupMember $objDistributionGroup.PrimarySmtpAddress
    write-verbose "Found $($objDGMembers.Count) members..." -Verbose

    #Iterate through each member 
    Foreach ($objMember in $objDGMembers) { 
        $data = [PSCustomObject]@{
            GroupDisplayName        = $objDistributionGroup.DisplayName
            GroupPrimarySMTPAddress = $objDistributionGroup.PrimarySMTPAddress
            UserDisplayName         = $objMember.DisplayName
            Phone                   = $objMember.Phone
            MobilePhone             = (get-msoluser $objMember.PrimarySMTPAddress).MobilePhone
            UserPrimarySMTPAddress  = $objMember.PrimarySMTPAddress
            RecipientType           = $objMember.RecipientType
        }

        $data | export-csv $OutputFile -Append -NoTypeInformation

        write-host "`t$data"
    }
}

gorgeittech · 2018-07-11T22:00:09.000Z

will give this a try and see what I come up with, thanks so much for the help

jitensh · 2018-07-12T01:51:26.000Z

why you running get-distribution listt? if you need contact run

Get-MailContact|select DisplayName,Mobile

davenoel · 2018-07-17T20:56:53.000Z

I’m OP’s co-worker and have been tasked with taking over this script. The original request from our client is to pull a list of users (along with names, email address, primary and mobile phone numbers) in distribution lists from their office 365 environment. However, their DLs are populated with a mix of users in their AD structure and contact records they created for people external to the company. The script OP posted gets us 90% of the data but the command doesn’t support the mobile phone field from what we could find. OP is more advanced in powershell usage than I am but due to circumstances beyond my control they are no longer available to help with this.

Is there a clean way to pull the data the client is requesting given that the DLs are both AD users and contact records?

Thanks in advance

tulioarends · 2018-07-18T13:12:34.000Z

First, lets find out what kinds of objects Get-DistributionGroupMember is returning and what their properties are.


# Choosea distribution list that has both users and contacts

$typeGroups = Get-DistributionGroupMember -Identity "Ditribution list"|Group-Object $_.getType()

foreach ($typeGroup in $typeGroups){

    $typeGroup.Name

    $typeGroup.Group|Get-Member -MemberType Property

}

This will let us know what type of objects we are working with and what properties are being included. Run it and report back.

davenoel · 2018-07-24T15:28:02.000Z

produces the following error:

You cannot call a method on a null-valued expression.
At line:1 char:1
+ $typeGroups = Get-DistributionGroupMember -Identity "Ditribution list ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

Thank you for your help.

tulioarends · 2018-07-25T11:37:25.000Z

You need to replace “Ditribution list” with the name of an actual distribution list that contains both users and contacts, as I explained in the comment.

davenoel · 2018-07-26T20:45:13.000Z

I launched a powershell session, ran connect-msolservice, entered the admin credentials and ran the script you provided and entered the actual distro list display name that I’m looking for and it returns the same error.

tulioarends · 2018-07-27T11:52:15.000Z

There is no way I can debug this remotely. Try each step in the pipeline until you find the error.

Start with

Get-DistributionGroupMember -Identity "Whatever your group is called"

davenoel · 2018-07-27T13:10:26.000Z

Is there another set of tools I need to install to make it work? I have the Azure AD tools installed. “get-DistributionGroupMember is not recognized as the name of a cmdlet, function, script file, or operable program.”

gorgeittech · 2018-07-27T13:20:42.000Z

Dave,

get-DistributionGroupMember is a cmdlet from the exchange O365 module that you have to import via the pssession when connected via exchange