General Read

pixiGetUsersFromLastLogin

Returns the Pixi users found in the most recent login snapshot of `UsersLoggedIn`, with first name, last name and e-mail address.

The call has no parameters.

It finds the highest Tag value in UsersLoggedIn among entries with UserActiveSessionTypeId = 1. This value identifies the most recent recorded snapshot of logged-in users.
It returns all entries of UsersLoggedIn that belong to this Tag and have UserActiveSessionTypeId 1 or 2.
Each entry is joined to Users. The join uses the part of UsersLoggedIn.UserName before the first space, which must equal Users.UserName.
The rows are grouped by all output columns, so duplicate session entries of the same login name appear only once.

The result has no explicit sort order.

Notes

All reads use NOLOCK, so the result can contain uncommitted or inconsistent data.
Entries whose UserName in UsersLoggedIn contains no space are never returned. In that case PATINDEX returns 0 and the extracted name is empty, so the join to Users finds no match.
The header comment says the procedure returns "the number of active connections and logged in users". The code, however, returns a list of users and no counts.
The meaning of the UserActiveSessionTypeId values 1 and 2 is not defined in the code. How and when UsersLoggedIn is filled is also not visible here.
If no entry with UserActiveSessionTypeId = 1 exists, the result is empty.

Parameters

This call has no parameters.

Response

Result set 1 · Always (may be empty)

One row per distinct login name in the most recent snapshot, with the matching user master data.

Column	Type	Description
`UserName`	string	Login name as stored in `UsersLoggedIn`. It contains the Pixi user name, followed by a space and further information.
`FirstName` Nullable	string	First name of the user from `Users`.
`LastName` Nullable	string	Last name of the user from `Users`.
`eMail` Nullable	string	E-mail address of the user from `Users`.
`Tag`	string	Snapshot tag the row belongs to. It is the maximum `Tag` value in `UsersLoggedIn` among entries with `UserActiveSessionTypeId = 1`.

Response example

<SqlRowSet1>
  <row>
    <UserName>mmueller PIXI-WS01</UserName>
    <FirstName>Martin</FirstName>
    <LastName>Müller</LastName>
    <eMail>m.mueller@example.com</eMail>
    <Tag>48213</Tag>
  </row>
  <row>
    <UserName>skrause PIXI-WS07</UserName>
    <FirstName>Sabine</FirstName>
    <LastName>Krause</LastName>
    <eMail>s.krause@example.com</eMail>
    <Tag>48213</Tag>
  </row>
</SqlRowSet1>

Examples

POST https://apigateway.descartes.com/tms/pixi/
Content-Type: text/xml; charset=utf-8
Authorization: Basic BASE64(USERNAME:PASSWORD)

<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="https://apigateway.descartes.com/tms/pixi/">
  <SOAP-ENV:Body>
    <ns1:pixiGetUsersFromLastLogin/>
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

curl -X POST 'https://apigateway.descartes.com/tms/pixi/' \
  --user 'USERNAME:PASSWORD' \
  --header 'Content-Type: text/xml; charset=utf-8' \
  --data-binary @- <<'XML'
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="https://apigateway.descartes.com/tms/pixi/">
  <SOAP-ENV:Body>
    <ns1:pixiGetUsersFromLastLogin/>
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>
XML

<?php

$soapClient = new SoapClient(null, [
    'login' => 'USERNAME',
    'password' => 'PASSWORD',
    'location' => 'https://apigateway.descartes.com/tms/pixi/',
    'uri' => 'https://apigateway.descartes.com/tms/pixi/',
]);

$arguments = [
];

$soapArguments = [];
foreach ($arguments as $name => $value) {
    $soapArguments[] = new SoapVar($value, XSD_STRING, '', '', $name);
}

$response = $soapClient->__soapCall('pixiGetUsersFromLastLogin', $soapArguments);

Tables used

UsersLoggedIn · Read Users · Read

SQL object:: dbo.pipiGetUsersFromLastLogin