Solved

powershell get sql virtual

Posted on 2013-01-03

1 solution

399 Views

Last Modified: 2013-01-04

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

Comment

Question by:bibi92

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

5 Comments

LVL 25

Expert Comment

by:TempDBA

ID: 387411862013-01-03

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

Author Comment

by:bibi92

ID: 387412022013-01-03

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

LVL 40

Expert Comment

by:Subsun

ID: 387417112013-01-03

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

LVL 40

Accepted Solution

by:Subsun

Subsun earned 500 total points

ID: 387417752013-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

Author Closing Comment

by:bibi92

ID: 387431842013-01-04

Thanks regards bibi

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title	# Comments	Views	Activity
Modifying AD PowerShell script to show CN / OU location where the AD computer resides.	3	46	6d
Powershell - Set-Location using a variable	2	31	2017-05-12
Psexec with Powershell to install critical patches	5	74	2017-05-17
Active Directory Powershell Script	9	41	2017-05-18

Making better use of HashTables in PowerShell

Article by: SavindraSingh

This article will help you understand what HashTables are and how to use them in PowerShell.

Powershell

Uninstall applications from Windows 10 ISO version 1607

Article by: dj

Windows 10 came with a lot of built in applications, Some organisations leave them there, some will control them using GPO's. This Article is useful for those who do not want to have any applications in their image (example:me).

Secure Portal Encryption

Video by: Dermot

With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

How to change priority of transport agents in Exchange 2007/2010 using Exchange Management Shell

Video by: CodeTwo

Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…