1
ANSWERS
SQL for Patch ID Status (Smart Label)
Scripting
Software
Systems Management
Best Practices
Miscellaneous
K1000 Reporting
K1000 Scripting
kace reporting
K1000 SQL
K1000 Smart Labels
KACE SQL
Kace Scripting
Smart Labels
Report
KACE Custom Reports
SQL
KACE1000 Smart Label
SQL Query
By:
seanboy
1 week ago 0 views
Hobbsy answered 1 week ago
0
ANSWERS
2
ANSWERS
Syntax errors on extremely basic SQL queries
0
ANSWERS
2
ANSWERS
Create a rule for send an email to specific KACE administrator when a new ticket arrive to specific Queue
KACE Product Support
K1000 Service Desk
K1000 Ticket Rules
Kace Ticket rule
KACE K1000 Service Desk
K1000 SQL
Custom Ticket Rules
KACE SQL
By:
floresc
2 years ago 0 views
JordanNolan answered 2 years ago
2
ANSWERED
Create a KACE Ticket Rule to change Due Date based on custom field
Kace K1000 Management Appliance
KACE Product Support
Kace
K1000 Service Desk
K1000 Ticket Rules
Kace Ticket rule
K1000 SQL
Custom Ticket Rules
Ticket Rule
SQL
By:
trankin
2 years ago 0 views
trankin answered 2 years ago
2
ANSWERS
Assistance with Report - SQL Query to populate data in feilds
KACE Product Support
Scripting
K1000 Service Desk
K1000 SQL
Service Desk
Kace Service Desk
SQL
sql query tool
servicedesk
By:
mscott003
2 years ago 0 views
mscott003 answered 2 years ago
2
ANSWERS
Daily Reminder Email
1
ANSWERS
SQL custom ticket rule * PLEASE HELP *
KACE Product Support
Scripting
K1000 Ticket Rules
Kace Ticket rule
K1000 SQL
Custom Ticket Rules
Ticket Rule
SQL
K1000 Custom Ticket Rules
Parent / Child Tickets
sql query editor
By:
jct134
2 years ago 0 views
barchetta commented 2 years ago
2
ANSWERS
SMA SQL: Subcategory question
2
ANSWERS
Kace Patch Compliance Report by OS Version
0
ANSWERS
Custom Reports in SQL
2
ANSWERS
Issue with SQL Code -- Please help
KACE Product Support
Scripting
Miscellaneous
K1000 SQL
Custom Ticket Rules
KACE SQL
SQL
K1000 Custom Ticket Rules
Custom Ticket Rule
sql query editor
By:
jct134
2 years ago 0 views
jct134 commented 2 years ago
1
ANSWERS
SQL - need to change status of a particular sibling ticket when another sibling is closed.. but not change that status if the sibling is already closed.
KACE Product Support
Scripting
Miscellaneous
K1000 SQL
Custom Ticket Rules
KACE SQL
SQL
K1000 Custom Ticket Rules
Custom Ticket Rule
sql query editor
By:
jct134
2 years ago 0 views
jct134 answered 2 years ago
1
ANSWERED
Custom ticket rule to get substring of HD_TICKET.TITLE
KACE Product Support
Scripting
Miscellaneous
K1000 SQL
Custom Ticket Rules
KACE SQL
SQL
K1000 Custom Ticket Rules
Custom Ticket Rule
sql query editor
By:
jct134
2 years ago 0 views
jct134 commented 2 years ago
2
ANSWERS
Does anyone know how to export database & import into a SQL program like DBeaver for running some testing SQL
KACE Product Support
Miscellaneous
K1000 SQL
KACE SQL
SQL
sql query tool
sql query editor
database tools
sql query builder
mysql database tools
By:
jct134
2 years ago 0 views
gvega answered 1 year ago
1
ANSWERED
My Update SQL has an issue...
KACE Product Support
Scripting
Miscellaneous
K1000 SQL
Custom Ticket Rules
KACE SQL
SQL
K1000 Custom Ticket Rules
K1000 Custom Email Rules
Custom Ticket Rule
By:
jct134
2 years ago 0 views
IgorAngelini commented 2 years ago
2
ANSWERED
When ticket is closed, pull the comment from the parent ticket into variable to use in sending e-mail
KACE Product Support
Miscellaneous
K1000 SQL
Custom Ticket Rules
KACE SQL
SQL
K1000 Custom Ticket Rules
K1000 Custom Email Rules
Custom Ticket Rule
By:
jct134
2 years ago 0 views
IgorAngelini commented 2 years ago
2
ANSWERS
1
ANSWERS
Number of tickets by category report
KACE Product Support
K1000 Reporting
kace reporting
K1000 SQL
KACE SQL
Report
KACE Reports
SQL
Reporting
By:
sabroo
2 years ago 0 views
IgorAngelini answered 2 years ago
2
ANSWERED
Help with SQL code
KACE Product Support
Scripting
Miscellaneous
K1000 Ticket Rules
Kace Ticket rule
KACE K1000 Service Desk
K1000 SQL
Custom Ticket Rules
KACE SQL
Ticket Rule
SQL
K1000 Custom Ticket Rules
Custom Ticket Rule
K1000 custom ticket rule
Kace Ticket Rules
Kace 1000 Ticket Rule
By:
jct134
3 years ago 0 views
jct134 answered 3 years ago
1
ANSWERS
Archive user through EXIT custom ticket rule
KACE Product Support
Scripting
Systems Management
Miscellaneous
K1000 Ticket Rules
K1000 Custom Inventory Rules
K1000 SQL
KACE SQL
SQL
sql query tool
By:
jct134
3 years ago 0 views
jct134 answered 3 years ago
2
ANSWERS
Automatic archival of users based on LDAP/AD disabled status
Kace K1000 Management Appliance
KACE Product Support
Scripting
Miscellaneous
K1000 SQL
KACE SQL
LDAP
SQL
mySQL Query
Active Directory (AD)
MySQL
K1000 Users
Archive
By:
BNewland
3 years ago 0 views
BNewland answered 3 years ago
1
ANSWERS
Ticket rule to send an email to User when a ticket is Escalated
1
ANSWERED
SQL that if ticket A is set to certain status, the sibling ticket has status set to NEW & moved to another Queue
KACE Product Support
Systems Management
Miscellaneous
K1000 Ticket Rules
K1000 SQL
Custom Ticket Rules
KACE SQL
Ticket Rule
SQL
K1000 Custom Ticket Rules
Custom Ticket Rule
K1000 custom ticket rule
Kace Ticket Rules
By:
jct134
3 years ago 0 views
jct134 answered 3 years ago
2
ANSWERED
Issue trying to use ticket custom field data in email output from custom ticket rule
KACE Product Support
Scripting
Miscellaneous
K1000 SQL
Custom Ticket Rules
KACE SQL
SQL
K1000 Custom Ticket Rules
Custom Ticket Rule
K1000 custom ticket rule
sql query tool
Custom Ticket Field
By:
jct134
3 years ago 0 views
jct134 answered 3 years ago
1
ANSWERS
Getting SSl error when connecting to the kace database with sql workbench
1
ANSWERS
Getting the table names of my assets when connecting to the k1000 database with sql-express DMS
1
ANSWERS
k1000 Ticket Rule help
2
ANSWERED
Need Patch SQL script to show the device patching status and percent report
Kace K1000 Management Appliance
KACE Product Support
Scripting
Systems Management
Security
K1000 SQL
KACE SQL
Patching report
By:
Nykko
3 years ago 0 views
Nykko answered 3 years ago
3
ANSWERS
Help with Custom SQL for ticket rule
1
ANSWERS
Multi-stage approval concept
1
ANSWERS
SQL + K1000: time spent on hotline per department, for every technicians
Kace K1000 Management Appliance
Scripting
K1000 Reporting
KACE K1000 Service Desk
K1000 SQL
Microsoft PowerBI Desktop (x64)
By:
pro4linfo
3 years ago 0 views
JasonEgg answered 3 years ago
0
ANSWERS
Ticket Rule: CustomerResponded
Kace K1000 Management Appliance
KACE Product Support
Scripting
K1000 Ticket Rules
K1000 SQL
helpdesk
By:
CSVIT
4 years ago 226 views
CSVIT commented 4 years ago
3
ANSWERS
Table Layout
KACE Product Support
Scripting
Best Practices
K1000 SQL
KACE SQL
SQL
sql query tool
sql query editor
KACE Asset Tables
sql query builder
SQL Server Managment Studio 2012
sql server tool
Managing tablets
Oracle sql devloper
sql code formatter
By:
duncant-wssu
4 years ago 268 views
duncant-wssu answered 2 years ago
1
ANSWERS
Inventory Device Query
1
ANSWERS
I need a SQL report that show me Connected computers and a specific software.
2
ANSWERS
A question about sql syntax
1
ANSWERED
Report to show computers that do not have certain software installed
2
ANSWERS
Is there a way to automate assigning ticket owner and submitter via email?
KACE Product Support
K1000 Service Desk
K1000 Ticket Rules
KACE K1000 Service Desk
K1000 SQL
email ticket generation
K1000 Custom Ticket Rules
K1000 Custom Email Rules
format of email
k1000 email rules
By:
JRUGAMA
4 years ago 299 views
Hobbsy answered 4 years ago
2
ANSWERED
Trying to use Patching Report SQL Query as Smart Label
0
ANSWERS
I currently have a report that is pulling total hours work and work notes I am wanting to get it to pull the ticket type also
0
ANSWERS
SQL - List missing patch per device
KACE Product Support
K1000 Reporting
kace reporting
K1000 SQL
KACE Custom Report
KACE SQL
KACE Custom Reports
KACE Reports
SQL
Reporting
Patching report
By:
scoterland
4 years ago 270 views
CSelles commented 4 years ago
1
ANSWERS
I want to display only device with an arrow icon. anyone can help me this SQL query. Thanks
1
ANSWERS
Need help updating custom sql report on version10
1
ANSWERED
Need help updating custom sql report on version10 -> Patch Schedule Not Completed
1
ANSWERS
What is the proper SQL to create a report that only shows missing patches using the GROUP_CONCAT
Showing 1 - 50 of 209 results
