From where Integration Server getting the data for Service Usage page.

,
1

In IS we have Service Usage page and In that we can able to see the all the information about services. Where is this data located. Is this is from wm DB. If so, what is the table name. Can any one help me on this.

2

Some of the data comes from the internal log files and you can always refer the WmRoot services fetched by (dsp’s) located in the root package file system and explore the info.

HTH,
RMG

3

And also if you have set Service logging as Database then all the Service audit data will be stored in tables with
WMSERVICE prefix.

4

Also the WMERRORS table if logging to DB.

5

Hi Rmg, Seenivas,
Thanks for the information.

One small doubt. Where can i set/see the “Service logging” option?

Thanks,
Guruprasad

6

Hi Gudu,

In IS Admin page, Under “Settings” tab (left side), click “Logging” - here you can set all the loggers details inculding “Service logger” details.
and for checking the service logs - click “Service” tab under section “Logs”.

Re. your Service Usage information query - As other members said- in wMRoot package we have inbuilt service wm.server.query:getServiceStats which actually gets all this service usage information for this section. But unfortunately the code is hidden here :frowning:

Thanks,
Mohit K

7

Hi Mohit,

Thanks for the information.

Thanks,
Guruprasad