Public/New-RubrikReport.ps1
|
#Requires -Version 3 function New-RubrikReport { <# .SYNOPSIS Connects to Rubrik to retrieve either daily or weekly task results .DESCRIPTION The New-RubrikReport cmdlet is used to retrieve all of the tasks that have been run by a Rubrik cluster. Use either 'daily' or 'weekly' for ReportType to define the reporting scope. .NOTES Written by Chris Wahl for community usage Twitter: @ChrisWahl GitHub: chriswahl .LINK https://github.com/rubrikinc/PowerShell-Module .EXAMPLE New-RubrikReport -ReportType daily -ToCSV This will gather all of the daily tasks from Rubrik and store them into a CSV file in the user's MyDocuments folder .EXAMPLE New-RubrikReport -ReportType weekly This will gather all of the daily tasks from Rubrik and display summary information on the console screen #> [CmdletBinding()] Param( [Parameter(Mandatory = $true,Position = 0,HelpMessage = 'Report Type (daily or weekly)')] [ValidateNotNullorEmpty()] [ValidateSet('daily', 'weekly')] [String]$ReportType, [Parameter(Mandatory = $false,Position = 1,HelpMessage = 'Status Type ')] [ValidateNotNullorEmpty()] [ValidateSet('Succeeded','Running','Failed','Canceled')] [String]$StatusType, [Parameter(Mandatory = $false,Position = 2,HelpMessage = 'Export the results to a CSV file')] [ValidateNotNullorEmpty()] [Switch]$ToCSV, [Parameter(Mandatory = $false,Position = 3,HelpMessage = 'Rubrik FQDN or IP address')] [ValidateNotNullorEmpty()] [String]$Server = $global:RubrikConnection.server ) Process { TestRubrikConnection Write-Verbose -Message 'Build the URI' $uri = 'https://'+$Server+'/report/backupJobs/detail' Write-Verbose -Message 'Build the body' $body = @{ reportType = $ReportType.ToLower() } Write-Verbose -Message 'Submit the request' try { $r = Invoke-WebRequest -Uri $uri -Headers $Header -Method Post -Body (ConvertTo-Json -InputObject $body) } catch { throw $_ } Write-Verbose -Message 'Convert JSON content to PSObject (Max 64MB)' [void][System.Reflection.Assembly]::LoadWithPartialName('System.Web.Extensions') $resultraw = ParseItem -jsonItem ((New-Object -TypeName System.Web.Script.Serialization.JavaScriptSerializer -Property @{ MaxJsonLength = 67108864 }).DeserializeObject($r.Content)) Write-Verbose -Message 'Counting unique status values' [array]$StatusCount = $result.status | Group-Object | Select-Object -Property Count, Name foreach ($_ in $StatusCount) { Write-Verbose -Message "$($_.name): $($_.count)" } Write-Verbose -Message 'Determining if status filter is required' if ($StatusType) { Write-Verbose -Message "Filtering based on $StatusType status" $result = $resultraw | Where-Object -FilterScript { $_.status -match $StatusType } } else { Write-Verbose -Message 'No status filter found' $result = $restulraw } Write-Verbose -Message 'Validating that results were found' if (!$result) { throw 'No results found' } if ($ToCSV) { Write-Verbose -Message 'Creating CSV' $CSVfilename = 'rubrik-tasks-export-'+(Get-Date).Ticks+'.csv' try { foreach ($record in $result) { $record | Export-Csv -Append -Path "$Home\Documents\$CSVfilename" -NoTypeInformation -Force } Write-Verbose -Message "CSV export written to $Home\Documents\$CSVfilename" -Verbose } catch { throw $_ } } return $result } # End of process } # End of function |