Is there a way to find out if a user is logging into the Console or not?

Products

• Client Management Suite
• IT Management Suite

Issue/Introduction

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?

Environment

ITMS 8.x

Resolution

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

Additional Information

173483 "Using Item Trackers to audit/research who made changes in the Management Console"
173227 "Is there a way to track the activities of IT Management Suite administrators?"