UserLogin

Overview

This entity presents facts and basic information about logins to the platform.

Which user logins are included?

All current and historical sessions are included.

Usage in itslearning

  • This entity is not used in the itslearning application, this is a technical table

Notes

  • Sessions are aggregated by hour of a day

  • Sessions started during one hour and ended during another are being split onto multiple entities

  • Because of the way entries are logged over each hour, there might be multiple UserLogin entities for the same user session including some that have 0 logins and 0 log outs. When Logins and Logouts are both zero, this means that they were already logged in before that hourly record and logged out afterwards.

    • Example 1 - A user logging in at 09:50 and logged out at 11:15, their data would record as 3 entries :

      • First entry (Login) : 09-10 : Logins 1 (Logouts 0) : Duration 10 minutes (600 seconds)

      • Second entry : 10-11 : Logins and Logouts 0 : Duration 60 minutes (3600 seconds)

      • Third entry (Logout) : 11-12 : Logouts 1 (Logins 0) : Duration 15 minutes (900 seconds)

    • Example 2 - A user logging in at 09:50 and logging out at 09:55 would have a single entry: Logins 1, Logouts 1 : Duration 5 minutes (300 seconds)

Relationships

Time is linked to:

Diagram

images/download/attachments/41661415/UserLogin.PNG

Entity Details

Name

Data type

Nullable

Description

SessionDateId

Edm.Int32

false

Technical id of a date

SessionTimeId

Edm.Int32

false

Technical id of a time

UserId

Edm.Int32

false

Id of a user that logged in

SiteProfileId

Edm.Int32

false

Users site profile

SessionsDurationSeconds

Edm.Int32

false

Session duration (in seconds)

LogOns

Edm.Int16

false

Number of logins within an hour

LogOuts

Edm.Int16

false

Number of logouts within an hour

T_ModifiedDate

Edm.DateTime

false

Date and time the entity was last modified in data warehouse

SQL code

CREATE TABLE [Dwh].[UserLogins]([SessionDateId] [INT] NOT NULL ,[SessionTimeId] [INT] NOT NULL ,[UserId] [INT] NOT NULL ,[SiteProfileId] [INT] NOT NULL ,[SessionsDurationSeconds] [INT] NOT NULL ,[LogOns] [SMALLINT] NOT NULL ,[LogOuts] [SMALLINT] NOT NULL, [T_ModifiedDate] [DATETIME] NOT NULL ) ALTER TABLE Dwh.UserLogins ADD CONSTRAINT PK_UserLogins PRIMARY KEY (UserId,SiteProfileId,SessionTimeId,SessionDateId);

Request body

