Questions & Answers
KACE SQL Report
KACE SQL Report
Kace K1000 Management Appliance
KACE Product Support
I am trying to run a report to show the total ticket count for a specific time frame. I just need a count for a psecific date range... no other data. What would the SQL for this look like?
[ + ] Show comments
Answer this question
Comment on this question
This is for tickets created between October 1 and October 9, inclusive, and specific to one queue.
DATE(CREATED) BETWEEN '2018-10-01' AND '2018-10-09'
AND HD_QUEUE_ID = 5
Answered 10/09/2018 by:
Don't be a Stranger!
Sign up today to participate, stay informed, earn points and establish a reputation for yourself!
Windows 10 Compatibility check - can KACE perform this?
Linux Agent Issue after v5.0 Upgrade
Help Desk Question
wuauclt.exe using 90% of CPU
Inventory vs Asset
Help Desk Email
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