KACE Product Support : Create Service Desk report detailing tickets submitted by users by Departments (Location)

Create Service Desk report detailing tickets submitted by users by Departments (Location)

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

Department

User - Ticket No

etc.

Thank you in advance

3 Comments [ + ] Show comments

What are you going to use the report for? I'm guessing that you generated the report and broke on the Location column, so that is the output I would expect to see in Excel. If you generated an HTML report you would get a list of the locations with an arrow to expand each one to view the group. - chucksteel 6 years ago
Helo Chucksteel and thanks for getting back to me. It is a report for senior management who want to see what tickets have been submitted by the different departments. Even the HTML version is of no use. I need the information all on one row and not across two or more.

Thanks - Fola 6 years ago
- Using just a SQL statement that isn't really possible. You would need to use another tool to format the report, perhaps something like Crystal Reports or even Access. You can enable Off-Box DB access under Settings, Security Settings. - chucksteel 6 years ago
Hello Chucksteel, I am using flyspeed to connect to the back end of KACE but cannot find name of the table for locations. Do you have any idea what this will be called? - Fola 6 years ago
- Locations are an asset type, in particular they are asset type 1. If you just need the location name, then you can join to the asset table using USER.LOCATION_ID = ASSET.ID. If you want additional information for the asset it will be in ASSET_DATA_1. - chucksteel 6 years ago

Answers (0)

Be the first to answer this question

Answer this question

Posted by:

View more:

KACE Product Support Questions

question

Create Service Desk report detailing tickets submitted by users by Departments (Location)

Answers (0)

Posted by:

View more:

Related Questions

Related Links

Related Posts

KACE Product Support

Create Service Desk report detailing tickets submitted by users by Departments (Location)

Answers (0)

Posted by:

Don't be a Stranger!

View more:

Related Questions

Related Links

Related Posts

Share