URI
https://reporting.itslearning.com/odata/engine7/UserLogins?$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" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml">
<id>http://schemas.datacontract.org/2004/07/</id>
<title />
<updated>2016-12-21T10:57:13Z</updated>
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserLogins" />
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=1839,SiteProfileId=8)</id>
<category term="Itslearning.Reporting.Data.Models.UserLogin" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=1839,SiteProfileId=8)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=1839,SiteProfileId=8)" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=1839,SiteProfileId=8)/User" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=1839,SiteProfileId=8)/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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=1839,SiteProfileId=8)/Time" />
<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/UserLogins(SessionDateId
=20161122,SessionTimeId=0,UserId=1839,SiteProfileId=8)/SiteProfile" />
<title />
<updated>2016-12-21T10:57:13Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SessionDateId m:type="Edm.Int32">20161122</d:SessionDateId>
<d:SessionTimeId m:type="Edm.Int32">0</d:SessionTimeId>
<d:UserId m:type="Edm.Int32">1839</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">8</d:SiteProfileId>
<d:SessionsDurationSeconds m:type="Edm.Int32">3600</d:SessionsDurationSeconds>
<d:LogOns m:type="Edm.Int16">0</d:LogOns>
<d:LogOuts m:type="Edm.Int16">0</d:LogOuts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=5,SiteProfileId=9)</id>
<category term="Itslearning.Reporting.Data.Models.UserLogin" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=5,SiteProfileId=9)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=5,SiteProfileId=9)" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=5,SiteProfileId=9)/User" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=5,SiteProfileId=9)/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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=5,SiteProfileId=9)/Time" />
<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/UserLogins(SessionDateId
=20161122,SessionTimeId=0,UserId=5,SiteProfileId=9)/SiteProfile" />
<title />
<updated>2016-12-21T10:57:13Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SessionDateId m:type="Edm.Int32">20161122</d:SessionDateId>
<d:SessionTimeId m:type="Edm.Int32">0</d:SessionTimeId>
<d:UserId m:type="Edm.Int32">5</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">9</d:SiteProfileId>
<d:SessionsDurationSeconds m:type="Edm.Int32">3600</d:SessionsDurationSeconds>
<d:LogOns m:type="Edm.Int16">0</d:LogOns>
<d:LogOuts m:type="Edm.Int16">0</d:LogOuts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=134,SiteProfileId=9)</id>
<category term="Itslearning.Reporting.Data.Models.UserLogin" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=134,SiteProfileId=9)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=134,SiteProfileId=9)" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=134,SiteProfileId=9)/User" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=134,SiteProfileId=9)/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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=134,SiteProfileId=9)/Time" />
<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/UserLogins(SessionDateId
=20161122,SessionTimeId=0,UserId=134,SiteProfileId=9)/SiteProfile" />
<title />
<updated>2016-12-21T10:57:13Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SessionDateId m:type="Edm.Int32">20161122</d:SessionDateId>
<d:SessionTimeId m:type="Edm.Int32">0</d:SessionTimeId>
<d:UserId m:type="Edm.Int32">134</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">9</d:SiteProfileId>
<d:SessionsDurationSeconds m:type="Edm.Int32">3600</d:SessionsDurationSeconds>
<d:LogOns m:type="Edm.Int16">0</d:LogOns>
<d:LogOuts m:type="Edm.Int16">0</d:LogOuts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=175,SiteProfileId=9)</id>
<category term="Itslearning.Reporting.Data.Models.UserLogin" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=175,SiteProfileId=9)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=175,SiteProfileId=9)" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=175,SiteProfileId=9)/User" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=175,SiteProfileId=9)/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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=175,SiteProfileId=9)/Time" />
<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/UserLogins(SessionDateId
=20161122,SessionTimeId=0,UserId=175,SiteProfileId=9)/SiteProfile" />
<title />
<updated>2016-12-21T10:57:13Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SessionDateId m:type="Edm.Int32">20161122</d:SessionDateId>
<d:SessionTimeId m:type="Edm.Int32">0</d:SessionTimeId>
<d:UserId m:type="Edm.Int32">175</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">9</d:SiteProfileId>
<d:SessionsDurationSeconds m:type="Edm.Int32">3600</d:SessionsDurationSeconds>
<d:LogOns m:type="Edm.Int16">0</d:LogOns>
<d:LogOuts m:type="Edm.Int16">0</d:LogOuts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=3343,SiteProfileId=9)</id>
<category term="Itslearning.Reporting.Data.Models.UserLogin" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=3343,SiteProfileId=9)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=3343,SiteProfileId=9)" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=3343,SiteProfileId=9)/User" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=3343,SiteProfileId=9)/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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=3343,SiteProfileId=9)/Time" />
<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/UserLogins(SessionDateId
=20161122,SessionTimeId=0,UserId=3343,SiteProfileId=9)/SiteProfile" />
<title />
<updated>2016-12-21T10:57:13Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SessionDateId m:type="Edm.Int32">20161122</d:SessionDateId>
<d:SessionTimeId m:type="Edm.Int32">0</d:SessionTimeId>
<d:UserId m:type="Edm.Int32">3343</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">9</d:SiteProfileId>
<d:SessionsDurationSeconds m:type="Edm.Int32">3600</d:SessionsDurationSeconds>
<d:LogOns m:type="Edm.Int16">0</d:LogOns>
<d:LogOuts m:type="Edm.Int16">0</d:LogOuts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=3940,SiteProfileId=10)</id>
<category term="Itslearning.Reporting.Data.Models.UserLogin" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=3940,SiteProfileId=10)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=0,UserId=3940,SiteProfileId=10)" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=3940,SiteProfileId=10)/User" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=3940,SiteProfileId=10)/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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=0,UserId=3940,SiteProfileId=10)/Time" />
<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/UserLogins(SessionDateId
=20161122,SessionTimeId=0,UserId=3940,SiteProfileId=10)/SiteProfile" />
<title />
<updated>2016-12-21T10:57:13Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SessionDateId m:type="Edm.Int32">20161122</d:SessionDateId>
<d:SessionTimeId m:type="Edm.Int32">0</d:SessionTimeId>
<d:UserId m:type="Edm.Int32">3940</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">10</d:SiteProfileId>
<d:SessionsDurationSeconds m:type="Edm.Int32">3600</d:SessionsDurationSeconds>
<d:LogOns m:type="Edm.Int16">0</d:LogOns>
<d:LogOuts m:type="Edm.Int16">0</d:LogOuts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=100,UserId=1839,SiteProfileId=8)</id>
<category term="Itslearning.Reporting.Data.Models.UserLogin" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=100,UserId=1839,SiteProfileId=8)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=100,UserId=1839,SiteProfileId=8)" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=100,UserId=1839,SiteProfileId=8)/User" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=100,UserId=1839,SiteProfileId=8)/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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=100,UserId=1839,SiteProfileId=8)/Time" />
<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/UserLogins(SessionDateId
=20161122,SessionTimeId=100,UserId=1839,SiteProfileId=8)/SiteProfile" />
<title />
<updated>2016-12-21T10:57:13Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SessionDateId m:type="Edm.Int32">20161122</d:SessionDateId>
<d:SessionTimeId m:type="Edm.Int32">100</d:SessionTimeId>
<d:UserId m:type="Edm.Int32">1839</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">8</d:SiteProfileId>
<d:SessionsDurationSeconds m:type="Edm.Int32">3600</d:SessionsDurationSeconds>
<d:LogOns m:type="Edm.Int16">0</d:LogOns>
<d:LogOuts m:type="Edm.Int16">0</d:LogOuts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=100,UserId=5,SiteProfileId=9)</id>
<category term="Itslearning.Reporting.Data.Models.UserLogin" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=100,UserId=5,SiteProfileId=9)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=100,UserId=5,SiteProfileId=9)" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=100,UserId=5,SiteProfileId=9)/User" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=100,UserId=5,SiteProfileId=9)/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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=100,UserId=5,SiteProfileId=9)/Time" />
<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/UserLogins(SessionDateId
=20161122,SessionTimeId=100,UserId=5,SiteProfileId=9)/SiteProfile" />
<title />
<updated>2016-12-21T10:57:13Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SessionDateId m:type="Edm.Int32">20161122</d:SessionDateId>
<d:SessionTimeId m:type="Edm.Int32">100</d:SessionTimeId>
<d:UserId m:type="Edm.Int32">5</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">9</d:SiteProfileId>
<d:SessionsDurationSeconds m:type="Edm.Int32">3600</d:SessionsDurationSeconds>
<d:LogOns m:type="Edm.Int16">0</d:LogOns>
<d:LogOuts m:type="Edm.Int16">0</d:LogOuts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=100,UserId=134,SiteProfileId=9)</id>
<category term="Itslearning.Reporting.Data.Models.UserLogin" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=100,UserId=134,SiteProfileId=9)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=100,UserId=134,SiteProfileId=9)" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=100,UserId=134,SiteProfileId=9)/User" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=100,UserId=134,SiteProfileId=9)/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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=100,UserId=134,SiteProfileId=9)/Time" />
<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/UserLogins(SessionDateId
=20161122,SessionTimeId=100,UserId=134,SiteProfileId=9)/SiteProfile" />
<title />
<updated>2016-12-21T10:57:13Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SessionDateId m:type="Edm.Int32">20161122</d:SessionDateId>
<d:SessionTimeId m:type="Edm.Int32">100</d:SessionTimeId>
<d:UserId m:type="Edm.Int32">134</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">9</d:SiteProfileId>
<d:SessionsDurationSeconds m:type="Edm.Int32">3600</d:SessionsDurationSeconds>
<d:LogOns m:type="Edm.Int16">0</d:LogOns>
<d:LogOuts m:type="Edm.Int16">0</d:LogOuts>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=100,UserId=175,SiteProfileId=9)</id>
<category term="Itslearning.Reporting.Data.Models.UserLogin" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=100,UserId=175,SiteProfileId=9)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/UserLogins(SessionDateId=20161122,SessionTimeId=100,UserId=175,SiteProfileId=9)" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=100,UserId=175,SiteProfileId=9)/User" />
<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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=100,UserId=175,SiteProfileId=9)/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/UserLogins(SessionDateId=20161122,Sess
ionTimeId=100,UserId=175,SiteProfileId=9)/Time" />
<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/UserLogins(SessionDateId
=20161122,SessionTimeId=100,UserId=175,SiteProfileId=9)/SiteProfile" />
<title />
<updated>2016-12-21T10:57:13Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:SessionDateId m:type="Edm.Int32">20161122</d:SessionDateId>
<d:SessionTimeId m:type="Edm.Int32">100</d:SessionTimeId>
<d:UserId m:type="Edm.Int32">175</d:UserId>
<d:SiteProfileId m:type="Edm.Int32">9</d:SiteProfileId>
<d:SessionsDurationSeconds m:type="Edm.Int32">3600</d:SessionsDurationSeconds>
<d:LogOns m:type="Edm.Int16">0</d:LogOns>
<d:LogOuts m:type="Edm.Int16">0</d:LogOuts>
</m:properties>
</content>
</entry>
</feed>

