Getting Statistics of Operations Execution

SOAP request:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">

<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<GetSvc xmlns="http://www.fsight.ru/PP.SOM.Som">

<tArg xmlns="">

<pattern>

<operationsStat>

<ids>

  <it>OpenMetabase</it>

  <it>CloseMetabase</it>

  <it>OpenPrx</it>

  <it>ClosePrx</it>

  <it>GetPrxMd</it>

  <it>SetPrxMd</it>

  </ids>

  </operationsStat>

  </pattern>

  </tArg>

  </GetSvc>

  </s:Body>

  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

<GetSvcResult xmlns="http://www.fsight.ru/PP.SOM.Som" xmlns:q1="http://www.fsight.ru/PP.SOM.Som" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<meta xmlns="">

<operationsStat>

<its>

<it>

  <id>OpenMetabase</id>

  <totalCount>1</totalCount>

  <faultsCount>0</faultsCount>

  <totalTime>2907</totalTime>

  <maxTime>2907</maxTime>

  <minTime>2907</minTime>

<longRequest>

<OpenMetabase xmlns="http://www.fsight.ru/PP.SOM.Som">

<tDef xmlns="">

  <id>WAREHOUSE</id>

  <n xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <k xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <scope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <locale xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <logonData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  </tDef>

<tCreds xmlns="">

<user>

  <id>sa</id>

  <domain xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  </user>

  <pass>Qwerty1</pass>

  <imperson xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <useMetabase xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <oauth xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <verifier xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <bin xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <useGuestCreds xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <userCertificate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  </tCreds>

<tArg xmlns="">

  <createNew xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <skipOpen xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <newPassword xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <sessCookie xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <passChangingWarnsAsErrors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  </tArg>

  </OpenMetabase>

  </longRequest>

  </it>

<it>

  <id>OpenPrx</id>

  <totalCount>1</totalCount>

  <faultsCount>0</faultsCount>

  <totalTime>1484</totalTime>

  <maxTime>1484</maxTime>

  <minTime>1484</minTime>

<longRequest>

<OpenPrx xmlns="http://www.fsight.ru/PP.SOM.Som">

<tObject xmlns="">

  <id>FOFEFHEKNAAMFOAEJACKCAIKHHBICCGEELKEKCLGIPHJKJLL!M!6334</id>

  </tObject>

<tArg xmlns="">

<args>

  <updateCache xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <args xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <bind xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <openForEdit xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  </args>

  <metaGet xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  </tArg>

  </OpenPrx>

  </longRequest>

  </it>

<it>

  <id>ClosePrx</id>

  <totalCount>1</totalCount>

  <faultsCount>0</faultsCount>

  <totalTime>16</totalTime>

  <maxTime>16</maxTime>

  <minTime>16</minTime>

<longRequest>

<ClosePrx xmlns="http://www.fsight.ru/PP.SOM.Som">

<tPrx xmlns="">

  <id>FOFEFHEKNAAMFOAEJACKCAIKHHBICCGEELKEKCLGIPHJKJLL!M!S!PLFNPHNEKNAAMFOAELCIPCFKNGHIADCGEHKCIHKLDKEPMCHBP</id>

  </tPrx>

  </ClosePrx>

  </longRequest>

  </it>

<it>

  <id>GetPrxMd</id>

  <totalCount>1</totalCount>

  <faultsCount>0</faultsCount>

  <totalTime>32</totalTime>

  <maxTime>32</maxTime>

  <minTime>32</minTime>

<longRequest>

<GetPrxMd xmlns="http://www.fsight.ru/PP.SOM.Som">

<tPrx xmlns="">

  <id>FOFEFHEKNAAMFOAEJACKCAIKHHBICCGEELKEKCLGIPHJKJLL!M!S!PLFNPHNEKNAAMFOAELCIPCFKNGHIADCGEHKCIHKLDKEPMCHBP</id>

  </tPrx>

<tArg xmlns="">

<pattern>

  <locale xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <names xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <descriptions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <effectiveRights xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <effectiveRightsSubj xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <fullUrl xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <obInst>true</obInst>

  <pars xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <parsControl xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <all xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

<sheet>

  <pageSettings>true</pageSettings>

  </sheet>

  <sheets>Get</sheets>

  <duplicateSheet xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <sheetsFilter xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <tableSources xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <tableSourcesFilter xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <dataSources xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <dataSourcesFilter xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <dataSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <slices xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <slicesFilter xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <dataIslands xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <dataIslandsFilter xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <tableIslands xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <tableIslandsFilter xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <controls xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <controlsFilter xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <control xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <undoRedo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <exportData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <drillCell xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <options xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <slicesDimensions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <isRecalced xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <updateHypelinks xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <objectAction xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <canGenWbk xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <genWbk xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <genProblem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <validations xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <diagnosticReport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <selectedGrid xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <dimAttrsNaming xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <changedCellsStyles xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <vizSelectionImpact xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <styleSheets xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <hasEventHandler xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <objDrillInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <dataArea xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <outOfRangeAfterRecalc xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  <attachments xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  </pattern>

  <refresh xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />

  </tArg>

  </GetPrxMd>

  </longRequest>

  </it>

  </its>

  </operationsStat>

  </meta>

  </GetSvcResult>

  </soapenv:Body>

  </soapenv:Envelope>

