Query and delete Sessions in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the connector.

SELECT * FROM Sessions WHERE Userid = '123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.

Delete

You must specify the UserId and Id of the session to delete it. Allowed for admins, agents, end users.

DELETE FROM Sessions WHERE Userid = '123' AND Id = '456'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the session is created.
UserId	Long	True	Users.Id	The id of the user.
AuthenticatedAt	Datetime	True		When the session was created.
LastSeenAt	Datetime	True		The last approximate time this session was seen. This does not update on every request.
Url	String	True		The API URL of this session.