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

title	Scripting and PowerShell with Reporting Services | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	reporting-services-native
ms.topic	conceptual
helpviewer_keywords	scripts [Reporting Services] Reporting Services, scripting scripting [Reporting Services]
ms.assetid	1ac2646d-ed5a-4436-b18f-2150c33f3d87
author	maggiesMSFT
ms.author	maggies
manager	kfile

Scripting and PowerShell with Reporting Services

[!INCLUDEssRSnoversion] supports a wide range of development and management scenarios through script, including the rs.exe command line utility, PowerShell cmdlets for SharePoint mode report servers, and leveraging the [!INCLUDEssRSnoversion] object model from PowerShell for both Native and SharePoint mode.

• Administrators can write script in [!INCLUDEmsCoName] [!INCLUDEvbprvb] 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.

• [!INCLUDEssRSnoversion] supports [!INCLUDEmsCoName] [!INCLUDEvbprvb] .NET script as the script language that can be processed by the RS.exe utility, a script host that runs on the report server.

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

PowerShell calling the core object model and for the most part valid for SharePoint and native mode, for example the migration work, subscription work, and more related samples for subscriptions work in SQL15.

• 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 using PowerShell" in Access the Reporting Services WMI Provider.

• How to Administer SSRS using PowerShell.scriptin

RS.exe scripting samples

• Sample Reporting Services rs.exe Script to Migrate Content between Report Servers.

• For additional script, application, and extension examples, see SQL Server Reporting Services Product Samples.

See Also

RS.exe Utility (SSRS) Script Deployment and Administrative Tasks Script with the rs.exe Utility and the Web Service