Public/Get-RubrikReportData.ps1

#requires -Version 3
function Get-RubrikReportData {
  <#
      .SYNOPSIS
      Retrieve table data for a specific Envision report

      .DESCRIPTION
      The Get-RubrikReportData cmdlet is used to pull table data from a specific Envision report

      .NOTES
      Written by Chris Wahl for community usage
      Twitter: @ChrisWahl
      GitHub: chriswahl

      .LINK
      https://rubrik.gitbook.io/rubrik-sdk-for-powershell/command-documentation/reference/get-rubrikreportdata

      .EXAMPLE
      Get-RubrikReport -Name 'SLA Compliance Summary' | Get-RubrikReportData
      
      This will return table data from the "SLA Compliance Summary" report

      .EXAMPLE
      Get-RubrikReport -Name 'SLA Compliance Summary' | Get-RubrikReportData -ComplianceStatus 'NonCompliance'
      
      This will return table data from the "SLA Compliance Summary" report when the compliance status is "NonCompliance"

      .EXAMPLE
      Get-RubrikReport -Name 'SLA Compliance Summary' | Get-RubrikReportData -ComplianceStatus 'NonCompliance' -Limit 10
      
      This will return table data from the "SLA Compliance Summary" report when the compliance status is "NonCompliance", only returns the first 10 results.

      .EXAMPLE
      Get-RubrikReport -Name 'Object Protection Summary' | Get-RubrikReportData -Limit -1
      
      This will return all of the table data from the "Object Protection Summary" report. Note: Using '-Limit -1' may affect performance for reports containing large amounts of data.

      .EXAMPLE
      (Get-RubrikReport -Name "System Capacity" | Get-RubrikReportData).DatagridObject | Format-Table

      This will return a human readable table view of the items within the System Capacity report.
  #>


  [CmdletBinding()]
  Param(
    # The ID of the report
    [Parameter(Mandatory = $true,ValueFromPipelineByPropertyName = $true)]
    [String]$id,
    # Search table data by object name
    [Alias('search_value')]
    [String]$Name,
    # Filter table data on task type
    [Alias('task_type')]
    [String]$TaskType,
    # Filter table data on task status
    [Alias('task_status')]
    [String]$TaskStatus,
    # Filter table data on object type
    [Alias('object_type')]
    [String]$ObjectType,
    # Filter table data on compliance status
    [Alias('compliance_status')]
    [ValidateSet('InCompliance','NonCompliance')]
    [String]$ComplianceStatus,
    #limit the number of rows returned, defaults to maximum pageSize of 9999. Use a value of '-1' to remove limit restrictions
    [int]$limit,
    #cursor start (if necessary)
    [string]$cursor,
    # Rubrik server IP or FQDN
    [String]$Server = $global:RubrikConnection.server,
    # API version
    [String]$api = $global:RubrikConnection.api
  )

  Begin {

    # The Begin section is used to perform one-time loads of data necessary to carry out the function's purpose
    # If a command needs to be run with each iteration or pipeline input, place it in the Process section

    # Check to ensure that a session to the Rubrik cluster exists and load the needed header data for authentication
    Test-RubrikConnection

    # API data references the name of the function
    # For convenience, that name is saved here to $function
    $function = $MyInvocation.MyCommand.Name

    # Retrieve all of the URI, method, body, query, result, filter, and success details for the API endpoint
    Write-Verbose -Message "Gather API Data for $function"
    $resources = Get-RubrikAPIData -endpoint $function
    Write-Verbose -Message "Load API data for $($resources.Function)"
    Write-Verbose -Message "Description: $($resources.Description)"

    # Set limit to default of 9999 if not set, both limit and psboundparameters are set, this is because New-BodyString builds the query using both variables
    if ($null -eq $PSBoundParameters.limit) {
      $PSBoundParameters.Add('limit',9999) | Out-Null
      $limit = 9999
    }

    if ($limit -eq -1) {
      # can change default limit to 100 to test reports which don't hit max limitS
      $limit = 150
      $returnAll = $true
    }

  }

  Process {

    $uri = New-URIString -server $Server -endpoint ($resources.URI) -id $id
    $uri = Test-QueryParam -querykeys ($resources.Query.Keys) -parameters ((Get-Command $function).Parameters.Values) -uri $uri
    $body = New-BodyString -bodykeys ($resources.Body.Keys) -parameters ((Get-Command $function).Parameters.Values)
    $result = Submit-Request -uri $uri -header $Header -method $($resources.Method) -body $body

    # if limit has been set to -1
    if ($returnAll -and $result.hasMore -eq 'true') {
      # duplicate response to save initial returned data
      $nextresult = $result
      $PSBoundParameters.Add('cursor',$nextresult.cursor)

      Write-Verbose -Message "Result limits hit. Retrieving remaining data based on pagination"
      $result.dataGrid +=
        do {
          $cursor = $nextresult.cursor
          $body = New-BodyString -bodykeys ($resources.Body.Keys) -parameters ((Get-Command $function).Parameters.Values)
          $nextresult = Submit-Request -uri $uri -header $Header -method $($resources.Method) -body $body
          $nextresult.dataGrid
          Write-Verbose $nextresult.hasMore
        } while ($nextresult.hasMore -eq 'true')
    }
    $result.hasMore = 'false'

    $result = $result | Select-Object -Property *,@{
      name = 'DatagridObject'
      expression = {
        $result.datagrid | ForEach-Object {
          $_ | ForEach-Object -Begin {
              $Count = 0
              $HashProps = [ordered]@{}
          } -Process {
              $HashProps.$($result.columns[$Count]) = $_
              $Count++
          } -End {
              [pscustomobject]$HashProps
          }
        }
      }
    }

    return $result

  } # End of process
} # End of function