How do I determine which users are logging into Insight and when?

Products

Webtrends Analytics 9.x

Cause

Information about what users are logging into Insight and when they are logging in is captured in the SQL database attached to the Webtrends installation.

Resolution

The following query can be used to acquire this information:

select UserName,logindate
from wtmaster.dbo.wt_UserLoginHistory
where UserActivityTypeID=13
order by LoginDate;