Don't use -IncludeAllProperties just to get proxyaddresses, you can use -IncludedProperties and specify just the ones you need.
You also need to reorder the -like command, first do like and then join the values:


Get-qaduser -IncludedProperties proxyaddresses -SizeLimit 0 | select samaccountname,proxyaddresses | foreach {
$sql= "INSERT INTO robdb.dbo.Test_tbl ( samaccountname,proxyaddresses ) VALUES ( '{0}','{1}' )" -f $_.SamAccountName, (($_.proxyaddresses -like "X400:c*") -join ";" )
invoke-sqlcmd $sql
}

Thanks Shay, I was using -IncludeAllProperties as I hope to include extensionattributes also - this will allow me to tie the dataset from this script into a user provisioning database I have.

The addition to the script gave the x400 address, but included all objects with an x400 address. What I hoped to achieve was to write only the objects to the database that had 2 or more x400 addresses if that makes sense. We have a very large AD and writing all the x400 addtresses is not a great solution for me.

Basically, I was hoping for

SamAccountName, X400......X400

I don't mind if the entire proxyaddresses string is included as I can remove the scrap later.

Is this possible at all?

Thanks for the prompt reply

Robbie.

Get-qaduser... | where {($_.proxyaddresses -like "X400:c*") -ge 2} | foreach { ...

Thanks again Shay - I'm getting similar results however. I've put together all you've said and I guess I could just write all the proxyaddresses to my table - it may come in useful! I just not too sure of the correct method to take this ADSI data into SQL - I've used SQLs LDAP but its too fragile so hoped PS could give me what I need.

Invoke-expression sqlcmd
Invoke-Sqlcmd "if exists (select * from robdb.dbo.sysobjects where name = 'Test_tbl') drop table robdb.dbo.test_tbl"
Invoke-Sqlcmd "create table robdb.dbo.Test_tbl ( samaccountname varchar(50), proxyaddresses varchar(500) )"


Get-qaduser -IncludedProperties proxyaddresses -SizeLimit 0 | select samAccountName,proxyAddresses | where {($_.proxyaddresses -like "X400:c*") -ge 2 } | foreach {

$sql= "INSERT INTO robdb.dbo.Test_tbl ( samaccountname,proxyaddresses ) VALUES ( '{0}','{1}' )" -f $_.SamAccountName, ( $_.proxyaddresses -join ";" )

write-host $sql

}

Thanks

Rob