Help acquiring AD properties

Welcome Forums General PowerShell Q&A Help acquiring AD properties

This topic contains 0 replies, has 1 voice, and was last updated by  Forums Archives 7 years, 4 months ago.

  • Author
  • #6255

    Topics: 1562
    Replies: 0
    Points: 0
    Rank: Member

    by maindave at 2013-01-11 11:44:49

    Hi, I have written a script that output certian AD objects for a AD user account, next i'm retrieving groups AD user is a member of. The problem I'm having is getting the group membership to export as CSV.

    function get-userprop {

    param (
    $user = " "

    $userprop=Get-ADUser $user -properties * | sort name
    $usermem=(Get-ADUser $user -properties * | select memberof).memberof

    $obj = New-Object -typename psobject

    $obj | Add-Member -membertype noteproperty `
    -name "First Name" -value ($userprop.givenname)

    $obj | Add-Member -membertype noteproperty `
    -name "Last Name" -value ($userprop.surname)

    $obj | Add-Member -membertype noteproperty `
    -name "Description" -value ($userprop.description)

    $obj | Add-Member -membertype noteproperty `
    -name "Employee ID" -value ($userprop.EmployeeID)

    $obj | Add-Member -membertype noteproperty `
    -name "Account Status" -value ($userprop.enabled)

    $obj | Add-Member -membertype noteproperty `
    -name "B1 ID" -value ($

    $obj | Add-Member -membertype noteproperty `
    -name "OU" -value ($userprop.CanonicalName)

    $obj | Add-Member -membertype noteproperty `
    -name "Expiration Date" -value ($userprop.AccountExpirationDate)

    $obj | Add-Member -membertype noteproperty `
    -name "Group Membership" -value ($usermem)

    Write-Output $obj



    OUTPUT******** misssing group membership**************
    First Name Last Name Description Employee ID Account Status B1 ID OU Expiration Date
    XXX xxxxxx xxxxxx xxxxxx xxxxx xxx xx xxxx

    by RichardSiddaway at 2013-01-12 01:56:04

    Try something like this

    $user = "mgreen"

    Get-ADUser $user -properties * |
    select @{N="FirstName"; E={$_.givenname}},
    @{N="LastName"; E={$_.surname}},
    Description, EmployeeID,
    @{N="AccountStatus"; E={$_.enabled}},
    @{N="B1 ID"; E={$}},
    @{N="OU"; E={$_.CanonicalName}},
    @{N="Expiration Date"; E={$_.AccountExpirationDate}},
    @{N="Group Membership"; E={$($_.memberof)}} |
    Export-Csv -Path userdata.csv -NoTypeInformation

    I'm creating an object using Select-Object. N = Name and E=Expression

    Its a simpler way and a lot less typing. I get the group membership as a list in the last field of the CSV

    by maindave at 2013-01-15 13:10:29

    thx for your asisstance

The topic ‘Help acquiring AD properties’ is closed to new replies.

denizli escort samsun escort muğla escort ataşehir escort kuşadası escort