UserSession

Overview

This is a fact entity which contains basic information about user sessions in the platform and their site profiles.

Which user sessions are included?

The entity contains all current and historical sessions.

Usage in itslearning

  • This entity hasn't used in itslearning, this is a technical table, information about user or users activity on the site.

Notes

  • The entity shows the information using time stamps.

Relationships

Time is linked to:

Diagram

images/download/attachments/45732094/UserSession.PNG

Entity Details

Name

Data type

Nullable

Description

MonthlyDateId

Edm.Int32

false

monthly date id

(primary key)

DateId

Edm.Int32

false

date id

TimeId

Edm.Int32

false

time id (hourly)

UserId

Edm.Int32

false

user id logging

SiteProfileId

Edm.Int32

false

user site profile

SessionStartTime

Edm.DateTime

false

session start time

date and time when user logged on the site

SessionEndTime

Edm.DateTime

false

session end time

date end time when user logged out in the site

SessionDurationSeconds

Edm.Int32

false

session duration

Formula: SessionEndTime - SessionStartTime [secound]

how long user was login in site

SQL code

CREATE TABLE [Dwh].[UserSession]([MonthlyDateId] [INT] NOT NULL ,[DateId] [INT] NOT NULL ,[TimeId] [INT] NOT NULL ,[UserId] [INT] NOT NULL ,[SiteProfileId] [INT] NOT NULL ,[SessionStartTime] [DATETIME] NOT NULL ,[SessionEndTime] [DATETIME] NOT NULL ,[SessionDurationSeconds] [INT] NOT NULL )

ALTER TABLE Dwh.UserSession ADD CONSTRAINT PK_UserSession PRIMARY KEY (UserId,SessionStartTime);

Request body

URI
https://reporting.itslearning.com/odata/engine7/UserSessions?$top=10

Response body - XML

XML response
<?xml version="1.0" encoding="utf-8"?>
<feed xml:base="https://reporting.itslearning.com/odata/engine7" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xml
ns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml">
<id>http://schemas.datacontract.org/2004/07/</id>
<title />
<updated>2018-04-23T13:30:53Z</updated>
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserSessions" />
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-02-26T09:19:46')</id>
<category term="Itslearning.Reporting.Data.Models.UserSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-02-26T09:19:46')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-02-26T09:19:46')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-02-26T09:19:46')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Time" type="application/atom+xml;type=entry" title="Time" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-02-26T09:19:46')/Time" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-02-26T09:19:46')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/SiteProfile" type="application/atom+xml;type=entry" title="SiteProfile" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime
=datetime'2018-02-26T09:19:46')/SiteProfile" />
<title />
<updated>2018-04-23T13:30:53Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180201</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180226</d:DateId>
<d:TimeId m:type="Edm.Int32">900</d:TimeId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">7</d:SiteProfileId>
<d:SessionStartTime m:type="Edm.DateTime">2018-02-26T09:19:46</d:SessionStartTime>
<d:SessionEndTime m:type="Edm.DateTime">2018-02-26T12:17:03</d:SessionEndTime>
<d:SessionDurationSeconds m:type="Edm.Int32">10637</d:SessionDurationSeconds>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-07T16:31:27')</id>
<category term="Itslearning.Reporting.Data.Models.UserSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-07T16:31:27')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-07T16:31:27')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-07T16:31:27')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Time" type="application/atom+xml;type=entry" title="Time" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-07T16:31:27')/Time" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-07T16:31:27')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/SiteProfile" type="application/atom+xml;type=entry" title="SiteProfile" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime
=datetime'2018-03-07T16:31:27')/SiteProfile" />
<title />
<updated>2018-04-23T13:30:53Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180307</d:DateId>
<d:TimeId m:type="Edm.Int32">1600</d:TimeId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">7</d:SiteProfileId>
<d:SessionStartTime m:type="Edm.DateTime">2018-03-07T16:31:27</d:SessionStartTime>
<d:SessionEndTime m:type="Edm.DateTime">2018-03-07T16:49:38</d:SessionEndTime>
<d:SessionDurationSeconds m:type="Edm.Int32">1091</d:SessionDurationSeconds>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-08T08:50:00')</id>
<category term="Itslearning.Reporting.Data.Models.UserSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-08T08:50:00')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-08T08:50:00')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-08T08:50:00')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Time" type="application/atom+xml;type=entry" title="Time" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-08T08:50:00')/Time" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-08T08:50:00')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/SiteProfile" type="application/atom+xml;type=entry" title="SiteProfile" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime
=datetime'2018-03-08T08:50:00')/SiteProfile" />
<title />
<updated>2018-04-23T13:30:53Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180308</d:DateId>
<d:TimeId m:type="Edm.Int32">800</d:TimeId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">7</d:SiteProfileId>
<d:SessionStartTime m:type="Edm.DateTime">2018-03-08T08:50:00</d:SessionStartTime>
<d:SessionEndTime m:type="Edm.DateTime">2018-03-08T17:07:35</d:SessionEndTime>
<d:SessionDurationSeconds m:type="Edm.Int32">29855</d:SessionDurationSeconds>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-09T08:25:14')</id>
<category term="Itslearning.Reporting.Data.Models.UserSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-09T08:25:14')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-09T08:25:14')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-09T08:25:14')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Time" type="application/atom+xml;type=entry" title="Time" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-09T08:25:14')/Time" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-09T08:25:14')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/SiteProfile" type="application/atom+xml;type=entry" title="SiteProfile" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime
=datetime'2018-03-09T08:25:14')/SiteProfile" />
<title />
<updated>2018-04-23T13:30:53Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180309</d:DateId>
<d:TimeId m:type="Edm.Int32">800</d:TimeId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">7</d:SiteProfileId>
<d:SessionStartTime m:type="Edm.DateTime">2018-03-09T08:25:14</d:SessionStartTime>
<d:SessionEndTime m:type="Edm.DateTime">2018-03-09T11:01:18</d:SessionEndTime>
<d:SessionDurationSeconds m:type="Edm.Int32">9364</d:SessionDurationSeconds>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-09T13:53:31')</id>
<category term="Itslearning.Reporting.Data.Models.UserSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-09T13:53:31')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-09T13:53:31')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-09T13:53:31')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Time" type="application/atom+xml;type=entry" title="Time" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-09T13:53:31')/Time" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-09T13:53:31')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/SiteProfile" type="application/atom+xml;type=entry" title="SiteProfile" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime
=datetime'2018-03-09T13:53:31')/SiteProfile" />
<title />
<updated>2018-04-23T13:30:53Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180309</d:DateId>
<d:TimeId m:type="Edm.Int32">1300</d:TimeId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">7</d:SiteProfileId>
<d:SessionStartTime m:type="Edm.DateTime">2018-03-09T13:53:31</d:SessionStartTime>
<d:SessionEndTime m:type="Edm.DateTime">2018-03-09T17:06:12</d:SessionEndTime>
<d:SessionDurationSeconds m:type="Edm.Int32">11561</d:SessionDurationSeconds>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-12T10:25:32')</id>
<category term="Itslearning.Reporting.Data.Models.UserSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-12T10:25:32')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-12T10:25:32')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-12T10:25:32')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Time" type="application/atom+xml;type=entry" title="Time" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-12T10:25:32')/Time" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-12T10:25:32')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/SiteProfile" type="application/atom+xml;type=entry" title="SiteProfile" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime
=datetime'2018-03-12T10:25:32')/SiteProfile" />
<title />
<updated>2018-04-23T13:30:53Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180312</d:DateId>
<d:TimeId m:type="Edm.Int32">1000</d:TimeId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">7</d:SiteProfileId>
<d:SessionStartTime m:type="Edm.DateTime">2018-03-12T10:25:32</d:SessionStartTime>
<d:SessionEndTime m:type="Edm.DateTime">2018-03-12T17:08:08</d:SessionEndTime>
<d:SessionDurationSeconds m:type="Edm.Int32">24156</d:SessionDurationSeconds>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-13T08:16:38')</id>
<category term="Itslearning.Reporting.Data.Models.UserSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-13T08:16:38')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-13T08:16:38')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-13T08:16:38')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Time" type="application/atom+xml;type=entry" title="Time" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-13T08:16:38')/Time" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-13T08:16:38')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/SiteProfile" type="application/atom+xml;type=entry" title="SiteProfile" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime
=datetime'2018-03-13T08:16:38')/SiteProfile" />
<title />
<updated>2018-04-23T13:30:53Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180313</d:DateId>
<d:TimeId m:type="Edm.Int32">800</d:TimeId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">7</d:SiteProfileId>
<d:SessionStartTime m:type="Edm.DateTime">2018-03-13T08:16:38</d:SessionStartTime>
<d:SessionEndTime m:type="Edm.DateTime">2018-03-13T22:07:43</d:SessionEndTime>
<d:SessionDurationSeconds m:type="Edm.Int32">49865</d:SessionDurationSeconds>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-21T10:12:48')</id>
<category term="Itslearning.Reporting.Data.Models.UserSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-21T10:12:48')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-21T10:12:48')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-21T10:12:48')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Time" type="application/atom+xml;type=entry" title="Time" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-21T10:12:48')/Time" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-21T10:12:48')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/SiteProfile" type="application/atom+xml;type=entry" title="SiteProfile" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime
=datetime'2018-03-21T10:12:48')/SiteProfile" />
<title />
<updated>2018-04-23T13:30:53Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180321</d:DateId>
<d:TimeId m:type="Edm.Int32">1000</d:TimeId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">7</d:SiteProfileId>
<d:SessionStartTime m:type="Edm.DateTime">2018-03-21T10:12:48</d:SessionStartTime>
<d:SessionEndTime m:type="Edm.DateTime">2018-03-21T10:15:48</d:SessionEndTime>
<d:SessionDurationSeconds m:type="Edm.Int32">180</d:SessionDurationSeconds>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-21T13:27:39')</id>
<category term="Itslearning.Reporting.Data.Models.UserSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-21T13:27:39')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-21T13:27:39')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-21T13:27:39')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Time" type="application/atom+xml;type=entry" title="Time" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-21T13:27:39')/Time" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-21T13:27:39')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/SiteProfile" type="application/atom+xml;type=entry" title="SiteProfile" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime
=datetime'2018-03-21T13:27:39')/SiteProfile" />
<title />
<updated>2018-04-23T13:30:53Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180321</d:DateId>
<d:TimeId m:type="Edm.Int32">1300</d:TimeId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">7</d:SiteProfileId>
<d:SessionStartTime m:type="Edm.DateTime">2018-03-21T13:27:39</d:SessionStartTime>
<d:SessionEndTime m:type="Edm.DateTime">2018-03-21T13:30:39</d:SessionEndTime>
<d:SessionDurationSeconds m:type="Edm.Int32">180</d:SessionDurationSeconds>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-27T11:20:50')</id>
<category term="Itslearning.Reporting.Data.Models.UserSession" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-27T11:20:50')" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018-03-27T11:20:50')" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Date" type="application/atom+xml;type=entry" title="Date" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-27T11:20:50')/Date" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Time" type="application/atom+xml;type=entry" title="Time" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-27T11:20:50')/Time" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/User" type="application/atom+xml;type=entry" title="User" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime=datetime'2018
-03-27T11:20:50')/User" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/SiteProfile" type="application/atom+xml;type=entry" title="SiteProfile" href="https://reporting.itslearning.com/odata/engine7/UserSessions(UserId=1,SessionStartTime
=datetime'2018-03-27T11:20:50')/SiteProfile" />
<title />
<updated>2018-04-23T13:30:53Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:MonthlyDateId m:type="Edm.Int32">20180301</d:MonthlyDateId>
<d:DateId m:type="Edm.Int32">20180327</d:DateId>
<d:TimeId m:type="Edm.Int32">1100</d:TimeId>
<d:UserId m:type="Edm.Int32">1</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">7</d:SiteProfileId>
<d:SessionStartTime m:type="Edm.DateTime">2018-03-27T11:20:50</d:SessionStartTime>
<d:SessionEndTime m:type="Edm.DateTime">2018-03-27T11:46:03</d:SessionEndTime>
<d:SessionDurationSeconds m:type="Edm.Int32">1513</d:SessionDurationSeconds>
</m:properties>
</content>
</entry>
</feed>

