This query will help you:
with [Lic] AS (
select distinct [EntryKey], [IsActive]
from [EIACL_CurrentLicenses]
where [License] like '%SUPERVISOR%'
),
[Log] AS (
select [UserId], max([ActionDateTime]) [LastLoginDateTime]
from [LoginLogoutChangeLog_viw] [Log]
where [ApplicationName] = 'ic business manager' and [Action] = 1 --login
group by [UserId] having max([ActionDateTime]) < getdate()-60 -- Last login 60 days ago
)
select [Log].[Userid], [Log].[LastLoginDateTime], isnull([Lic].[IsActive], 0) [HasLicense]
from [Log]
left join [Lic] on [Log].[Userid] = [Lic].[EntryKey]
------------------------------
Edward de Wit
3Fiftynine B.V.
------------------------------
Original Message:
Sent: 09-06-2019 04:38
From: Edward de Wit
Subject: Supervisor Login and Logout report in ICBM.
Surya,
You have to activate the corresponding Report Log in the Administrator.
LogId = 9
------------------------------
Edward de Wit
3Fiftynine B.V.
Original Message:
Sent: 09-06-2019 04:04
From: Surya Kotey
Subject: Supervisor Login and Logout report in ICBM.
Hi Todd Kruid,
Thanks for the reply.
We checked LoginLogoutChangeLog Table in our Database but those tables are not capturing data.Can you give us an idea how to capture that LoginLogout Data in LoginLogoutChangeLog Table .
------------------------------
Surya Kotey
CXP LAB PTE LTD
Original Message:
Sent: 09-05-2019 09:42
From: Todd Kruid
Subject: Supervisor Login and Logout report in ICBM.
​One could probably build a report using the table named "LoginLogoutChangeLog". It contains the login and logout date/time for each application the user has used. Link this table to the table named "ICApplications" by the ApplicationID field to determine which ID belongs to IC Business Manager. In our environment it has an ID of 5. Good luck!
------------------------------
Todd Kruid
Midcontinent Communications
Original Message:
Sent: 08-30-2019 04:30
From: Surya Kotey
Subject: Supervisor Login and Logout report in ICBM.
Hi Team,
I would like to know that, Is there any possibility to fetch the supervisor login and logout reports in ICBM.
#Reporting/Analytics
------------------------------
Venkat
Cexlab
------------------------------