RubrikSecurityCloud

0.30

Toolkit/Public/Get-RscMssqlLiveMount.ps1

#Requires -Version 3
function Get-RscMssqlLiveMount {
    <#
    .SYNOPSIS
    Returns information about a Live Mounted MSSQL Database
 
    .DESCRIPTION
    Returns information about a Live Mounted MSSQL Database
 
    .LINK
    Schema reference:
    https://rubrikinc.github.io/rubrik-api-documentation/schema/reference
 
    .PARAMETER MountedDatabaseName
    Name of the database that was Live Mounted
     
    .PARAMETER MssqlDatabase
    Database object returned from Get-RscMssqlDatabase
 
    .EXAMPLE
    Returns the list of database files based on the latest recovery point
    $RscMssqlDatabase = Get-RscMssqlDatabase -Name AdventureWorks2019
    Get-RscMssqlLiveMount -RscMssqlDatabase $RscMssqlDatabase -MountedDatabaseName AdventureWorks2019_LiveMount
    #>
    [CmdletBinding()]
    Param(        
        [Parameter(
            Mandatory = $false, 
            ValueFromPipeline = $false
        )]
        [String]$MountedDatabaseName,

        [Parameter(
            Mandatory = $false, 
            ValueFromPipeline = $true
        )]
        [RubrikSecurityCloud.Types.MssqlDatabase]$RscMssqlDatabase
    )
    
    Process {
        Write-Debug "-Running Get-RscMssqlLiveMount"

        # Determine field profile:
        $fieldProfile = "DEFAULT"
        if ( $Detail -eq $true ) {
            $fieldProfile = "DETAIL"
        }
        Write-Host "Get-RscMssqlLiveMount field profile: $fieldProfile"
        
        #region Create Query
        $query = New-RscQueryMssql -Operation DatabaseLiveMounts `
            -AddField Nodes.MountedDatabaseName, `
                Nodes.CreationDate, `
                Nodes.RecoveryPoint #, `
                # Nodes.TargetInstance
                # Nodes.SourceDatabase
                # Nodes.Cluster #, `
                # Nodes.SourceDatabase #, `
                
        #endregion

        #region Filters
        $query.Var.filters = @()
        $nameFilter = New-Object -TypeName RubrikSecurityCloud.Types.MssqlDatabaseLiveMountFilterInput
        $nameFilter.Field = "MOUNTED_DATABASE_NAME"
        $nameFilter.texts = $MountedDatabaseName
        $query.Var.filters += $nameFilter

        If ( $PSBoundParameters.ContainsKey('MssqlDatabase') ) {
            $sourceDatabaseFilter = New-Object -TypeName RubrikSecurityCloud.Types.MssqlDatabaseLiveMountFilterInput
            $sourceDatabaseFilter.Field = "SOURCE_DATABASE_ID"
            $sourceDatabaseFilter.Texts = $RscMssqlDatabase.Id
            $query.Var.filters += $sourceDatabaseFilter
        }
        #endregion
        $result = $query.Invoke()
        $result.Nodes
    } 
}