ITNinja

Hi Bruno,

most of the requirements are possible with the reporting wizard.

Please always communicate in English here, since only a small fraction of the users here are speaking Portugese. 
For your help I translated the title, so anyone who wants to help knows the topic.

Good evening!How is everything?I'm looking for something to filter a report of all open tickets in kace, or if possible determine by period being something around 12 months... would anyone have any tips on how to do this simple report.Thank Bruno

Tenta isso daqui brother:

SELECT T.TITLE AS "TITULO",
T.SUMMARY AS "DESCRIÇÃO",
T.CREATED AS "CRIADO EM",
P.NAME AS "PRIORIDADE",
U.FULL_NAME AS "PROPRIETÁRIO",
UU.FULL_NAME AS "EMISSOR",
S.NAME AS "STATUS",
Q.NAME AS "FILA",
C.NAME AS "CATEGORIA"

FROM HD_TICKET T

LEFT JOIN HD_PRIORITY P
ON P.ID = T.HD_PRIORITY_ID
LEFT JOIN HD_STATUS S
ON S.ID = T.HD_STATUS_ID
LEFT JOIN HD_QUEUE Q
ON Q.ID = T.HD_QUEUE_ID
LEFT JOIN HD_CATEGORY C
ON C.ID = T.HD_CATEGORY_ID
LEFT JOIN USER U
ON U.ID = T.OWNER_ID
LEFT JOIN USER UU
ON UU.ID = T.SUBMITTER_ID

WHERE T.CREATED > NOW() - INTERVAL 12 MONTH /*MUDAR DATA AQUI*/

ORDER BY T.CREATED DESC

Try writing the question in English next time XD

Edit: or the select between two dates change the WHERE statement to:

WHERE T.CREATED BETWEEN '2021-01-01' AND '2021-12-31'

Good evening! I'm looking for exactly that but there's a way to filter by closed period.. I'm trying to adjust this Line..but I don't know much about SQL... it's giving an error

WHERE T.CREATED > NOW() - INTERVAL '2021-01-01' AND '2021-12-31'

thank you so much for helping

It worked, thank you very much