An Admin gave a group access to the Console, and is curious if the group is logging into the Console or not. Is there a report we could run that would show who has logged into the Console?
Is there a report that would show the first time and last time a user logged into the Console?
ITMS 8.x
The UserSettings table holds the state information for each user. For example, if you run a report with a specific group it will remember that group when you come back to that report. User Settings also is what remembers which item you viewed last, i.e. reports, so when you go back to Reports, it takes you to the last one you viewed.
Using this information in the database we can see when someone first Viewed items in the Console, and the last time they viewed items, creating a picture of when they first opened the console, and the last time they opened the console.
You can create a SQL Report in the Console to run this, or execute directly in SQL:
select i.Name as [User], 'First Login' as Login, us.CreatedDate as 'Date'
from UserSettings us
left join item i
on substring(us.SID,2, 36) = convert(nvarchar(36),i.Guid)
where us.CreatedDate in (select MIN(CreatedDate) from UserSettings where Guid = i.Guid group by SID)
Union
select i.Name, 'Last Login', us.ModifiedDate
from UserSettings us
left join item i
on substring(us.SID,2, 36) = convert(nvarchar(36),i.Guid)
where us.ModifiedDate in (select MAX(ModifiedDate) from UserSettings where Guid = i.Guid group by SID)
order by 1, 3