FileTransfers table in Skype for Business Server 2015

Each record represents one file transfer session.

Column Data Type Key/Index Details
SessionIdTime
datetime
Primary, Foreign
Time of session request. Used in conjunction with SessionIdSeq to uniquely identify a session. See the Dialogs table in Skype for Business Server 2015 for more information.
SessionIdSeq
int
Primary, Foreign
ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a session. See the Dialogs table in Skype for Business Server 2015 for more information.
File Name
nvarchar(256)
Name of the file.
FileIdentity
uniqueidentifier
Unique identifier to distinguish between file transfers involving the same file name.
Cookie
nvarchar(128)
Primary
Used to identify every follow-up message as being associated with this one.
Accept
bit
Can be TRUE or NULL. If TRUE, then Reject and Cancel will be NULL.
Reject
bit
Can be TRUE or NULL. If TRUE, then Accept and Cancel will be NULL.
Cancel
bit
Can be TRUE or NULL. If TRUE, then Accept and Reject will be NULL.
LastModifiedTime
Datetime
For internal use by the Monitoring service.
This field was introduced in Skype for Business Server 2015.