Response body - JSON (default output format)

JSON response
{
"odata.metadata":"https://reporting.itslearning.com/odata/engine7/$metadata#UserSessions","value":[
{
"MonthlyDateId":20180201,"DateId":20180226,"TimeId":900,"UserId":1,"SiteProfileId":7,"SessionStartTime":"2018-02-26T09:19:46","SessionEndTime":"2018-02-26T12:17:03","SessionDurationSeconds":10637
},{
"MonthlyDateId":20180301,"DateId":20180307,"TimeId":1600,"UserId":1,"SiteProfileId":7,"SessionStartTime":"2018-03-07T16:31:27","SessionEndTime":"2018-03-07T16:49:38","SessionDurationSeconds":1091
},{
"MonthlyDateId":20180301,"DateId":20180308,"TimeId":800,"UserId":1,"SiteProfileId":7,"SessionStartTime":"2018-03-08T08:50:00","SessionEndTime":"2018-03-08T17:07:35","SessionDurationSeconds":29855
},{
"MonthlyDateId":20180301,"DateId":20180309,"TimeId":800,"UserId":1,"SiteProfileId":7,"SessionStartTime":"2018-03-09T08:25:14","SessionEndTime":"2018-03-09T11:01:18","SessionDurationSeconds":9364
},{
"MonthlyDateId":20180301,"DateId":20180309,"TimeId":1300,"UserId":1,"SiteProfileId":7,"SessionStartTime":"2018-03-09T13:53:31","SessionEndTime":"2018-03-09T17:06:12","SessionDurationSeconds":11561
},{
"MonthlyDateId":20180301,"DateId":20180312,"TimeId":1000,"UserId":1,"SiteProfileId":7,"SessionStartTime":"2018-03-12T10:25:32","SessionEndTime":"2018-03-12T17:08:08","SessionDurationSeconds":24156
},{
"MonthlyDateId":20180301,"DateId":20180313,"TimeId":800,"UserId":1,"SiteProfileId":7,"SessionStartTime":"2018-03-13T08:16:38","SessionEndTime":"2018-03-13T22:07:43","SessionDurationSeconds":49865
},{
"MonthlyDateId":20180301,"DateId":20180321,"TimeId":1000,"UserId":1,"SiteProfileId":7,"SessionStartTime":"2018-03-21T10:12:48","SessionEndTime":"2018-03-21T10:15:48","SessionDurationSeconds":180
},{
"MonthlyDateId":20180301,"DateId":20180321,"TimeId":1300,"UserId":1,"SiteProfileId":7,"SessionStartTime":"2018-03-21T13:27:39","SessionEndTime":"2018-03-21T13:30:39","SessionDurationSeconds":180
},{
"MonthlyDateId":20180301,"DateId":20180327,"TimeId":1100,"UserId":1,"SiteProfileId":7,"SessionStartTime":"2018-03-27T11:20:50","SessionEndTime":"2018-03-27T11:46:03","SessionDurationSeconds":1513
}
]
}