That means that the value in that column is an array.
An easy way to convert an array to a single string is with the -join operator.
$vmProperty.Add("CI Status", (Get-CIStatus) -join '|')
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference
The user that established the vSphere Server connection can be found with
($global:defaultVIServer).User
The user in whose session the script is running can be found with
Your condition should probably look like this (if I understood the intention correctly)
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference
deleted
Not exactly sure what exactly you mean, but if it is the output coming from Write-Output in that function, you should enclose the variables in $()
Whenever you want to substitute a property of an object in a string, you have to enclose it.
Like this
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference
deleted
deleted
I'm not that versed in SQL, but isn't that Invoke-SqlCmd error caused by missing quotes around the value?
SELECT * FROM [myDatabase].[dbo].CMDB_CI
WHERE Name='$vmName'"
Since you are using the ordered hash table $vmProperty in multiple functions, you will have to make that a variable in the Script scope as well.
Replace all $vmProperty occurrences with $script:vmProperty, and give it another go.
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference