Kace SMA - Wizard reports using SD Queue as topic brings tickets from all queues instead (4374763)

While a permanent fix is being evaluated for a future release, there are 2 workarounds to make these reports bring correct results:

• Adding a Filter to the wizard report by Queue Name

1. Navigate to Reporting › Reports 
2. The list of reports will show up, search for the affected report and click on its name
3. On the Edit report page, click on "Filters"
4. Click on the Pencil Icon to edit the sample Filter
5. on the dropdown menu look under Field Name for Queue Name
6. Leave the operator on "=" and enter the exact name of the queue in the value section
7. Click on the "add" button
8. Then click "Finish" at the button 

• Run the report in the desired format and it should only display tickets for the pertaining queue.

• Editing SQL to add the Queue ID on the WHERE clause of the queue

1. Navigate to Reporting › Reports 
2. The list of reports will show up, search for the affected report and click on its name
3. At the button click on the EDIT SQL button

• On the SQL section of the Report detail a WHERE clause needs to be added in order to filter for the desired Queue using the QUEUE ID as the image below