scripting-and-powershell-with-reporting-services.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	ms.custom	helpviewer_keywords
Scripting and PowerShell with Reporting Services	Learn about the support for scripting and PowerShell cmdlets for SharePoint mode report servers in Reporting Services.	maggiesMSFT	maggies	09/14/2015	reporting-services	tools	conceptual	updatefrequency5	scripts [Reporting Services] Reporting Services, scripting scripting [Reporting Services]

Scripting and PowerShell with Reporting Services

[!INCLUDEssRSnoversion] supports a wide range of development and management scenarios through script. These scenarios include the rs.exe command line utility and PowerShell cmdlets for SharePoint mode report servers. You can also use the [!INCLUDEssRSnoversion] object model from PowerShell for both Native and SharePoint mode.

• Administrators can write script in [!INCLUDEmsCoName] [!INCLUDEvisual-basic] to automate how they deploy and manage a report server installation. Administrators can also generate and run [!INCLUDEtsql] scripts that create, configure, and update a report server database. Administrators can also use the record and playback script features in [!INCLUDEssNoVersion] [!INCLUDEssManStudio] to automate routine maintenance tasks.

• Developers can create custom applications that include script. You can run script that makes calls to the Report Server Web service. Almost any operation that you can write in managed code can also be written in script.

• The RS.exe utility, a script host running on the report server, processes [!INCLUDE[msCoName] (../../includes/msconame-md.md)] [!INCLUDEvisual-basic] .NET script as the supported script language in [!INCLUDEssRSnoversion]. `

Reporting Services SharePoint mode PowerShell cmdlets and samples

[!INCLUDEssRSnoversion] SharePoint mode includes [!INCLUDEssRSnoversion] cmdlets for report server administration.

• PowerShell cmdlets for Reporting Services SharePoint mode Includes the following examples:

  • Create a service application and proxy

  • Review and update a delivery extension

  • Get and set Properties of the Reporting Service Application Database, for example database timeout

  • List Data Extensions

Reporting Services object model and PowerShell samples

• Use PowerShell to change and list Reporting Services subscription owners and run a subscription.

• Use PowerShell to create an Azure VM With a native mode report server.

• See the section "Access the WMI classes by using PowerShell" in Access the Reporting Services WMI provider.

RS.exe scripting samples

• Sample Reporting Services rs.exe script to copy content between report servers.

• For more script, application, and extension examples, see SQL Server Reporting Services product samples.

Related content

RS.exe utility (SSRS)
Script deployment and administrative tasks
Script with the rs.exe utility and the web service