JSON request:

{
 "GetSvc" : 
  {
   "tArg" : 
    {
     "pattern" : 
      {
       "operationsStat" : 
        {
         "ids" : 
          {
           "it" : 
            [
              "OpenMetabase",
              "CloseMetabase",
              "OpenPrx",
              "ClosePrx",
              "GetPrxMd",
              "SetPrxMd"
            ]
          }
        }
      }
    }
  }
}

JSON response:

{
 "GetSvcResult" : 
  {
   "meta" : 
    {
     "operationsStat" : 
      {
       "its" : 
        {
         "it" : 
          [
            {
             "id" : "OpenMetabase",
             "totalCount" : "1",
             "faultsCount" : "0",
             "totalTime" : "2907",
             "maxTime" : "2907",
             "minTime" : "2907",
             "longRequest" : 
              {
               "OpenMetabase" : 
                {
                 "tDef" : 
                  {
                   "id" : "WAREHOUSE",
                   "n" : 
                    {
                     "@nil" : "true"
                    },
                   "k" : 
                    {
                     "@nil" : "true"
                    },
                   "scope" : 
                    {
                     "@nil" : "true"
                    },
                   "locale" : 
                    {
                     "@nil" : "true"
                    },
                   "logonData" : 
                    {
                     "@nil" : "true"
                    }
                  },
                 "tCreds" : 
                  {
                   "user" : 
                    {
                     "id" : "sa",
                     "domain" : 
                      {
                       "@nil" : "true"
                      }
                    },
                   "pass" : "Qwerty1",
                   "imperson" : 
                    {
                     "@nil" : "true"
                    },
                   "useMetabase" : 
                    {
                     "@nil" : "true"
                    },
                   "oauth" : 
                    {
                     "@nil" : "true"
                    },
                   "verifier" : 
                    {
                     "@nil" : "true"
                    },
                   "bin" : 
                    {
                     "@nil" : "true"
                    },
                   "useGuestCreds" : 
                    {
                     "@nil" : "true"
                    },
                   "userCertificate" : 
                    {
                     "@nil" : "true"
                    }
                  },
                 "tArg" : 
                  {
                   "createNew" : 
                    {
                     "@nil" : "true"
                    },
                   "skipOpen" : 
                    {
                     "@nil" : "true"
                    },
                   "newPassword" : 
                    {
                     "@nil" : "true"
                    },
                   "sessCookie" : 
                    {
                     "@nil" : "true"
                    },
                   "passChangingWarnsAsErrors" : 
                    {
                     "@nil" : "true"
                    }
                  }
                }
              }
            },
            {
             "id" : "OpenPrx",
             "totalCount" : "1",
             "faultsCount" : "0",
             "totalTime" : "1484",
             "maxTime" : "1484",
             "minTime" : "1484",
             "longRequest" : 
              {
               "OpenPrx" : 
                {
                 "tObject" : 
                  {
                   "id" : "FOFEFHEKNAAMFOAEJACKCAIKHHBICCGEELKEKCLGIPHJKJLL!M!6334"
                  },
                 "tArg" : 
                  {
                   "args" : 
                    {
                     "updateCache" : 
                      {
                       "@nil" : "true"
                      },
                     "args" : 
                      {
                       "@nil" : "true"
                      },
                     "bind" : 
                      {
                       "@nil" : "true"
                      },
                     "openForEdit" : 
                      {
                       "@nil" : "true"
                      }
                    },
                   "metaGet" : 
                    {
                     "@nil" : "true"
                    }
                  }
                }
              }
            },
            {
             "id" : "ClosePrx",
             "totalCount" : "1",
             "faultsCount" : "0",
             "totalTime" : "16",
             "maxTime" : "16",
             "minTime" : "16",
             "longRequest" : 
              {
               "ClosePrx" : 
                {
                 "tPrx" : 
                  {
                   "id" : "FOFEFHEKNAAMFOAEJACKCAIKHHBICCGEELKEKCLGIPHJKJLL!M!S!PLFNPHNEKNAAMFOAELCIPCFKNGHIADCGEHKCIHKLDKEPMCHBP"
                  }
                }
              }
            },
            {
             "id" : "GetPrxMd",
             "totalCount" : "1",
             "faultsCount" : "0",
             "totalTime" : "32",
             "maxTime" : "32",
             "minTime" : "32",
             "longRequest" : 
              {
               "GetPrxMd" : 
                {
                 "tPrx" : 
                  {
                   "id" : "FOFEFHEKNAAMFOAEJACKCAIKHHBICCGEELKEKCLGIPHJKJLL!M!S!PLFNPHNEKNAAMFOAELCIPCFKNGHIADCGEHKCIHKLDKEPMCHBP"
                  },
                 "tArg" : 
                  {
                   "pattern" : 
                    {
                     "locale" : 
                      {
                       "@nil" : "true"
                      },
                     "names" : 
                      {
                       "@nil" : "true"
                      },
                     "descriptions" : 
                      {
                       "@nil" : "true"
                      },
                     "effectiveRights" : 
                      {
                       "@nil" : "true"
                      },
                     "effectiveRightsSubj" : 
                      {
                       "@nil" : "true"
                      },
                     "fullUrl" : 
                      {
                       "@nil" : "true"
                      },
                     "obInst" : "true",
                     "pars" : 
                      {
                       "@nil" : "true"
                      },
                     "parsControl" : 
                      {
                       "@nil" : "true"
                      },
                     "all" : 
                      {
                       "@nil" : "true"
                      },
                     "sheet" : 
                      {
                       "pageSettings" : "true"
                      },
                     "sheets" : "Get",
                     "duplicateSheet" : 
                      {
                       "@nil" : "true"
                      },
                     "sheetsFilter" : 
                      {
                       "@nil" : "true"
                      },
                     "tableSources" : 
                      {
                       "@nil" : "true"
                      },
                     "tableSourcesFilter" : 
                      {
                       "@nil" : "true"
                      },
                     "dataSources" : 
                      {
                       "@nil" : "true"
                      },
                     "dataSourcesFilter" : 
                      {
                       "@nil" : "true"
                      },
                     "dataSource" : 
                      {
                       "@nil" : "true"
                      },
                     "slices" : 
                      {
                       "@nil" : "true"
                      },
                     "slicesFilter" : 
                      {
                       "@nil" : "true"
                      },
                     "dataIslands" : 
                      {
                       "@nil" : "true"
                      },
                     "dataIslandsFilter" : 
                      {
                       "@nil" : "true"
                      },
                     "tableIslands" : 
                      {
                       "@nil" : "true"
                      },
                     "tableIslandsFilter" : 
                      {
                       "@nil" : "true"
                      },
                     "controls" : 
                      {
                       "@nil" : "true"
                      },
                     "controlsFilter" : 
                      {
                       "@nil" : "true"
                      },
                     "control" : 
                      {
                       "@nil" : "true"
                      },
                     "undoRedo" : 
                      {
                       "@nil" : "true"
                      },
                     "exportData" : 
                      {
                       "@nil" : "true"
                      },
                     "drillCell" : 
                      {
                       "@nil" : "true"
                      },
                     "options" : 
                      {
                       "@nil" : "true"
                      },
                     "slicesDimensions" : 
                      {
                       "@nil" : "true"
                      },
                     "isRecalced" : 
                      {
                       "@nil" : "true"
                      },
                     "updateHypelinks" : 
                      {
                       "@nil" : "true"
                      },
                     "objectAction" : 
                      {
                       "@nil" : "true"
                      },
                     "canGenWbk" : 
                      {
                       "@nil" : "true"
                      },
                     "genWbk" : 
                      {
                       "@nil" : "true"
                      },
                     "genProblem" : 
                      {
                       "@nil" : "true"
                      },
                     "validations" : 
                      {
                       "@nil" : "true"
                      },
                     "diagnosticReport" : 
                      {
                       "@nil" : "true"
                      },
                     "selectedGrid" : 
                      {
                       "@nil" : "true"
                      },
                     "dimAttrsNaming" : 
                      {
                       "@nil" : "true"
                      },
                     "changedCellsStyles" : 
                      {
                       "@nil" : "true"
                      },
                     "vizSelectionImpact" : 
                      {
                       "@nil" : "true"
                      },
                     "styleSheets" : 
                      {
                       "@nil" : "true"
                      },
                     "hasEventHandler" : 
                      {
                       "@nil" : "true"
                      },
                     "objDrillInfo" : 
                      {
                       "@nil" : "true"
                      },
                     "dataArea" : 
                      {
                       "@nil" : "true"
                      },
                     "outOfRangeAfterRecalc" : 
                      {
                       "@nil" : "true"
                      },
                     "attachments" : 
                      {
                       "@nil" : "true"
                      }
                    },
                   "refresh" : 
                    {
                     "@nil" : "true"
                    }
                  }
                }
              }
            }
          ]
        }
      }
    }
  }
}

public static GetSvcResult GetBIServerStatistic()
{
    var somClient = new SomPortTypeClient(); // Proxy object for operation execution
    // Operation execution parameters
    var tGet = new GetSvc()
    {
        tArg = new GetSvcArg()
        {
            pattern = new SvcPattern()
            {
                operationsStat = new OperationsStatPattern()
                {
                    ids = new string[] { "OpenMetabase", "CloseMetabase", "OpenPrx", "ClosePrx", "GetPrxMd", "SetPrxMd" }
                }
            }
        }
    };
    // Get statistic
    var result = somClient.GetSvc(tGet);
    return result;
}