Questions & Answers
How helpful is this to you?
Kace K1000 Management Appliance
KACE Product Support
I have created a report but I cannot seem to define the column lengths, so the summary field takes up most of the width of the report.
Can I set the column width for reports?
[ + ] Show Comment
1 year ago
FYI: as a way to avoid this in my environment I truncate HD_TICKET.SUMMARY like this:
CONCAT(LEFT(HD_TICKET.SUMMARY,64),"\[...\]") as 'Summary'
Then the column will only include the first 64 chars of the Summary field
if you create with sql vs the wizard yes. You can also take a wizard report and view it as sql, copy the code and then just modify it for the widths you want and create a new report with that code
Answered 05/13/2016 by:
Answer this question
on this question for clarity
Don't be a Stranger!
Sign up today to participate, stay informed, earn points and establish a reputation for yourself!
Kace Service Desk - Queue Rule (send email to a group on new ticket creation) not working after update 7.1.149
Remove labels pop up box is blank
Different SLA settings
KACE Report on tickets with a specific subject
Can I setup an automated alert in the K1000 to be sent every 2nd Friday of every month?
How do I provision more disk space for Dell Updates from Patch Management
K1000 Management Appliance Documentation
K1000 Management Appliance Support
K1000 Management Appliance Product Page
IT certification gives federal job seekers an edge
K1000 UserVoice Feedback Forum
ITNinja Feedback Forum at UserVoice
KACE Launches AppDeploy Live
KACE Extends Leadership in Systems Management Appliances with Significant KBOX 1000 Series Upgrade
KACE Takes The Sting Out of 2007 Daylight Saving Time Changes
KBOX Systems Management Appliances Updated With Solaris Support, New Security Policies and Easier Agent Deployment
Education Market Manages Networks with KACE
New KBOX Appliances Bring Enterprise-Grade, Cross Platform IT Automation to Mid-Market
KACE Launches New Help Desk Module For Upgraded KBOX IT Management Applicance
Managing Dell Servers with the Dell KACE K1000 and Dell Open Manage