Functions/CatalogItems/Get-RsFolderContent.ps1
|
# Copyright (c) 2016 Microsoft Corporation. All Rights Reserved. # Licensed under the MIT License (MIT) function Get-RsFolderContent { <# .SYNOPSIS List all catalog items under a given path. .DESCRIPTION List all catalog items under a given path. .PARAMETER ReportServerUri Specify the Report Server URL to your SQL Server Reporting Services Instance. Has to be provided if proxy is not provided. .PARAMETER ReportServerCredentials Specify the credentials to use when connecting to your SQL Server Reporting Services Instance. .PARAMETER Proxy Report server proxy to use. Has to be provided if ReportServerUri is not provided. .PARAMETER RsFolder Path to folder on SSRS instance. .PARAMETER Recurse Recursively list subfolders with content. .EXAMPLE Get-RsFolderContent -ReportServerUri http://localhost/reportserver_sql2012 -RsFolder / Description ----------- List all items directly under the root of the named SSRS instance. .EXAMPLE Get-RsFolderContent -ReportServerUri http://localhost/ReportServer -RsFolder / -Recurse Description ----------- Lists all items directly under the root of the SSRS instance and recursively under all sub-folders. .EXAMPLE Get-RsFolderContent -ReportServerUri http://localhost/ReportServer -RsFolder '/SQL Server Performance Dashboard' | WHERE Name -Like Wait* | Out-RsCatalogItem -ReportServerUri http://localhost/ReportServer -Destination c:\SQLReports Description ----------- Downloads all catalog items from folder '/SQL Server Performance Dashboard' with a name that starts with 'Wait' to folder 'C:\SQLReports'. #> [cmdletbinding()] param( [string] $ReportServerUri = 'http://localhost/reportserver', [System.Management.Automation.PSCredential] $ReportServerCredentials, $Proxy, [Alias('Path')] [Parameter(Mandatory=$True,ValueFromPipeline = $true,ValueFromPipelinebyPropertyname = $true)] [string] $RsFolder, [switch] $Recurse ) process { if(-not $Proxy) { $Proxy = New-RSWebServiceProxy -ReportServerUri $ReportServerUri -Credentials $ReportServerCredentials } $Proxy.ListChildren($RsFolder, $Recurse) } } New-Alias -Name "Get-RsCatalogItems" -Value Get-RsFolderContent -Scope Global |