Web category report with user, category and hostname

[elpcat]

Hi everyone, I am working on a simple query on the FAZ, but im running into troubles with my sql query. The end result just needs to show individual rows where users have been blocked trying to access a particular web category. Something like time, user, category, and hostname. Here is my query and it appears to work as desired, but I run into problems when trying to set something like where catdesc=Pornography select from_dtime(dtime) as timestamp, `user` as usr, catdesc as category, hostname as hostname from $log-traffic where catdesc=Pornography order by dtime desc ERROR: column " pornography" does not exist LINE 1: ...s hostname from " mgrtmp_t_088d03bc" where catdesc=Pornograph... Any ideas? Thanks!

[Huai_Zhao]

Hi elpcat, Pornography need to be single quoted, pls try your query with catdesc=' Pornography' . By the way, do not forget $filter in order to apply filters to your query Regards, Huai Zhao

[elpcat]

Thanks! That worked like a charm.