Database GetUserList (10.6.0)

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

These are the values for TaskState:

  • 1 : Running
  • 2 : Busy
  • 3 : Ending