Need to script out report subscriptions

Question

Need to script out report subscriptions

Marios Philippopoulos

SSC Guru

Points: 57190
More actions
June 17, 2011 at 1:49 pm

#242342

I'm trying to script out the report subscriptions in my report server, but I'm stuck.
Here is my unfinished script:
[void][System.Reflection.Assembly]::LoadWithPartialName("System.Xml.XmlDocument");
[void][System.Reflection.Assembly]::LoadWithPartialName("System.IO");
$ReportServerUri = "http://abdcef/ReportServer/ReportService2005.asmx";
$Proxy = New-WebServiceProxy -Uri $ReportServerUri -Namespace SSRS.ReportingService2005 -UseDefaultCredential ;
$items = $Proxy.ListChildren("/", $true) | `
select Type, Path, ID, Name | `
Where-Object {$_.type -eq "Report"};
foreach($item in $items)
{
$reportSubscription = $Proxy.<what method goes here>}
Can someone help me? Thanks
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Gary Varga SSC Guru Points: 82166 More actions · Answer 1

You might get some assistance if you specify what is and what is not working. Otherwise you are asking someone to do all of your job for you. I am sure that is not what you intended and are probably under pressure because of deadlines. So are most other people (including the ones prepared to help every now and again).

Regards,

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!

Marios Philippopoulos SSC Guru Points: 57190 More actions · Answer 2

I actually found a link that is quite relevant to what I am trying to do, which is to script out all report subscriptions and non-default execution settings and redeploy those on another report server:

http://www.codeproject.com/KB/reporting-services/DynamicSSRSSubscriptions.aspx

This seems like a lot of work and quite tricky. I'm tempted to just bite the bullet and do the copying manually instead of automating through a script. This is a one-time thing, so automating is not a priority. The amount of settings I need to copy is not too bad.

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]