devices_for_users

Creates, updates, deletes, gets or lists a devices_for_users resource.

Overview

Name	devices_for_users
Type	Resource
Id	aws.wickr.devices_for_users

Fields

The following fields are returned by SELECT queries:

list_devices_for_user

Name	Datatype	Description
app_id	string	The unique application ID for the Wickr app on this device. (pattern: <code>[\S\s]*</code>)
created	string	The timestamp when the device first appeared in the Wickr database. (pattern: <code>[\S\s]*</code>)
last_login	string	The timestamp when the device last successfully logged into Wickr. This is also used to determine SSO idle time. (pattern: <code>[\S\s]*</code>)
status_text	string	The current status of the device, either 'Active' or 'Reset' depending on whether the device is currently active or has been marked for reset. (pattern: <code>[\S\s]*</code>)
suspend	boolean	Indicates whether the device is suspended.
type_	string	The operating system of the device (e.g., 'MacOSX', 'Windows', 'iOS', 'Android'). (pattern: <code>[\S\s]*</code>)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_devices_for_user	select	network_id, user_id, region	nextToken, maxResults, sortFields, sortDirection	Retrieves a paginated list of devices associated with a specific user in a Wickr network. This operation returns information about all devices where the user has logged into Wickr.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
network_id	string	The ID of the Wickr network containing the user.
region	string	AWS region (default: us-east-1)
user_id	string	The unique identifier of the user whose devices will be listed.
maxResults	integer	The maximum number of devices to return in a single page. Valid range is 1-100. Default is 10.
nextToken	string	The token for retrieving the next page of results. This is returned from a previous request when there are more results available.
sortDirection	string	The direction to sort results. Valid values are 'ASC' (ascending) or 'DESC' (descending). Default is 'DESC'.
sortFields	string	The fields to sort devices by. Multiple fields can be specified by separating them with '+'. Accepted values include 'lastlogin', 'type', 'suspend', and 'created'.

SELECT examples

list_devices_for_user

Retrieves a paginated list of devices associated with a specific user in a Wickr network. This operation returns information about all devices where the user has logged into Wickr.

SELECT
app_id,
created,
last_login,
status_text,
suspend,
type_
FROM aws.wickr.devices_for_users
WHERE network_id = '{{ network_id }}' -- required
AND user_id = '{{ user_id }}' -- required
AND region = '{{ region }}' -- required
AND nextToken = '{{ nextToken }}'
AND maxResults = '{{ maxResults }}'
AND sortFields = '{{ sortFields }}'
AND sortDirection = '{{ sortDirection }}'
;