I ended up doing this:
$AllUsers = Get-QADUser -SizeLimit 0 | Select
givenName,LastName,DisplayName,description,mail,ParentContainer,SAMAccountName,homeDirectory,AccountIsDisabled,MemberOf
| sort AccountIsDisabled,LastName,FirstName
ForEach ($User in $AllUsers)
{
$Cells.Item($CurrentRow, $CurrentCol) = $User.displayName
$CurrentCol++
$ListOfGroups = Get-QADMemberOf $User.sAMAccountName
$UsersGroups = ""
ForEach ($GroupName in $ListOfGroups)
{
$UsersGroups += "|" + $GroupName.Name + "|, "
}
$Cells.Item($CurrentRow, $CurrentCol) = $UsersGroups
$Sheet.columns.item($CurrentCol).columnWidth = 52
$Cells.Item($CurrentRow, $CurrentCol).WrapText = $True
}
So I nested a couple loops, and I broke out each group, enclosed it in
"|" - which I found makes it more readable - and stored it in an Excel
cell, which I widen and wrap, for readability.
Basically this gives me a spreadsheet of all users, their home
folders, and group memberships. I keep it as a sort of snapshot of AD,
so that in 5 years, when I get a request to restore the home folder of
some user that doesn't work here anymore, and who has been deleted out
of AD, I have a way to find out where that home folder was, and I can
query the backup system for that location and time frame. (and yes, I
have had that happen, which is why I wrote the script).
On Tue, Feb 26, 2013 at 4:48 PM, Steven Peck <[email protected]> wrote:
> .memberOF outputs an array and arrays don't play well with other types of
> info with just a straight select-object
>
> I used to use Get-QadUser JDoe | Get-QADMemberOf for this type of stuff
>
> Haven't actually had to solve this problem in a while now though.
>
>
>
> On Tue, Feb 26, 2013 at 12:36 PM, Michael Leone <[email protected]> wrote:
>>
>> On Tue, Feb 26, 2013 at 2:56 PM, Michael Leone <[email protected]>
>> wrote:
>> > I am unsure what I am doing wrong. I want a list of all my user
>> > accounts, and I want the contents of the "MemberOf" property, among
>> > other things.
>> >
>> > Get-QADuser -SizeLimit 0 | Select
>> >
>> > givenName,LastName,DisplayName,mail,ParentContainer,SAMAccountName,homeDirectory,AccountIsDisabled,MemberOf,NestedMemberOf,AllMemberOf
>> >
>> > I sort this, and export to CSV. When I import the CSV into Excel, the
>> > "MemberOf", "NestedMemberOf" and "AllMemberOf" are showing as
>> > "System.String[]".
>> >
>> > What am I doing wrong? I want that "MemberOf" to actually list what
>> > groups the user is a member of.
>>
>> So here is where I am. I am trying to output into an Excel spreadsheet:
>>
>> $AllUsers = Get-QADUser -SizeLimit 0 LeoneM | Select
>>
>> givenName,LastName,DisplayName,description,mail,ParentContainer,SAMAccountName,homeDirectory,AccountIsDisabled,MemberOf,NestedMemberOf,AllMemberOf
>> | sort AccountIsDisabled,LastName,FirstName
>>
>> ForEach ($User in $AllUsers)
>> {
>>
>> $Cells.Item($CurrentRow, $CurrentCol) = $User.displayName
>> $CurrentCol++
>>
>> $ListOfGroups = Get-QADMemberOf $User.sAMAccountName
>> $Cells.Item($CurrentRow, $CurrentCol) = $ListOfGroups
>>
>> Write-Host $User.displayName $ListOfGroups
>>
>> $CurrentRow++
>> $CurrentCol = 1
>> }
>>
>> And my $ListOfGroups writes out on my screen, but does NOT get written
>> into the spreadsheet.
>>
>> What's that about?
>>
>> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
>> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
>>
>> ---
>> To manage subscriptions click here:
>> http://lyris.sunbelt-software.com/read/my_forums/
>> or send an email to [email protected]
>> with the body: unsubscribe ntsysadmin
>
>
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
>
> ---
> To manage subscriptions click here:
> http://lyris.sunbelt-software.com/read/my_forums/
> or send an email to [email protected]
> with the body: unsubscribe ntsysadmin
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to [email protected]
with the body: unsubscribe ntsysadmin
