IBM Maximo: Listar a quantidade de logins únicos por dia
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