Connect-MsolService $TStamp = $(get-date -f MM-dd-yyyy_HH_mm_ss) $Devices = Get-MsolDevice -All -ReturnRegisteredOwners -IncludeSystemManagedDevices $DeviceInfo = @() foreach ($Device in $Devices) { $DeviceInfo += [PSCustomObject]@{ "DisplayName" = $Device.DisplayName "DeviceTrustType" = $Device.DeviceTrustType "DeviceTrustLevel" = $Device.DeviceTrustLevel "DeviceOS" = $Device.DeviceOsType "DeviceVersion" = $Device.DeviceOsVersion "RegisteredOwner" = $($Device.RegisteredOwners) "LastLogon" = $Device.ApproximateLastLogonTimestamp "LastDirSync" = $Device.LastDirSyncTime "DeviceID" = $Device.DeviceId "ObjectID" = $Device.ObjectId } } $DeviceInfo | Export-Csv -NoTypeInformation c:\temp\"Device Info - $TStamp.csv"