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!
Having trouble removing modern apps from Windows 10 using Kace K1000
Having an issue with computers renaming themselves thus being removed as an asset.
K1000 - Send additional survey after 90 days
Why is WIN64DUALFOLDERS Coming Into Play All Of A Sudden? Please HELP!!
Any recommendations how to track Licensing Compliance in KACE for Third Party Licenses?
How to convert pxe booting legacy BIOS systems from pxe-linux to ipxe or undionly that supports legacy and UEFI systems for K2000
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
Did you miss the first KACE Education Virtual User Group webinar? View the recording now.
KACE SMA - Windows 10 End of Support Report