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 is not used in the itslearning application, this is a technical table.
Notes
- The entity shows the information using time stamps.
Relationships
Time is linked to:
Diagram
Entity Details
Name | Data type | Nullable | Description |
---|---|---|---|
MonthlyDateId | Edm.Int32 | false | Technical id of a monthly date |
DateId | Edm.Int32 | false | Technical id of a date |
TimeId | Edm.Int32 | false | Technical id of a time |
UserId | Edm.Int32 | false | Id of a user that visited the platform |
SiteProfileId | Edm.Int32 | false | Users site profile id |
SessionStartTime | Edm.DateTime | false | DateTime when user logged in to the site |
SessionEndTime | Edm.DateTime | false | DateTime when user logged out from site |
SessionDurationSeconds | Edm.Int32 | false | Session duration (in seconds) |
T_ModifiedDate | Edm.DateTime | false | Date and time the entity was last modified in data warehouse |
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
}
]
}