confluence active users

[Jean-Philippe_Faivre]

How do we know who is actively using confluence?  Last Login, Activity, etc.. in one report...

[Vasiliy Zverev]

We use JIRA to manage Confluence users and we get last login date via this SQL

declare @startDate datetime = '1970-1-1';
Select
	cwd_user.display_name	as 'user name'
--	, cwd_user_attributes.*
	, CAST(  dateaDD(SECOND, CAST(cwd_user_attributes.attribute_value as bigint)/1000, @startDate ) as DATE) as 'last login date'
from
	cwd_user
	join	cwd_user_attributes on cwd_user.ID = cwd_user_attributes.user_id
where	
	cwd_user_attributes.attribute_name = 'login.lastLoginMillis'
--	and cwd_user.email_address = 'vzverev@phosagro.ru'
order by
	CAST(cwd_user_attributes.attribute_value as bigint) asc