Brightspace Data Sets for Chat

Brightspace Data Sets for Chat include:

This data set has a dependency on Chat. If you turn this tool on and off during the data set query period, there may be unexpected or missing content in your data sets.

Entity Relationship Diagram

To show the relationships between entities used to create Brightspace Data Sets for Chat, click the following thumbnail image:

Entity Relationship Diagram for Chat

 

Brightspace Data Set: Chat Objects

About

Returns the attributes for all chats in the organization.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

Version History

Field

Description

Type

Column Size

Key

3.6 / 4.1 ChatId Unique chat identifier BigInteger 8 PK
3.6 / 4.1

OrgUnitId

Unique org unit identifier

Integer

4

FK

3.6 / 4.1

ChatType

Type of chat. Field can be null.

nvarchar

4

 

3.6 / 4.1

Name

Name of chat object

nvarchar

300

 

3.6 / 4.1

Description

Description of chat object. Field can be null.

nvarchar

Truncated to 1000 characters. To change the default value, contact D2L.

 

3.6 / 4.1

CreatorUserId

Unique chat object creator identifier

Integer

4

 

3.6 / 4.1

LastModified

Date / time the chat object was last modified. Field can be null.

DateTime

8

 

Brightspace Data Set: Chat Session Log

About

Returns a log of when messages were sent in chat sessions for your org units.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

Version History

Field

Description

Type

Column Size

Key

1.0

OrgUnitId

Unique org unit identifier

Integer

4

FK

1.0

UserId

Unique user identifier

Integer

4

FK

1.0

ChatSessionId

Unique chat session identifier

BigInteger

8

 

1.0

StartDate

Chat session start date

DateTime

8

 

1.0

EndDate

Chat session end date. Field can be null.

DateTime

8

 

1.0

TimeSent

Time message was sent

DateTime

8

 

1.4 - Added MessageId Unique message identifier BigInteger 8 PK