Hi guys, another day another query,

I have created the script below to validate some details of some user accounts.  The script runs fine unless I output to a file:

ForEach ($user in $users) {get-qaduser "$user" -sizelimit 0 -IncludedProperties altRecipient | select name,altRecipient,accountexpires,pass*,accountisdisabled,lastlog*,canonicalname } | export-csv -path d:\Leaver-Validation.csv

If I try to ouput the script to a file PowerShell errors with the following:

An empty pipe element is not permitted.
At line:1 char:186
+ foreach ($user in $users) {get-qaduser "$user" -sizelimit 0 -IncludedProperties altRecipient | select name,altRecipie
nt,accountexpires,pass*,accountisdisabled,lastlog*,canonicalname } |  <<<< export-csv -path d:\Leaver-Validation.csv

I'm lost on why this happening, Does anyone have any Ideas?

Thanks

Lee

Try with the foreach-object cmdlet instaed, it is more pipeline friendly then the foreach statment:

$users | foreach { get-qaduser $_ -IncludedProperties altRecipient | select name,altRecipient,accountexpires,pass*,accountisdisabled,lastlog*,canonicalname} | export-csv -path d:\Leaver-Validation.csv

BTW, the -sizeLimit 0 is not needed, you use it only when you want to get all user objects. In this case you already have the objects in $users.

Ok..I am having the same problem...can someone help..below is the code

Import-csv c:\file.csv | foreach {get-qaduser -samaccountname $_.samaccountname | export-csv -path c:\fileout.csv}

it is just overwriting each line in the .csv out file.

Nevermind, I had my curly brace in the wrong place. lol

Shay,

one more question...I think I have ad accounts that may not return anything so I want to be able to show my query variable in the first column of the .csv file like this

$_.samaccountname,samaccountname,displayname,givenname,etc...

How do I pipe the variable out to the .csv file.

If I follow, you want to write a none existent account (piped) samaccount's name to the first coulmn and leave all other propeties null?