Map volume to vserver with SWQL

rinat.kirimov

Hi,

I'm trying to update volumes using SWQL and Orion SDK but I need to take which vserver those volumes belong to. In SQL I see there is a separate table just for VolumeToVserver mapping but I can't seem to find similar in SWQL.

Any suggestions?

jm_sysadmin

OK @rinat.kirimov, I adapted another script I had to be close to what you want (maybe?), but I wasn't able to run it, so you will need to tweak it. Specifically the custom properties, but I might have typos or some small logic mistakes. 

param ($SwisServer, $credentials)try { Add-PSSnapin SwisSnapin }catch {	Write-Host "Message: $($Error[0])";	exit 1;}try {    $swis = Connect-Swis -Certificate #Credentials not needed when run on Orion server. Good for scheduled tasks    if ($SwisServer -eq $null) { $SwisServer = 'localhost' }}catch {    $credentials = Get-Credential    if ($SwisServer -eq $null) { $SwisServer = read-host -Prompt "Please enter a servername" }    if ($credentials -eq $null) { $credentials = Get-Credential }   	$Swis = Connect-Swis $SwisServer -Credential $credentials}$NAS_Volumes_Query = 'SELECT TOP 1000 SRM_V.Caption, SRM_V.Uri, SRM_V.VServers.Caption as [VServer] FROM Orion.SRM.Volumes SRM_V'$SRM_NAS_Volumes = Get-SwisData -SwisConnection $swis -Query $NAS_Volumes_Query $PropertyValue1 = 'Kermit the Frog'$PropertyValue2 = 'Gonzo'$PropertyValue3 = 'Beaker'For Each ($Volume in $SRM_NAS_Volumes) {    If ( $Volume.VServer -like "%whatever%" ) {        $text = "Updating "+ $volume.Caption +" Property VolProp to "+ $PropertyValue1        Write-host $text        $customProps = @{            VolProp  = $PropertyValue1            # Do more than 1 property if you want            # otherVolProp  = 'data'        }        $NAS_VOlume_CustomPropURI = $Volume.URI + '/CustomProperties'        Set-SwisObject $swis -Uri $NAS_VOlume_CustomPropURI -Properties $customProps    }        If ( $Volume.VServer -like "%something%" ) {        $text = "Updating "+ $volume.Caption +" Property VolProp to "+ $PropertyValue2        Write-host $text        $customProps = @{            VolProp  = $PropertyValue2            # Do more than 1 property if you want            # otherVolProp  = 'data'        }        $NAS_VOlume_CustomPropURI = $Volume.URI + '/CustomProperties'        Set-SwisObject $swis -Uri $NAS_VOlume_CustomPropURI -Properties $customProps    }}