Powershell: convert System.Object to plain string

Asked Apr 29 '16 at 19:36

Active Apr 29 '16 at 19:36

Viewed 2,959 times

i'm trying to retrieve some information from SQL server and assign it to a variable:

$query = "select top 1 * from [DB1].[dbo].[table1] where servername='ABC-CDE-SVR1'" 
$svrParams = Invoke-Sqlcmd -Query $query -ServerInstance "ADMNSVR"

in this case $svrParams is a System.Object with a bunch of parameters:

:\> $svrParams

ServerCode             : 6
ServerName             : ABC-CDE-SVR1
Environment_Abbr       : SVR1
ServerWithInstanceFlag : False
EnvironmentTypeCode    : 3
ActiveFlag             : True
PrimaryDriveLetter     : Z:

I'm trying to pull them one by one by assigning to new variables like this:

$backupDrive = $svrParams.PrimaryDriveLetter | Out-String

The issue is that the variable still comes out System.Object type. So when i'm trying to concatenate it with another string, i get 2-line result:

:\> $DBbackupLocation = "$backupDrive" + "\Backup\Data\"
:\> $DBbackupLocation 

Z:
\Backup\Data\

Please let me know if there is a way to extract the plain text out of the object. Tried [string] before the variable with the same result.

asked Apr 29 '16 at 19:36

Nik

$svrParams.PrimaryDriveLetter.ToString() – RichardCL Apr 29 '16 at 20:09
@richard345 thank you that helped! – Nik Apr 29 '16 at 20:13
You're welcome! Just a caution, that will fail if PrimaryDriveLetter is ever null. – RichardCL Apr 29 '16 at 20:19
Chances are that either `$srvParams` or the `PrimaryDriveLetter` are an array where one or more item is null or whitespace. `[string]$DBbackupDrive = $srvParams.PrimaryDriveLetter|?{![string]::IsNullOrWhitespace($_)}` That would probably fix the issue. – TheMadTechnician Apr 29 '16 at 22:52
@TheMadTechnician that's a valid point, will take it into account. thank you – Nik May 02 '16 at 15:38

Powershell: convert System.Object to plain string

0 Answers0