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
6 months 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!
I would like to record the Windows Product Keys for my computers in my KACE inventory. Is it possible to get that information from an inventory update?
Kace site replication?
KACE - getting details on reopened tickets
When Will the K1000 Support Patching MacOS 10.12 (Sierra)?
Best Practices for Appliance backup
Anyone having issues upgrading from 6.4 to 7.0 kace 100?
Weirdness with K2000/Diskpart/Windows 10
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 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
K1000 Labels - Effective Organization & Process Flow Using Manual, Smart & LDAP Labels and Label Groups