que

SELECT FIRST(UTF8(payload)) as PayloadUtf, logsourceid, LOGSOURCENAME(logsourceid) as LogSourceAdi,QIDDESCRIPTION(qid),QIDNAME(qid), LoGSOURCEGROUPNAME(logsourceid),category, LOGSOURCETYPENAME(logsourceid), CATEGORYNAME(category), "Event Summary" from events where sourceip IS NOT NULL group by CATEGORYNAME(category), LogSourceAdi