powershell - SSRS＆PowerShell:创建并设置报告时间表吗？

Question

有没有一种方法可以一键创建然后更改SSRS上文件夹中所有报告的计划？我有很多报告，我不知道一种方法，而是一步一步地做。

=======================================

编辑:8/30/18

我在创建时间表时遇到了一些麻烦(然后我仍然需要将其设置为所有报告):

$ScheduleDefinition = New-Object SSRS.ScheduleDefinition
$ScheduleDefinition.StartDateTime = [DateTime] "01/01/2018 12:00:00 AM"
$ScheduleDefinition.EndDate = [DateTime] "01/01/2050 12:00:00 AM"
$ScheduleDefinition.EndDateSpecified = "True"

$CreateSchedule = $ReportServerProxy.CreateSchedule("Report Schedule",$ScheduleDefinition,$null)

结果是:

Cannot convert argument "ScheduleDefinition", with value: "SSRS.ScheduleDefinition", for "CreateSchedule" to type "SSRS.ScheduleDefinition": "Cannot convert the "SSRS.ScheduleDefinition" value of type "SSRS.ScheduleDefinition" to type "SSRS.ScheduleDefinition"."

我如何建立联系:

$ReportServerUri = "http://localhost/reportserver/ReportService2010.asmx?wsdl"
$ReportServerProxy = New-WebServiceProxy -Uri $ReportServerUri -UseDefaultCredential -Namespace "SSRS"

Answer 1

创建计划表

您可以使用 CreateSchedule 函数创建共享时间表:

$svcUrl = 'http://your-server-name/ReportServer/reportservice2010.asmx'
$svc = New-WebServiceProxy -Class 'RS' -Namespace 'RS' -Uri $svcUrl -UseDefaultCredential

$definition = New-Object RS.ScheduleDefinition  
$scheduleID = ""
$definition.StartDateTime =  [DateTime] "01/01/2018 12:00:00 AM"
$recurrence = New-Object RS.DailyRecurrence
$recurrence.DaysInterval = 1
$definition.Item = $recurrence

$scheduleID = $svc.CreateSchedule("My Schedule",$definition, $null);

为文件夹中的所有报告设置历史记录快照计划

然后，您可以首先使用 ListChildren 函数获取所有报告。然后，对于每个报告，您可以使用 SetItemHistoryOptions 使用您在上一步中创建的共享计划来设置历史快照计划:

$sharedSchedule = New-Object RS.ScheduleReference
$sharedSchedule.ScheduleID = $scheduleID 
$reports = $svc.ListChildren("/", $true) | Where-Object { $_.TypeName -eq "Report" }
foreach ($report in $reports) {
    $svc.SetItemHistoryOptions($report.Path, $true, $true, $sharedSchedule)
}