select article, name, min(created), min(who)
  from (
select c.article, c.name, first_value(l.eventtime) over(partition by l.article order by l.eventtime) created, first_value(l.username) over(partition by l.article order by l.eventtime) who
  from SMCARD c, SMCardSecurityLog l
 where c.article = l.article
       )
 group by article, name
 having min(created) >= to_date('01.08.2016', 'dd.mm.yyyy')
 order by name
  

select article, name, created, who
  from (
select c.article, c.name,
       min(l.eventtime) keep (dense_rank first order by l.eventtime) created,
       min(l.username) keep (dense_rank first order by l.eventtime) who
  from SMCARD c, SMCardSecurityLog l
 where c.article = l.article
 group by c.article, c.name
       )
 where created >= to_date('01.08.2016', 'dd.mm.yyyy')
 order by name 

select c.article, c.name,
       min(l.eventtime) keep (dense_rank first order by l.eventtime) created,
       min(l.username) keep (dense_rank first order by l.eventtime) who
  from SMCARD c, SMCardSecurityLog l
 where c.article = l.article
 group by c.article, c.name
 having min(l.eventtime) >= to_date('01.08.2016', 'dd.mm.yyyy')
 order by c.name 

select article, name, eventtime, username
  from (
select c.article, c.name, l.eventtime, l.username,
       row_number() over (partition by c.article order by l.eventtime desc, l.recid desc) rn
  from SMCARD c, SMCardSecurityLog l
 where c.article = l.article
       )
 where rn = 1
   and eventtime > to_date('25.08.2016', 'dd.mm.yyyy')
 order by name