Create Service Desk report detailing tickets submitted by users by Departments (Location)
04/08/2018 554 views
How can I create a report from Service Desk queue id (10) which gives me all tickets submitted by customers from the different departments (Location?). I am new to KACE and know nothing about SQL. I am trying to use Flyspeed to visually build queries but it is not giving me what I want.
I used the Report Wizard, that did give me the result I wanted but in excel the information for individual users was across two or three columns, which is not very helpful. See example of excel output below:
The output I would like is
User - Ticket No
Thank you in advance
There are no answers at this time