Response body - JSON (default output format)

JSON response
{
"odata.metadata":"https://reporting.itslearning.com/odata/engine7/$metadata#UserLogins","value":[
{
"SessionDateId":20161122,"SessionTimeId":0,"UserId":1839,"SiteProfileId":8,"SessionsDurationSeconds":3600,"LogOns":0,"LogOuts":0
},{
"SessionDateId":20161122,"SessionTimeId":0,"UserId":5,"SiteProfileId":9,"SessionsDurationSeconds":3600,"LogOns":0,"LogOuts":0
},{
"SessionDateId":20161122,"SessionTimeId":0,"UserId":134,"SiteProfileId":9,"SessionsDurationSeconds":3600,"LogOns":0,"LogOuts":0
},{
"SessionDateId":20161122,"SessionTimeId":0,"UserId":175,"SiteProfileId":9,"SessionsDurationSeconds":3600,"LogOns":0,"LogOuts":0
},{
"SessionDateId":20161122,"SessionTimeId":0,"UserId":3343,"SiteProfileId":9,"SessionsDurationSeconds":3600,"LogOns":0,"LogOuts":0
},{
"SessionDateId":20161122,"SessionTimeId":0,"UserId":3940,"SiteProfileId":10,"SessionsDurationSeconds":3600,"LogOns":0,"LogOuts":0
},{
"SessionDateId":20161122,"SessionTimeId":100,"UserId":1839,"SiteProfileId":8,"SessionsDurationSeconds":3600,"LogOns":0,"LogOuts":0
},{
"SessionDateId":20161122,"SessionTimeId":100,"UserId":5,"SiteProfileId":9,"SessionsDurationSeconds":3600,"LogOns":0,"LogOuts":0
},{
"SessionDateId":20161122,"SessionTimeId":100,"UserId":134,"SiteProfileId":9,"SessionsDurationSeconds":3600,"LogOns":0,"LogOuts":0
},{
"SessionDateId":20161122,"SessionTimeId":100,"UserId":175,"SiteProfileId":9,"SessionsDurationSeconds":3600,"LogOns":0,"LogOuts":0
}
]
}