Hello,
I am trying to run the query to pull the report as shown in the screenshot. The problem i am facing here is, Whenever i am seeing AlertCount greater than 1, Ticket ID will show as Null instead of listing all the ticket numbers.
Only when the AlertCount is 1, it is pulling the ticket number.
Can someone help me to customize this query so i can see all ticket numbers generated?



