IT Process Automation

Hi Team ,

I have tried using Powershell in Process Automation to export the contact_uuid but that did not give me any data in Export.csv file it simply shows System.Byte instead.

Script which i am using : "$sel=Invoke-Sqlcmd -Query "select TOP 100 contact_uuid from [mdb].[dbo].ca_contact where userid != 'NULL'" -ServerInstance "sdepdbs036\dbs01" -Username "username" -Password "Password!"
$array =@()
foreach($r in $sel)
{

write-host $r
$array += $r
}
$array | select "contact_uuid" | Export-Csv "D:\cotact_list.csv" -Force -NoTypeInformation
[System.Data.SqlClient.SqlConnection]::ClearAllPools()

Try this in your query:

USE mdb SELECT TOP 100 [dbo].[hex](contact_uuid) AS cnt_id FROM [dbo].[ca_contact] where userid != 'NULL'

thanks Lindsay that worked for me