Forum Discussion

jcasqueiro's avatar
jcasqueiro
Brass Contributor
Oct 13, 2023
Solved

Exporting users to a csv file with all attributes (normal and extended)

Hi, In  O365 I can export all tenant users to a csv file through the admin console but the extended attributes don't show up. Is there  script that allows me to create a csv file with all the users...
azure active directory
office 365
  • VasilMichev's avatar
    VasilMichev
    Oct 14, 2023
    Extension attributes can only be fetched via the Graph cmdlets, and you need to specifically request them. So something like this:

    Get-MgBetaUser -UserId blabla -Property Id,UserPrincipalName, extension_fe2174665583431c953114ff7268b7b3_Education_ObjectType,
    extension_fe2174665583431c953114ff7268b7b3_Education_AnchorId, ... | select Id,UserPrincipalName, extension_fe2174665583431c953114ff7268b7b3_Education_ObjectType,
    extension_fe2174665583431c953114ff7268b7b3_Education_AnchorId, ...
VasilMichev's avatar
VasilMichev
MVP
Oct 13, 2023
Which attributes are you referring to, the set of 15 customAttributeXX? The Graph SDK for PowerShell can be used to export most attributes, including the customAttributeXX ones (they are exposed as part of the OnPremisesExtensionAttributes property). For example:

Get-MgBetaUser -UserId email address removed for privacy reasons | select -ExpandProperty OnPremisesExtensionAttributes | fl
jcasqueiro's avatar
jcasqueiro
Brass Contributor
Oct 13, 2023
Hi Vasil,
I am talking about the ones created by SchoolDataSync in a O365EDU tenant. As far as I can tell, apart from the normal user attributes, the extended ones are:
extension_fe2174665583431c953114ff7268b7b3_Education_ObjectType
extension_fe2174665583431c953114ff7268b7b3_Education_AnchorId
extension_fe2174665583431c953114ff7268b7b3_Education_SyncSource
extension_fe2174665583431c953114ff7268b7b3_Education_SyncSource_TeacherId
extension_fe2174665583431c953114ff7268b7b3_Education_TeacherNumber
extension_fe2174665583431c953114ff7268b7b3_Education_TeacherStatus
extension_fe2174665583431c953114ff7268b7b3_Education_Title
extension_fe2174665583431c953114ff7268b7b3_Education_SyncSource_SchoolId
extension_fe2174665583431c953114ff7268b7b3_Education_Email

Thanks
  • VasilMichev's avatar
    VasilMichev
    MVP
    Oct 14, 2023
    Extension attributes can only be fetched via the Graph cmdlets, and you need to specifically request them. So something like this:

    Get-MgBetaUser -UserId blabla -Property Id,UserPrincipalName, extension_fe2174665583431c953114ff7268b7b3_Education_ObjectType,
    extension_fe2174665583431c953114ff7268b7b3_Education_AnchorId, ... | select Id,UserPrincipalName, extension_fe2174665583431c953114ff7268b7b3_Education_ObjectType,
    extension_fe2174665583431c953114ff7268b7b3_Education_AnchorId, ...

Resources