Hi everyone:
i'm trying to make a dashboard item with offense data, i would like create query, but a cant find the id offense, someone know the name of the field id_offense to use in query, I wold like some like this
This is my query
SELECT QIDNAME(qid) as evento,DATEFORMAT(starttime, 'dd-MM-YYY HH:MM:SS') as "Date"
FROM events
where domainid =2 and logsourceid = 163 and evento ILIKE 'LATAM%%'
ORDER BY date DESC
LAST {time_span}
Thans in advnace
------------------------------
Luis Enrique Rodriguez Martinez
------------------------------