/build/static/layout/Breadcrumb_cap_w.png

find a ticket based on attachment name

Simple report, but will show the ticket ID(s) for a given filename of a ticket comment attachment

Could also be used to auto delete malicious items. E.g. infection.zip emails come in, automatically delete the ticket.

***************************************************************************************

SELECT HD_ATTACHMENT.FILE_NAME,
HDT.ID as TICKET_ID

FROM `ORG1`.`HD_ATTACHMENT`

JOIN HD_TICKET_CHANGE HDTC ON (HDTC.ID = HD_ATTACHMENT.HD_TICKET_CHANGE_ID)
JOIN HD_TICKET HDT ON (HDT.ID = HDTC.HD_TICKET_ID)

WHERE FILE_NAME LIKE '%FILENAME%';


Comments

This post is locked
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