SOAPBelow is the example of using the GetSvc operation to get statistics of executing operations collected from BI server memory. The request contains the list of operations, statistics for which is obtained. The response contains requested information.
<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=" "> <credentials> <user> <pattern> <operationsStat> <ids> <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> <longRequest> <OpenMetabase xmlns="http://www.fsight.ru/PP.SOM.Som"> <tDef xmlns=" "> <tCreds xmlns=" "> <user> <tArg xmlns=" "> <it> <longRequest> <OpenPrx xmlns="http://www.fsight.ru/PP.SOM.Som"> <tObject xmlns=" "> <tArg xmlns=" "> <args> <it> <longRequest> <ClosePrx xmlns="http://www.fsight.ru/PP.SOM.Som"> <tPrx xmlns=" "> <it> <longRequest> <GetPrxMd xmlns="http://www.fsight.ru/PP.SOM.Som"> <tPrx xmlns=" "> <tArg xmlns=" "> <pattern> <sheet>
{
"GetSvc" :
{
"tArg" :
{
"credentials" :
{
"user" :
{
"id" : "pprepository"
},
"pass" : "pprepository"
},
"pattern" :
{
"operationsStat" :
{
"ids" :
{
"it" :
[
"OpenMetabase",
"CloseMetabase",
"OpenPrx",
"ClosePrx",
"GetPrxMd",
"SetPrxMd"
]
}
}
}
}
}
}
{
"GetSvcResult" :
{
"meta" :
{
"operationsStat" :
{
"its" :
{
"it" :
[
{
"id" : "OpenMetabase",
"totalCount" : "1",
"faultsCount" : "0",
"totalTime" : "4290",
"maxTime" : "4290",
"minTime" : "4290",
"longRequest" :
{
"OpenMetabase" :
{
"tDef" :
{
"id" : "PPREPOSITORY",
"locale" :
{
"@nil" : "true"
},
"logonData" :
{
"@nil" : "true"
}
},
"tCreds" :
{
"user" :
{
"id" : "pprepository",
"domain" :
{
"@nil" : "true"
}
},
"pass" : "pprepository",
"imperson" :
{
"@nil" : "true"
},
"useMetabase" :
{
"@nil" : "true"
},
"oauth" :
{
"@nil" : "true"
},
"saml2" :
{
"@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"
}
}
}
}
},
{
"id" : "OpenPrx",
"totalCount" : "1",
"faultsCount" : "0",
"totalTime" : "3229",
"maxTime" : "3229",
"minTime" : "3229",
"longRequest" :
{
"OpenPrx" :
{
"tObject" :
{
"id" : "S1!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" : "31",
"maxTime" : "31",
"minTime" : "31",
"longRequest" :
{
"ClosePrx" :
{
"tPrx" :
{
"id" : "S1!M!S!P1"
}
}
}
},
{
"id" : "GetPrxMd",
"totalCount" : "1",
"faultsCount" : "0",
"totalTime" : "16",
"maxTime" : "16",
"minTime" : "16",
"longRequest" :
{
"GetPrxMd" :
{
"tPrx" :
{
"id" : "S1!M!S!P1"
},
"tArg" :
{
"pattern" :
{
"locale" :
{
"@nil" : "true"
},
"names" :
{
"@nil" : "true"
},
"descriptions" :
{
"@nil" : "true"
},
"effectiveRights" :
{
"@nil" : "true"
},
"obInst" : "true",
"pars" :
{
"@nil" : "true"
},
"all" :
{
"@nil" : "true"
},
"sheet" :
{
"pageSettings" : "true"
},
"sheets" : "Get",
"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"
},
"exportData" :
{
"@nil" : "true"
},
"drillCell" :
{
"@nil" : "true"
},
"options" :
{
"@nil" : "true"
},
"slicesDimensions" :
{
"@nil" : "true"
},
"isRecalced" :
{
"@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"
}
},
"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 statistics
var result = somClient.GetSvc(tGet);
return result;
}
See also: