Problem with "New-WebServiceProxy"
-
7. března 2012 20:40
I've been trying to extract data out of SQL Services Reporting Service (SSRS) through SOAP calls using 'New-WebServiceProxy' and it is not going well.
The code I am running is what you see here:
All strings (above) modified to fit my local environment, but sanitized for posting this thread on the Internet.$reportServerURI = "http://<SERVER>/ReportServer/ReportExecution2005.asmx?WSDL";
$RS = New-WebServiceProxy -Class 'RS' -NameSpace 'RS' -Uri $reportServerURI -Credential (Get-Credential);
$RS.Url = $reportServerURI;$reportPath = "/PathTo/Report";
$Report = $RS.GetType().GetMethod("LoadReport").Invoke($RS, @($reportPath, $null));
Code taken from: http://stackoverflow.com/questions/4196523/render-ssrs-report-with-parameters-using-soap-in-powershell
The code dies on the last line and complains that there is no method called "LoadReport". Sure enough, running "$RS | GM" returns lots of methods and properties, but "LoadReport" is not among them. I've seen this code and variations of it all over the Internet dating back to April of 2010. No one else has complained of missing the method called "LoadReport".
What gives? Do I have an out of date library on my system? Was "LoadReport" deprecated in a recent patch?
Všechny reakce
-
8. března 2012 3:27What does $RS | Gm show?
-
8. března 2012 12:30
Will,
Thank you for getting involved.
PS C:\> $RS | GM TypeName: Microsoft.PowerShell.Commands.NewWebserviceProxy.AutogeneratedTypes.WebServiceProxy1 erver__ReportService_asmx_wsdl.ReportingService Name MemberType Definition ---- ---------- ---------- CancelBatchCompleted Event Microsoft.PowerShell.Commands.NewWebse... CancelJobCompleted Event Microsoft.PowerShell.Commands.NewWebse... CreateBatchCompleted Event Microsoft.PowerShell.Commands.NewWebse... CreateDataDrivenSubscriptionCompleted Event Microsoft.PowerShell.Commands.NewWebse... CreateDataSourceCompleted Event Microsoft.PowerShell.Commands.NewWebse... CreateFolderCompleted Event Microsoft.PowerShell.Commands.NewWebse... CreateLinkedReportCompleted Event Microsoft.PowerShell.Commands.NewWebse... CreateReportCompleted Event Microsoft.PowerShell.Commands.NewWebse... CreateReportHistorySnapshotCompleted Event Microsoft.PowerShell.Commands.NewWebse... CreateResourceCompleted Event Microsoft.PowerShell.Commands.NewWebse... CreateRoleCompleted Event Microsoft.PowerShell.Commands.NewWebse... CreateScheduleCompleted Event Microsoft.PowerShell.Commands.NewWebse... CreateSubscriptionCompleted Event Microsoft.PowerShell.Commands.NewWebse... DeleteItemCompleted Event Microsoft.PowerShell.Commands.NewWebse... DeleteReportHistorySnapshotCompleted Event Microsoft.PowerShell.Commands.NewWebse... DeleteRoleCompleted Event Microsoft.PowerShell.Commands.NewWebse... DeleteScheduleCompleted Event Microsoft.PowerShell.Commands.NewWebse... DeleteSubscriptionCompleted Event Microsoft.PowerShell.Commands.NewWebse... DisableDataSourceCompleted Event Microsoft.PowerShell.Commands.NewWebse... Disposed Event System.EventHandler Disposed(System.Ob... EnableDataSourceCompleted Event Microsoft.PowerShell.Commands.NewWebse... ExecuteBatchCompleted Event Microsoft.PowerShell.Commands.NewWebse... FindItemsCompleted Event Microsoft.PowerShell.Commands.NewWebse... FireEventCompleted Event Microsoft.PowerShell.Commands.NewWebse... FlushCacheCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetCacheOptionsCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetDataDrivenSubscriptionPropertiesCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetDataSourceContentsCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetExecutionOptionsCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetExtensionSettingsCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetItemTypeCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetPermissionsCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetPoliciesCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetPropertiesCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetRenderResourceCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetReportDataSourcePromptsCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetReportDataSourcesCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetReportDefinitionCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetReportHistoryLimitCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetReportHistoryOptionsCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetReportLinkCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetReportParametersCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetResourceContentsCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetRolePropertiesCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetSchedulePropertiesCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetSubscriptionPropertiesCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetSystemPermissionsCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetSystemPoliciesCompleted Event Microsoft.PowerShell.Commands.NewWebse... GetSystemPropertiesCompleted Event Microsoft.PowerShell.Commands.NewWebse... InheritParentSecurityCompleted Event Microsoft.PowerShell.Commands.NewWebse... ListChildrenCompleted Event Microsoft.PowerShell.Commands.NewWebse... ListEventsCompleted Event Microsoft.PowerShell.Commands.NewWebse... ListExtensionsCompleted Event Microsoft.PowerShell.Commands.NewWebse... ListJobsCompleted Event Microsoft.PowerShell.Commands.NewWebse... ListLinkedReportsCompleted Event Microsoft.PowerShell.Commands.NewWebse... ListReportHistoryCompleted Event Microsoft.PowerShell.Commands.NewWebse... ListReportsUsingDataSourceCompleted Event Microsoft.PowerShell.Commands.NewWebse... ListRolesCompleted Event Microsoft.PowerShell.Commands.NewWebse... ListScheduledReportsCompleted Event Microsoft.PowerShell.Commands.NewWebse... ListSchedulesCompleted Event Microsoft.PowerShell.Commands.NewWebse... ListSecureMethodsCompleted Event Microsoft.PowerShell.Commands.NewWebse... ListSubscriptionsCompleted Event Microsoft.PowerShell.Commands.NewWebse... ListSubscriptionsUsingDataSourceCompleted Event Microsoft.PowerShell.Commands.NewWebse... ListSystemRolesCompleted Event Microsoft.PowerShell.Commands.NewWebse... ListSystemTasksCompleted Event Microsoft.PowerShell.Commands.NewWebse... ListTasksCompleted Event Microsoft.PowerShell.Commands.NewWebse... LogoffCompleted Event Microsoft.PowerShell.Commands.NewWebse... LogonUserCompleted Event Microsoft.PowerShell.Commands.NewWebse... MoveItemCompleted Event Microsoft.PowerShell.Commands.NewWebse... PauseScheduleCompleted Event Microsoft.PowerShell.Commands.NewWebse... PrepareQueryCompleted Event Microsoft.PowerShell.Commands.NewWebse... RenderCompleted Event Microsoft.PowerShell.Commands.NewWebse... RenderStreamCompleted Event Microsoft.PowerShell.Commands.NewWebse... ResumeScheduleCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetCacheOptionsCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetDataDrivenSubscriptionPropertiesCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetDataSourceContentsCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetExecutionOptionsCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetPoliciesCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetPropertiesCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetReportDataSourcesCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetReportDefinitionCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetReportHistoryLimitCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetReportHistoryOptionsCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetReportLinkCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetReportParametersCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetResourceContentsCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetRolePropertiesCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetSchedulePropertiesCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetSubscriptionPropertiesCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetSystemPoliciesCompleted Event Microsoft.PowerShell.Commands.NewWebse... SetSystemPropertiesCompleted Event Microsoft.PowerShell.Commands.NewWebse... UpdateReportExecutionSnapshotCompleted Event Microsoft.PowerShell.Commands.NewWebse... ValidateExtensionSettingsCompleted Event Microsoft.PowerShell.Commands.NewWebse... Abort Method System.Void Abort() BeginCancelBatch Method System.IAsyncResult BeginCancelBatch(S... BeginCancelJob Method System.IAsyncResult BeginCancelJob(str... BeginCreateBatch Method System.IAsyncResult BeginCreateBatch(S... BeginCreateDataDrivenSubscription Method System.IAsyncResult BeginCreateDataDri... BeginCreateDataSource Method System.IAsyncResult BeginCreateDataSou... BeginCreateFolder Method System.IAsyncResult BeginCreateFolder(... BeginCreateLinkedReport Method System.IAsyncResult BeginCreateLinkedR... BeginCreateReport Method System.IAsyncResult BeginCreateReport(... BeginCreateReportHistorySnapshot Method System.IAsyncResult BeginCreateReportH... BeginCreateResource Method System.IAsyncResult BeginCreateResourc... BeginCreateRole Method System.IAsyncResult BeginCreateRole(st... BeginCreateSchedule Method System.IAsyncResult BeginCreateSchedul... BeginCreateSubscription Method System.IAsyncResult BeginCreateSubscri... BeginDeleteItem Method System.IAsyncResult BeginDeleteItem(st... BeginDeleteReportHistorySnapshot Method System.IAsyncResult BeginDeleteReportH... BeginDeleteRole Method System.IAsyncResult BeginDeleteRole(st... BeginDeleteSchedule Method System.IAsyncResult BeginDeleteSchedul... BeginDeleteSubscription Method System.IAsyncResult BeginDeleteSubscri... BeginDisableDataSource Method System.IAsyncResult BeginDisableDataSo... BeginEnableDataSource Method System.IAsyncResult BeginEnableDataSou... BeginExecuteBatch Method System.IAsyncResult BeginExecuteBatch(... BeginFindItems Method System.IAsyncResult BeginFindItems(str... BeginFireEvent Method System.IAsyncResult BeginFireEvent(str... BeginFlushCache Method System.IAsyncResult BeginFlushCache(st... BeginGetCacheOptions Method System.IAsyncResult BeginGetCacheOptio... BeginGetDataDrivenSubscriptionProperties Method System.IAsyncResult BeginGetDataDriven... BeginGetDataSourceContents Method System.IAsyncResult BeginGetDataSource... BeginGetExecutionOptions Method System.IAsyncResult BeginGetExecutionO... BeginGetExtensionSettings Method System.IAsyncResult BeginGetExtensionS... BeginGetItemType Method System.IAsyncResult BeginGetItemType(s... BeginGetPermissions Method System.IAsyncResult BeginGetPermission... BeginGetPolicies Method System.IAsyncResult BeginGetPolicies(s... BeginGetProperties Method System.IAsyncResult BeginGetProperties... BeginGetRenderResource Method System.IAsyncResult BeginGetRenderReso... BeginGetReportDataSourcePrompts Method System.IAsyncResult BeginGetReportData... BeginGetReportDataSources Method System.IAsyncResult BeginGetReportData... BeginGetReportDefinition Method System.IAsyncResult BeginGetReportDefi... BeginGetReportHistoryLimit Method System.IAsyncResult BeginGetReportHist... BeginGetReportHistoryOptions Method System.IAsyncResult BeginGetReportHist... BeginGetReportLink Method System.IAsyncResult BeginGetReportLink... BeginGetReportParameters Method System.IAsyncResult BeginGetReportPara... BeginGetResourceContents Method System.IAsyncResult BeginGetResourceCo... BeginGetRoleProperties Method System.IAsyncResult BeginGetRoleProper... BeginGetScheduleProperties Method System.IAsyncResult BeginGetSchedulePr... BeginGetSubscriptionProperties Method System.IAsyncResult BeginGetSubscripti... BeginGetSystemPermissions Method System.IAsyncResult BeginGetSystemPerm... BeginGetSystemPolicies Method System.IAsyncResult BeginGetSystemPoli... BeginGetSystemProperties Method System.IAsyncResult BeginGetSystemProp... BeginInheritParentSecurity Method System.IAsyncResult BeginInheritParent... BeginListChildren Method System.IAsyncResult BeginListChildren(... BeginListEvents Method System.IAsyncResult BeginListEvents(Sy... BeginListExtensions Method System.IAsyncResult BeginListExtension... BeginListJobs Method System.IAsyncResult BeginListJobs(Syst... BeginListLinkedReports Method System.IAsyncResult BeginListLinkedRep... BeginListReportHistory Method System.IAsyncResult BeginListReportHis... BeginListReportsUsingDataSource Method System.IAsyncResult BeginListReportsUs... BeginListRoles Method System.IAsyncResult BeginListRoles(Sys... BeginListScheduledReports Method System.IAsyncResult BeginListScheduled... BeginListSchedules Method System.IAsyncResult BeginListSchedules... BeginListSecureMethods Method System.IAsyncResult BeginListSecureMet... BeginListSubscriptions Method System.IAsyncResult BeginListSubscript... BeginListSubscriptionsUsingDataSource Method System.IAsyncResult BeginListSubscript... BeginListSystemRoles Method System.IAsyncResult BeginListSystemRol... BeginListSystemTasks Method System.IAsyncResult BeginListSystemTas... BeginListTasks Method System.IAsyncResult BeginListTasks(Sys... BeginLogoff Method System.IAsyncResult BeginLogoff(System... BeginLogonUser Method System.IAsyncResult BeginLogonUser(str... BeginMoveItem Method System.IAsyncResult BeginMoveItem(stri... BeginPauseSchedule Method System.IAsyncResult BeginPauseSchedule... BeginPrepareQuery Method System.IAsyncResult BeginPrepareQuery(... BeginRender Method System.IAsyncResult BeginRender(string... BeginRenderStream Method System.IAsyncResult BeginRenderStream(... BeginResumeSchedule Method System.IAsyncResult BeginResumeSchedul... BeginSetCacheOptions Method System.IAsyncResult BeginSetCacheOptio... BeginSetDataDrivenSubscriptionProperties Method System.IAsyncResult BeginSetDataDriven... BeginSetDataSourceContents Method System.IAsyncResult BeginSetDataSource... BeginSetExecutionOptions Method System.IAsyncResult BeginSetExecutionO... BeginSetPolicies Method System.IAsyncResult BeginSetPolicies(s... BeginSetProperties Method System.IAsyncResult BeginSetProperties... BeginSetReportDataSources Method System.IAsyncResult BeginSetReportData... BeginSetReportDefinition Method System.IAsyncResult BeginSetReportDefi... BeginSetReportHistoryLimit Method System.IAsyncResult BeginSetReportHist... BeginSetReportHistoryOptions Method System.IAsyncResult BeginSetReportHist... BeginSetReportLink Method System.IAsyncResult BeginSetReportLink... BeginSetReportParameters Method System.IAsyncResult BeginSetReportPara... BeginSetResourceContents Method System.IAsyncResult BeginSetResourceCo... BeginSetRoleProperties Method System.IAsyncResult BeginSetRoleProper... BeginSetScheduleProperties Method System.IAsyncResult BeginSetSchedulePr... BeginSetSubscriptionProperties Method System.IAsyncResult BeginSetSubscripti... BeginSetSystemPolicies Method System.IAsyncResult BeginSetSystemPoli... BeginSetSystemProperties Method System.IAsyncResult BeginSetSystemProp... BeginUpdateReportExecutionSnapshot Method System.IAsyncResult BeginUpdateReportE... BeginValidateExtensionSettings Method System.IAsyncResult BeginValidateExten... CancelAsync Method System.Void CancelAsync(System.Object ... CancelBatch Method System.Void CancelBatch() CancelBatchAsync Method System.Void CancelBatchAsync(), System... CancelJob Method bool CancelJob(string JobID) CancelJobAsync Method System.Void CancelJobAsync(string JobI... CreateBatch Method string CreateBatch() CreateBatchAsync Method System.Void CreateBatchAsync(), System... CreateDataDrivenSubscription Method string CreateDataDrivenSubscription(st... CreateDataDrivenSubscriptionAsync Method System.Void CreateDataDrivenSubscripti... CreateDataSource Method System.Void CreateDataSource(string Da... CreateDataSourceAsync Method System.Void CreateDataSourceAsync(stri... CreateFolder Method System.Void CreateFolder(string Folder... CreateFolderAsync Method System.Void CreateFolderAsync(string F... CreateLinkedReport Method System.Void CreateLinkedReport(string ... CreateLinkedReportAsync Method System.Void CreateLinkedReportAsync(st... CreateObjRef Method System.Runtime.Remoting.ObjRef CreateO... CreateReport Method Microsoft.PowerShell.Commands.NewWebse... CreateReportAsync Method System.Void CreateReportAsync(string R... CreateReportHistorySnapshot Method string CreateReportHistorySnapshot(str... CreateReportHistorySnapshotAsync Method System.Void CreateReportHistorySnapsho... CreateResource Method System.Void CreateResource(string Reso... CreateResourceAsync Method System.Void CreateResourceAsync(string... CreateRole Method System.Void CreateRole(string Name, st... CreateRoleAsync Method System.Void CreateRoleAsync(string Nam... CreateSchedule Method string CreateSchedule(string Name, Mic... CreateScheduleAsync Method System.Void CreateScheduleAsync(string... CreateSubscription Method string CreateSubscription(string Repor... CreateSubscriptionAsync Method System.Void CreateSubscriptionAsync(st... DeleteItem Method System.Void DeleteItem(string Item) DeleteItemAsync Method System.Void DeleteItemAsync(string Ite... DeleteReportHistorySnapshot Method System.Void DeleteReportHistorySnapsho... DeleteReportHistorySnapshotAsync Method System.Void DeleteReportHistorySnapsho... DeleteRole Method System.Void DeleteRole(string Name) DeleteRoleAsync Method System.Void DeleteRoleAsync(string Nam... DeleteSchedule Method System.Void DeleteSchedule(string Sche... DeleteScheduleAsync Method System.Void DeleteScheduleAsync(string... DeleteSubscription Method System.Void DeleteSubscription(string ... DeleteSubscriptionAsync Method System.Void DeleteSubscriptionAsync(st... DisableDataSource Method System.Void DisableDataSource(string D... DisableDataSourceAsync Method System.Void DisableDataSourceAsync(str... Discover Method System.Void Discover() Dispose Method System.Void Dispose() EnableDataSource Method System.Void EnableDataSource(string Da... EnableDataSourceAsync Method System.Void EnableDataSourceAsync(stri... EndCancelBatch Method System.Void EndCancelBatch(System.IAsy... EndCancelJob Method bool EndCancelJob(System.IAsyncResult ... EndCreateBatch Method string EndCreateBatch(System.IAsyncRes... EndCreateDataDrivenSubscription Method string EndCreateDataDrivenSubscription... EndCreateDataSource Method System.Void EndCreateDataSource(System... EndCreateFolder Method System.Void EndCreateFolder(System.IAs... EndCreateLinkedReport Method System.Void EndCreateLinkedReport(Syst... EndCreateReport Method Microsoft.PowerShell.Commands.NewWebse... EndCreateReportHistorySnapshot Method string EndCreateReportHistorySnapshot(... EndCreateResource Method System.Void EndCreateResource(System.I... EndCreateRole Method System.Void EndCreateRole(System.IAsyn... EndCreateSchedule Method string EndCreateSchedule(System.IAsync... EndCreateSubscription Method string EndCreateSubscription(System.IA... EndDeleteItem Method System.Void EndDeleteItem(System.IAsyn... EndDeleteReportHistorySnapshot Method System.Void EndDeleteReportHistorySnap... EndDeleteRole Method System.Void EndDeleteRole(System.IAsyn... EndDeleteSchedule Method System.Void EndDeleteSchedule(System.I... EndDeleteSubscription Method System.Void EndDeleteSubscription(Syst... EndDisableDataSource Method System.Void EndDisableDataSource(Syste... EndEnableDataSource Method System.Void EndEnableDataSource(System... EndExecuteBatch Method System.Void EndExecuteBatch(System.IAs... EndFindItems Method Microsoft.PowerShell.Commands.NewWebse... EndFireEvent Method System.Void EndFireEvent(System.IAsync... EndFlushCache Method System.Void EndFlushCache(System.IAsyn... EndGetCacheOptions Method bool EndGetCacheOptions(System.IAsyncR... EndGetDataDrivenSubscriptionProperties Method string EndGetDataDrivenSubscriptionPro... EndGetDataSourceContents Method Microsoft.PowerShell.Commands.NewWebse... EndGetExecutionOptions Method Microsoft.PowerShell.Commands.NewWebse... EndGetExtensionSettings Method Microsoft.PowerShell.Commands.NewWebse... EndGetItemType Method Microsoft.PowerShell.Commands.NewWebse... EndGetPermissions Method string[] EndGetPermissions(System.IAsy... EndGetPolicies Method Microsoft.PowerShell.Commands.NewWebse... EndGetProperties Method Microsoft.PowerShell.Commands.NewWebse... EndGetRenderResource Method byte[] EndGetRenderResource(System.IAs... EndGetReportDataSourcePrompts Method Microsoft.PowerShell.Commands.NewWebse... EndGetReportDataSources Method Microsoft.PowerShell.Commands.NewWebse... EndGetReportDefinition Method byte[] EndGetReportDefinition(System.I... EndGetReportHistoryLimit Method int EndGetReportHistoryLimit(System.IA... EndGetReportHistoryOptions Method bool EndGetReportHistoryOptions(System... EndGetReportLink Method string EndGetReportLink(System.IAsyncR... EndGetReportParameters Method Microsoft.PowerShell.Commands.NewWebse... EndGetResourceContents Method byte[] EndGetResourceContents(System.I... EndGetRoleProperties Method Microsoft.PowerShell.Commands.NewWebse... EndGetScheduleProperties Method Microsoft.PowerShell.Commands.NewWebse... EndGetSubscriptionProperties Method string EndGetSubscriptionProperties(Sy... EndGetSystemPermissions Method string[] EndGetSystemPermissions(Syste... EndGetSystemPolicies Method Microsoft.PowerShell.Commands.NewWebse... EndGetSystemProperties Method Microsoft.PowerShell.Commands.NewWebse... EndInheritParentSecurity Method System.Void EndInheritParentSecurity(S... EndListChildren Method Microsoft.PowerShell.Commands.NewWebse... EndListEvents Method Microsoft.PowerShell.Commands.NewWebse... EndListExtensions Method Microsoft.PowerShell.Commands.NewWebse... EndListJobs Method Microsoft.PowerShell.Commands.NewWebse... EndListLinkedReports Method Microsoft.PowerShell.Commands.NewWebse... EndListReportHistory Method Microsoft.PowerShell.Commands.NewWebse... EndListReportsUsingDataSource Method Microsoft.PowerShell.Commands.NewWebse... EndListRoles Method Microsoft.PowerShell.Commands.NewWebse... EndListScheduledReports Method Microsoft.PowerShell.Commands.NewWebse... EndListSchedules Method Microsoft.PowerShell.Commands.NewWebse... EndListSecureMethods Method string[] EndListSecureMethods(System.I... EndListSubscriptions Method Microsoft.PowerShell.Commands.NewWebse... EndListSubscriptionsUsingDataSource Method Microsoft.PowerShell.Commands.NewWebse... EndListSystemRoles Method Microsoft.PowerShell.Commands.NewWebse... EndListSystemTasks Method Microsoft.PowerShell.Commands.NewWebse... EndListTasks Method Microsoft.PowerShell.Commands.NewWebse... EndLogoff Method System.Void EndLogoff(System.IAsyncRes... EndLogonUser Method System.Void EndLogonUser(System.IAsync... EndMoveItem Method System.Void EndMoveItem(System.IAsyncR... EndPauseSchedule Method System.Void EndPauseSchedule(System.IA... EndPrepareQuery Method Microsoft.PowerShell.Commands.NewWebse... EndRender Method byte[] EndRender(System.IAsyncResult a... EndRenderStream Method byte[] EndRenderStream(System.IAsyncRe... EndResumeSchedule Method System.Void EndResumeSchedule(System.I... EndSetCacheOptions Method System.Void EndSetCacheOptions(System.... EndSetDataDrivenSubscriptionProperties Method System.Void EndSetDataDrivenSubscripti... EndSetDataSourceContents Method System.Void EndSetDataSourceContents(S... EndSetExecutionOptions Method System.Void EndSetExecutionOptions(Sys... EndSetPolicies Method System.Void EndSetPolicies(System.IAsy... EndSetProperties Method System.Void EndSetProperties(System.IA... EndSetReportDataSources Method System.Void EndSetReportDataSources(Sy... EndSetReportDefinition Method Microsoft.PowerShell.Commands.NewWebse... EndSetReportHistoryLimit Method System.Void EndSetReportHistoryLimit(S... EndSetReportHistoryOptions Method System.Void EndSetReportHistoryOptions... EndSetReportLink Method System.Void EndSetReportLink(System.IA... EndSetReportParameters Method System.Void EndSetReportParameters(Sys... EndSetResourceContents Method System.Void EndSetResourceContents(Sys... EndSetRoleProperties Method System.Void EndSetRoleProperties(Syste... EndSetScheduleProperties Method System.Void EndSetScheduleProperties(S... EndSetSubscriptionProperties Method System.Void EndSetSubscriptionProperti... EndSetSystemPolicies Method System.Void EndSetSystemPolicies(Syste... EndSetSystemProperties Method System.Void EndSetSystemProperties(Sys... EndUpdateReportExecutionSnapshot Method System.Void EndUpdateReportExecutionSn... EndValidateExtensionSettings Method Microsoft.PowerShell.Commands.NewWebse... Equals Method bool Equals(System.Object obj) ExecuteBatch Method System.Void ExecuteBatch() ExecuteBatchAsync Method System.Void ExecuteBatchAsync(), Syste... FindItems Method Microsoft.PowerShell.Commands.NewWebse... FindItemsAsync Method System.Void FindItemsAsync(string Fold... FireEvent Method System.Void FireEvent(string EventType... FireEventAsync Method System.Void FireEventAsync(string Even... FlushCache Method System.Void FlushCache(string Report) FlushCacheAsync Method System.Void FlushCacheAsync(string Rep... GetCacheOptions Method bool GetCacheOptions(string Report, Mi... GetCacheOptionsAsync Method System.Void GetCacheOptionsAsync(strin... GetDataDrivenSubscriptionProperties Method string GetDataDrivenSubscriptionProper... GetDataDrivenSubscriptionPropertiesAsync Method System.Void GetDataDrivenSubscriptionP... GetDataSourceContents Method Microsoft.PowerShell.Commands.NewWebse... GetDataSourceContentsAsync Method System.Void GetDataSourceContentsAsync... GetExecutionOptions Method Microsoft.PowerShell.Commands.NewWebse... GetExecutionOptionsAsync Method System.Void GetExecutionOptionsAsync(s... GetExtensionSettings Method Microsoft.PowerShell.Commands.NewWebse... GetExtensionSettingsAsync Method System.Void GetExtensionSettingsAsync(... GetHashCode Method int GetHashCode() GetItemType Method Microsoft.PowerShell.Commands.NewWebse... GetItemTypeAsync Method System.Void GetItemTypeAsync(string It... GetLifetimeService Method System.Object GetLifetimeService() GetPermissions Method string[] GetPermissions(string Item) GetPermissionsAsync Method System.Void GetPermissionsAsync(string... GetPolicies Method Microsoft.PowerShell.Commands.NewWebse... GetPoliciesAsync Method System.Void GetPoliciesAsync(string It... GetProperties Method Microsoft.PowerShell.Commands.NewWebse... GetPropertiesAsync Method System.Void GetPropertiesAsync(string ... GetRenderResource Method byte[] GetRenderResource(string Format... GetRenderResourceAsync Method System.Void GetRenderResourceAsync(str... GetReportDataSourcePrompts Method Microsoft.PowerShell.Commands.NewWebse... GetReportDataSourcePromptsAsync Method System.Void GetReportDataSourcePrompts... GetReportDataSources Method Microsoft.PowerShell.Commands.NewWebse... GetReportDataSourcesAsync Method System.Void GetReportDataSourcesAsync(... GetReportDefinition Method byte[] GetReportDefinition(string Report) GetReportDefinitionAsync Method System.Void GetReportDefinitionAsync(s... GetReportHistoryLimit Method int GetReportHistoryLimit(string Repor... GetReportHistoryLimitAsync Method System.Void GetReportHistoryLimitAsync... GetReportHistoryOptions Method bool GetReportHistoryOptions(string Re... GetReportHistoryOptionsAsync Method System.Void GetReportHistoryOptionsAsy... GetReportLink Method string GetReportLink(string Report) GetReportLinkAsync Method System.Void GetReportLinkAsync(string ... GetReportParameters Method Microsoft.PowerShell.Commands.NewWebse... GetReportParametersAsync Method System.Void GetReportParametersAsync(s... GetResourceContents Method byte[] GetResourceContents(string Reso... GetResourceContentsAsync Method System.Void GetResourceContentsAsync(s... GetRoleProperties Method Microsoft.PowerShell.Commands.NewWebse... GetRolePropertiesAsync Method System.Void GetRolePropertiesAsync(str... GetScheduleProperties Method Microsoft.PowerShell.Commands.NewWebse... GetSchedulePropertiesAsync Method System.Void GetSchedulePropertiesAsync... GetSubscriptionProperties Method string GetSubscriptionProperties(strin... GetSubscriptionPropertiesAsync Method System.Void GetSubscriptionPropertiesA... GetSystemPermissions Method string[] GetSystemPermissions() GetSystemPermissionsAsync Method System.Void GetSystemPermissionsAsync(... GetSystemPolicies Method Microsoft.PowerShell.Commands.NewWebse... GetSystemPoliciesAsync Method System.Void GetSystemPoliciesAsync(), ... GetSystemProperties Method Microsoft.PowerShell.Commands.NewWebse... GetSystemPropertiesAsync Method System.Void GetSystemPropertiesAsync(M... GetType Method type GetType() InheritParentSecurity Method System.Void InheritParentSecurity(stri... InheritParentSecurityAsync Method System.Void InheritParentSecurityAsync... InitializeLifetimeService Method System.Object InitializeLifetimeService() ListChildren Method Microsoft.PowerShell.Commands.NewWebse... ListChildrenAsync Method System.Void ListChildrenAsync(string I... ListEvents Method Microsoft.PowerShell.Commands.NewWebse... ListEventsAsync Method System.Void ListEventsAsync(), System.... ListExtensions Method Microsoft.PowerShell.Commands.NewWebse... ListExtensionsAsync Method System.Void ListExtensionsAsync(Micros... ListJobs Method Microsoft.PowerShell.Commands.NewWebse... ListJobsAsync Method System.Void ListJobsAsync(), System.Vo... ListLinkedReports Method Microsoft.PowerShell.Commands.NewWebse... ListLinkedReportsAsync Method System.Void ListLinkedReportsAsync(str... ListReportHistory Method Microsoft.PowerShell.Commands.NewWebse... ListReportHistoryAsync Method System.Void ListReportHistoryAsync(str... ListReportsUsingDataSource Method Microsoft.PowerShell.Commands.NewWebse... ListReportsUsingDataSourceAsync Method System.Void ListReportsUsingDataSource... ListRoles Method Microsoft.PowerShell.Commands.NewWebse... ListRolesAsync Method System.Void ListRolesAsync(), System.V... ListScheduledReports Method Microsoft.PowerShell.Commands.NewWebse... ListScheduledReportsAsync Method System.Void ListScheduledReportsAsync(... ListSchedules Method Microsoft.PowerShell.Commands.NewWebse... ListSchedulesAsync Method System.Void ListSchedulesAsync(), Syst... ListSecureMethods Method string[] ListSecureMethods() ListSecureMethodsAsync Method System.Void ListSecureMethodsAsync(), ... ListSubscriptions Method Microsoft.PowerShell.Commands.NewWebse... ListSubscriptionsAsync Method System.Void ListSubscriptionsAsync(str... ListSubscriptionsUsingDataSource Method Microsoft.PowerShell.Commands.NewWebse... ListSubscriptionsUsingDataSourceAsync Method System.Void ListSubscriptionsUsingData... ListSystemRoles Method Microsoft.PowerShell.Commands.NewWebse... ListSystemRolesAsync Method System.Void ListSystemRolesAsync(), Sy... ListSystemTasks Method Microsoft.PowerShell.Commands.NewWebse... ListSystemTasksAsync Method System.Void ListSystemTasksAsync(), Sy... ListTasks Method Microsoft.PowerShell.Commands.NewWebse... ListTasksAsync Method System.Void ListTasksAsync(), System.V... Logoff Method System.Void Logoff() LogoffAsync Method System.Void LogoffAsync(), System.Void... LogonUser Method System.Void LogonUser(string userName,... LogonUserAsync Method System.Void LogonUserAsync(string user... MoveItem Method System.Void MoveItem(string Item, stri... MoveItemAsync Method System.Void MoveItemAsync(string Item,... PauseSchedule Method System.Void PauseSchedule(string Sched... PauseScheduleAsync Method System.Void PauseScheduleAsync(string ... PrepareQuery Method Microsoft.PowerShell.Commands.NewWebse... PrepareQueryAsync Method System.Void PrepareQueryAsync(Microsof... Render Method byte[] Render(string Report, string Fo... RenderAsync Method System.Void RenderAsync(string Report,... RenderStream Method byte[] RenderStream(string Report, str... RenderStreamAsync Method System.Void RenderStreamAsync(string R... ResumeSchedule Method System.Void ResumeSchedule(string Sche... ResumeScheduleAsync Method System.Void ResumeScheduleAsync(string... SetCacheOptions Method System.Void SetCacheOptions(string Rep... SetCacheOptionsAsync Method System.Void SetCacheOptionsAsync(strin... SetDataDrivenSubscriptionProperties Method System.Void SetDataDrivenSubscriptionP... SetDataDrivenSubscriptionPropertiesAsync Method System.Void SetDataDrivenSubscriptionP... SetDataSourceContents Method System.Void SetDataSourceContents(stri... SetDataSourceContentsAsync Method System.Void SetDataSourceContentsAsync... SetExecutionOptions Method System.Void SetExecutionOptions(string... SetExecutionOptionsAsync Method System.Void SetExecutionOptionsAsync(s... SetPolicies Method System.Void SetPolicies(string Item, M... SetPoliciesAsync Method System.Void SetPoliciesAsync(string It... SetProperties Method System.Void SetProperties(string Item,... SetPropertiesAsync Method System.Void SetPropertiesAsync(string ... SetReportDataSources Method System.Void SetReportDataSources(strin... SetReportDataSourcesAsync Method System.Void SetReportDataSourcesAsync(... SetReportDefinition Method Microsoft.PowerShell.Commands.NewWebse... SetReportDefinitionAsync Method System.Void SetReportDefinitionAsync(s... SetReportHistoryLimit Method System.Void SetReportHistoryLimit(stri... SetReportHistoryLimitAsync Method System.Void SetReportHistoryLimitAsync... SetReportHistoryOptions Method System.Void SetReportHistoryOptions(st... SetReportHistoryOptionsAsync Method System.Void SetReportHistoryOptionsAsy... SetReportLink Method System.Void SetReportLink(string Repor... SetReportLinkAsync Method System.Void SetReportLinkAsync(string ... SetReportParameters Method System.Void SetReportParameters(string... SetReportParametersAsync Method System.Void SetReportParametersAsync(s... SetResourceContents Method System.Void SetResourceContents(string... SetResourceContentsAsync Method System.Void SetResourceContentsAsync(s... SetRoleProperties Method System.Void SetRoleProperties(string N... SetRolePropertiesAsync Method System.Void SetRolePropertiesAsync(str... SetScheduleProperties Method System.Void SetScheduleProperties(stri... SetSchedulePropertiesAsync Method System.Void SetSchedulePropertiesAsync... SetSubscriptionProperties Method System.Void SetSubscriptionProperties(... SetSubscriptionPropertiesAsync Method System.Void SetSubscriptionPropertiesA... SetSystemPolicies Method System.Void SetSystemPolicies(Microsof... SetSystemPoliciesAsync Method System.Void SetSystemPoliciesAsync(Mic... SetSystemProperties Method System.Void SetSystemProperties(Micros... SetSystemPropertiesAsync Method System.Void SetSystemPropertiesAsync(M... ToString Method string ToString() UpdateReportExecutionSnapshot Method System.Void UpdateReportExecutionSnaps... UpdateReportExecutionSnapshotAsync Method System.Void UpdateReportExecutionSnaps... ValidateExtensionSettings Method Microsoft.PowerShell.Commands.NewWebse... ValidateExtensionSettingsAsync Method System.Void ValidateExtensionSettingsA... AllowAutoRedirect Property System.Boolean AllowAutoRedirect {get;... BatchHeaderValue Property Microsoft.PowerShell.Commands.NewWebse... ClientCertificates Property System.Security.Cryptography.X509Certi... ConnectionGroupName Property System.String ConnectionGroupName {get... Container Property System.ComponentModel.IContainer Conta... CookieContainer Property System.Net.CookieContainer CookieConta... Credentials Property System.Net.ICredentials Credentials {g... EnableDecompression Property System.Boolean EnableDecompression {ge... ItemNamespaceHeaderValue Property Microsoft.PowerShell.Commands.NewWebse... PreAuthenticate Property System.Boolean PreAuthenticate {get;set;} Proxy Property System.Net.IWebProxy Proxy {get;set;} RequestEncoding Property System.Text.Encoding RequestEncoding {... ServerInfoHeaderValue Property Microsoft.PowerShell.Commands.NewWebse... SessionHeaderValue Property Microsoft.PowerShell.Commands.NewWebse... Site Property System.ComponentModel.ISite Site {get;... SoapVersion Property System.Web.Services.Protocols.SoapProt... Timeout Property System.Int32 Timeout {get;set;} UnsafeAuthenticatedConnectionSharing Property System.Boolean UnsafeAuthenticatedConn... Url Property System.String Url {get;set;} UseDefaultCredentials Property System.Boolean UseDefaultCredentials {... UserAgent Property System.String UserAgent {get;set;}
-
8. března 2012 14:16its powershell, step through it...$types = $rs.gettype()$types$methods = $types.getmethod() - might be getmethodS, either way, GM isyour friendalso if you type a method without the () you get the signature...$rs.gettype
Justin Rich
http://jrich523.wordpress.com
PowerShell V3 Guide (Technet)
Please remember to mark the replies as answers if they help and unmark them if they provide no help. -
8. března 2012 15:31
JRich,
I appreciate the attention you are giving my problem, but I am not struggling with the methods '.GetType()' and '.GetMethods()'.
Nothing is returned using the code below. The result is NULL.
$Types = $RS.GetType(); $Methods = $Types.GetMethod() ; $Methods | Where {$_.Name -iLike "*load*"} | FT -Property Name;
-
8. března 2012 15:37 well it sounds like the method you are looking for doesn’t exist... I don’tknow the product well enough to say, all I can say is use this technique todig in to it... or check the docs... maybe post in a sql reporting forum...not so much a powershell problem as it is a problem with knowledge of theweb service...sorry cant help more than that..
Justin Rich
http://jrich523.wordpress.com
PowerShell V3 Guide (Technet)
Please remember to mark the replies as answers if they help and unmark them if they provide no help.- Navržen jako odpověď Will Steele 8. března 2012 15:43
- Označen jako odpověď Yan Li_Microsoft Contingent Staff, Moderator 12. března 2012 1:58
-
8. března 2012 15:39 I'll second Justin. The Get-Member approach I listed, and, the technique Justin provided work to identify exactly what's available with the type(s) you loaded. If the method is not there this is not a PowerShell issue. Perhaps it's a different assembly. The Get-Member cmdlet works well once you have it loaded. The .GetType/GetMethod approach Justin uses shows you on a granular level what is available. Without a function there's nothing PowerShell can do to resolve this.
- Navržen jako odpověď Yan Li_Microsoft Contingent Staff, Moderator 12. března 2012 1:45
- Označen jako odpověď Yan Li_Microsoft Contingent Staff, Moderator 12. března 2012 1:58
.png)
