none
Problem with "New-WebServiceProxy"

    Dotaz

  • 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:

    $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));

    All strings (above) modified to fit my local environment, but sanitized for posting this thread on the Internet.
    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? 
    7. března 2012 20:40

Odpovědi

  • well it sounds like the method you are looking for doesn’t exist... I don’t
    know the product well enough to say, all I can say is use this technique to
    dig 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 the
    web 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.
    8. března 2012 15:37
  • 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.
    8. března 2012 15:39

Všechny reakce

  • What does $RS | Gm show?
    8. března 2012 3:27
  • 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 12:30
  • its powershell, step through it...
     
    $types = $rs.gettype()
    $types
    $methods = $types.getmethod()    - might be getmethodS, either way, GM is
    your friend
     
    also 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 14:16
  • 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:31
  • well it sounds like the method you are looking for doesn’t exist... I don’t
    know the product well enough to say, all I can say is use this technique to
    dig 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 the
    web 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.
    8. března 2012 15:37
  • 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.
    8. března 2012 15:39