Skip to main content
JoseOrosco
New Member
December 18, 2015
Solved

Help with dataset to show mails blocked by Email-Filter

  • December 18, 2015
  • 1 reply
  • 2914 views

Hi there,

 

Please i need help with a dataset that shows the number of mails blocked by address.

 

Is there anyone that can help me?.

 

Thanks in advance and best regards,

Jose

    Best answer by hzhao_FTNT

    log type: Email Filter

    select  `from` as mf_sender, count(*) as totalnum from $log where $filter and `from` is not null and action='blocked' group by mf_sender order by totalnum desc

     

    regards,

    hz

    1 reply

    hzhao_FTNT
    Staff
    Staff
    December 18, 2015

    log type: Email Filter

    select  `from` as mf_sender, count(*) as totalnum from $log where $filter and `from` is not null and action='blocked' group by mf_sender order by totalnum desc

     

    regards,

    hz

    JoseOrosco
    New Member
    December 18, 2015

    Thanks a lot!