Status: Solved
Priority: Medium
Security: Public
Views: 412
Last Modified: 2013-01-04

powershell get sql virtual

Hello,

When I execute this powershell function :

function Get-ClusterSQL
{
param($cluster)

gwmi -class "MSCluster_Resource" -namespace "root\mscluster" -computername $cluster | where {$_.type -eq "SQL Server"} | Select @{n='VirtualServerName';e={$_.PrivateProperties.VirtualServerName}}, @{n='InstanceName';e={$_.PrivateProperties.InstanceName}}, `
@{n='ServerInstance';e={("{0}\{1}" -f $_.PrivateProperties.VirtualServerName,$_.PrivateProperties.InstanceName).TrimEnd('\')}}

}

The result is

VirtualServerName InstanceName ServerInstance
----------------- ------------ --------------
Test Test12 Test\Test12

How can I modify the function for having the result test\test12?

Thanks

Regards

bibi

bibi92

Asked: 2013-01-03

Advertise Here

1 Solution

LVL 25

TempDBACommented: 2013-01-03

Not clear with your question. Please explain a bit more.

bibi92Author Commented: 2013-01-03

I search how I can modify the function for display only test\test12 and not
ServerInstance
--------------
test\test12
Thanks
bibi

LVL 40

SubsunCommented: 2013-01-03

Does this work?
Get-ClusterSQL Cluster | Select -ExpandProperty ServerInstance

LVL 40

SubsunCommented: 2013-01-03

Or if you want to modify the function itself.. Then you can simply add
| Select -ExpandProperty ServerInstance at the end of gwmi command in function..

function Get-ClusterSQL
{
    param($cluster)
   
    gwmi -class "MSCluster_Resource" -namespace "root\mscluster" -computername $cluster  | where {$_.type -eq "SQL Server"} | Select `
    @{n='ServerInstance';e={("{0}\{1}" -f $_.PrivateProperties.VirtualServerName,$_.PrivateProperties.InstanceName).TrimEnd('\')}} | 
    Select -ExpandProperty ServerInstance
   
}

Open in new window

bibi92Author Commented: 2013-01-04

Thanks regards bibi

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Expand your skills with this month's free Premium course.

powershell get sql virtual

Join & Write a Comment Already a member? Login.

Featured Post