Get all export policies which are not assigned to volume / qtree

LUKASPRELOVSKY

Hello community,

i would like to create a powershell script, which shows me all export policies without volume / qtree assignment.

Anyone able to help me with some usefull code?

Thank you,

Lukas

mbeattie

Hi Lukas,

It's more efficent to query the OCUM database given the objects are already discovered and the database contains the information you are looking for. You can query the cluster\vserver using powershell if you required. Here is an example:

Param(
   [Parameter(Mandatory=$True, HelpMessage="The Cluster name or IP Address")]
   [String]$Cluster,
   [Parameter(Mandatory=$True, HelpMessage="The vserver name")]
   [String]$VserverName,
   [Parameter(Mandatory=$True, HelpMessage="The credentials to authenticate to the cluster")]
   [System.Management.Automation.PSCredential]$Credentials
)
Try{
   Import-Module DataONTAP -ErrorAction Stop
   Connect-NcController -Name $Cluster -HTTPS -Credential $Credentials -ErrorAction Stop | Out-Null
}Catch{
   Throw $("Failed connecting to cluster ""$Cluster"". Error " + $_.Exception.Message)
}
Try{
   $ep = Get-NcExportPolicy -Vserver $VserverName -ErrorAction Stop
}Catch{
   Throw $("Failed enumerating export policies. Error " + $_.Exception.Message)
}
Try{
   $vols = Get-NcVol -Vserver $VserverName -ErrorAction Stop
}Catch{
   Throw $("Failed enumerating volumes. Error " + $_.Exception.Message)
}
Try{
   $qt = Get-NcQtree -VserverContext $VserverName -ErrorAction Stop | Where-Object {$_.Id -ne 0}
}Catch{
   Throw $("Failed enumerating Qtrees. Error " + $_.Exception.Message)
}
[HashTable]$policies = @{};
[HashTable]$volumes  = @{};
[HashTable]$qtrees   = @{};
[HashTable]$used     = @{};
[HashTable]$unused   = @{};
ForEach($vol In $vols){
   If(-Not($volumes.ContainsKey($vol.name))){
      [HashTable]$volumes.Add($vol.name, $vol.VolumeExportAttributes.Policy)
   }
}
ForEach($q In $qt){
   If(-Not($qtrees.ContainsKey($("/" + $q.Volume + "/" + $q.name)))){
      [HashTable]$qtrees.Add($("/" + $q.Volume + "/" + $q.Qtree), $q.ExportPolicy)
   }
}
ForEach($p In $ep){
   If(-Not($policies.ContainsKey($p.PolicyName))){
      [HashTable]$policies.Add($p.PolicyName, $p.Vserver)
   }
}
ForEach($key In $volumes.Keys){
   If(-Not($used.ContainsKey($volumes[$key]))){
      [HashTable]$used.Add($volumes[$key], "")
   }
}
ForEach($key In $qtrees.Keys){
   If(-Not($used.ContainsKey($qtrees[$key]))){
      [HashTable]$used.Add($qtrees[$key], "")
   }
}
ForEach($key In $policies.Keys){
   If(-Not($used.ContainsKey($key))){
      [HashTable]$unused.Add($key, "")
   }
}
Write-Host "Volumes`:"
$volumes
Write-Host ""
Write-Host "Qtree`:"
Write-Host ""
$qtrees
Write-Host ""
Write-Host "Export Policies`:"
Write-Host ""
$policies
Write-Host ""
Write-Host "Used Export Policies"
Write-Host ""
$used.Keys
Write-Host ""
Write-Host "Unused Export Policies"
Write-Host ""
$unused.Keys

That worked fine in my lab, i tested modifying export policies on volumes and qtrees and the results were what i expected showing the used and unused export policies per vserver.

/Matt