Database GetUserList

Returns the name, IP address, and the server internal ID of the users connected to the database. Information about their running task is also returned.

Request

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="001" Class="Database" Method="GetUserList" />
</Alea:Document>

Answer

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="001">
    <Alea:Return>
      <Alea:Users>
        <Alea:User UserId="9" Name="Admin" Address="LOCAL" TaskRunning="0"/>
        <Alea:User UserId="20002" Name="admin" Address="127.0.0.1" TaskRunning="4" TaskState="1" TaskProgress="0" TaskStartTime="2014-07-01 14:53:55"/>
        <Alea:User UserId="20003" Name="admin" Address="127.0.0.1" TaskRunning="0"/>
      </Alea:Users>
    </Alea:Return>
  </Alea:Request>
</Alea:Document>

These are the values for TaskRunning:

0 : No task
1 : Load Cube
2 : Save Cube
3 : Data Area
4 : Calculation
5 : Accelerators
6 : Backup
7 : Splashing
8 : SplashingUndo
9 : Load Jobs execution
10: Load Jobs scheduling
11: Unload Idle Database
12: Optimize value heap of cubes
14: Execution of MDX request

These are the values for TaskState:

1 : Running
2 : Busy
3 : Ending