ADO.NET Provider for Zendesk

Build 26.0.9655

Sessions

Returns active user sessions, including session authentication and last activity details.

Table-Specific Information

Select

The provider uses the Zendesk API to process WHERE clause conditions built with the following columns and operators:

  • Id supports the = operator.
  • UserId supports the = operator.

For example, the following queries are processed server-side while other filters are processed client-side within the provider.

SELECT * FROM Sessions WHERE UserId = '123'

SELECT * FROM Sessions WHERE UserId = '19326991711516' AND Id = '6184815149518'

Delete

You must specify the UserId and Id of the session to delete it.

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 associated with the session.

AuthenticatedAt Datetime True

The date and time when the session was authenticated.

LastSeenAt Datetime True

The approximate date and time when the session was last active. This value does not update on every request.

Url String True

The API URL of this session.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655