O Select a seguir faz a listagem de logins únicos por dia no IBM Maximo.

English: The following Select lists the unique logins by day in IBM Maximo.

select dt, count(1)
from (
   select to_char(ATTEMPTDATE,'YYYY-MM-DD') as dt,userid,count(1)
   from logintracking
   where attemptresult='LOGIN'
   GROUP BY to_char(ATTEMPTDATE,'YYYY-MM-DD'),userid
   ORDER BY to_char(ATTEMPTDATE,'YYYY-MM-DD') DESC
)
group by dt
order by dt desc

Ver também