1
ANSWERED
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
3 months ago
0 views
seanboy commented 2 months ago
1
ANSWERS
How Do I Create a Custom Ticket Rule that Calculates how Long A Ticket Has Been 'Opened', Taking into Account Business Hours?
--------------------
By:
ehofrichter
11 months ago
0 views
Hobbsy answered 10 months ago
0
ANSWERS
1
ANSWERS
KACE SMA - Updating Asset Status to Active using Custom Ticket Rule
KACE Product Support
Systems Management
Miscellaneous
Custom Ticket Rules
KACE SQL
K1000 Device Asset
--------------------
By:
FrankCastle42
1 year ago
0 views
Hobbsy answered 1 year ago
1
ANSWERS
How to pull info from "History" tab in ticket to a report
--------------------
By:
Mike_Rainey
1 year ago
0 views
Hobbsy answered 1 year ago
0
ANSWERS
Best way to format date in a report for Excel?
--------------------
By:
ISEKOLD
2 years ago
0 views
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
ANSWERS
Kace Patch Compliance Report by OS Version
--------------------
By:
ninjashaqss
2 years ago
0 views
barchetta answered 2 years ago
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
3 years ago
0 views
jct134 commented 3 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
3 years ago
0 views
jct134 answered 3 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
3 years ago
0 views
jct134 commented 3 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
3 years ago
0 views
gvega answered 2 years 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
3 years ago
0 views
IgorAngelini commented 3 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
3 years ago
0 views
IgorAngelini commented 3 years ago
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
3 years ago
0 views
IgorAngelini answered 3 years ago
blog post
Create Smart Label Based on Metering Data
Software Deployment
Systems Management
K1000 Managed Installations (MI)
K1000 SQL
K1000 Smart Labels
KACE SQL
Smart Labels
Kace K1000 Management Appliance 13
K1000 Metering
--------------------
By:
IgorAngelini
3 years ago
1.7k views
3
ANSWERS
Email Notification for Low Disk Space (server)
--------------------
By:
hurmoth
3 years ago
0 views
IgorAngelini answered 3 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
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
Kace report to list versions of one software on all machines that have a different software installed.
--------------------
By:
cheslja09
3 years ago
0 views
Mashby1 answered 3 years ago
2
ANSWERED
Service Desk Rule to run only once
--------------------
By:
rbaranowicz
3 years ago
0 views
Hobbsy commented 3 years ago
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
--------------------
By:
jct134
3 years ago
0 views
lee@spica.one commented 3 years ago
blog post
Report to get when a software was installed on a machine
KACE Product Support
Software
Systems Management
Supporting Windows
K1000 Reporting
kace reporting
K1000 SQL
KACE Custom Report
KACE SQL
Report
KACE Custom Reports
KACE Reports
customized report
SQL
Reporting
Software License Compliance
bison 2
--------------------
By:
RandomITdude24
3 years ago
2.9k views
blog post
Report - Patches Missing By Devices IF Device Is Missing Patches
--------------------
By:
poisedforflight
3 years ago
1.6k views
blog post
How to Patch newly deployed Computer
Kace K1000 Management Appliance
Software Deployment
Systems Deployment
Patch Management
Dell K1000 Agent
K1000 SQL
KACE SQL
SQL
--------------------
By:
kayroccs
4 years ago
4.5k views
1
ANSWERS
Having problems with SQL code not selecting correctly on ticket rules
--------------------
By:
dnapier6770
4 years ago
70 views
Hobbsy answered 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 Server Managment Studio 2012
sql server tool
sql query builder
Managing tablets
Oracle sql devloper
sql code formatter
--------------------
By:
duncant-wssu
4 years ago
268 views
duncant-wssu answered 3 years ago
1
ANSWERS
Inventory Device Query
--------------------
By:
duncant-wssu
4 years ago
222 views
chucksteel commented 4 years ago
1
ANSWERS
I need a SQL report that show me Connected computers and a specific software.
--------------------
By:
Malena_05
4 years ago
265 views
chucksteel answered 4 years ago
link
How to Repair MDF File and Restore SQL Database Objects
--------------------
By:
prince0052
4 years ago
2.4k views
2
ANSWERS
A question about sql syntax
--------------------
By:
Flemtone
4 years ago
198 views
chucksteel answered 4 years ago
1
ANSWERED
Report to show computers that do not have certain software installed
--------------------
By:
Need Help
4 years ago
304 views
Need Help commented 4 years ago
2
ANSWERS
SQL report: show computers with missing information
--------------------
By:
SGV AG
4 years ago
189 views
chucksteel answered 4 years ago
blog post
KACE Patch Report for missing Patches for a Patch Job - for SMA running version 10 and up
Kace K1000 Management Appliance
KACE Product Support
Software
Systems Management
Supporting Windows
Best Practices
Miscellaneous
K1000 Reporting
K1000 Patching
Patch Management
kace reporting
K1000 SQL
Patching
Windows 10
KACE SQL
KACE Patching
Microsoft Windows 10
Report
KACE Custom Reports
KACE Reports
customized report
SQL
Reporting
bison 2
--------------------
By:
RandomITdude24
4 years ago
4k views
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
--------------------
By:
Daniel Thenu
4 years ago
262 views
airwolf answered 4 years ago
2
ANSWERS
How do I limit this SQL Query to either a single or multiple Smart Labels?
KACE Product Support
Systems Management
K1000 Patching
Patch Management
KACE SQL
SQL
Patching report
Patch report
--------------------
By:
poisedforflight
5 years ago
419 views
poisedforflight commented 5 years ago
0
ANSWERS
SQL Query LDAP User Info
--------------------
By:
DLCurtis
5 years ago
410 views
1
ANSWERED
Help with KACE SQL
--------------------
By:
Cyber Morgan
5 years ago
366 views
Cyber Morgan commented 5 years ago
1
ANSWERS
SQL query based smart label
Kace K1000 Management Appliance
KACE Product Support
Systems Management
Supporting Windows
K1000 Smart Labels
KACE SQL
Smart Labels
Kace SMA (k1000)
K1000 SMA
KACE Systems Management Appliance (K1000)
--------------------
By:
tahirebi
5 years ago
505 views
tahirebi commented 4 years ago
1
ANSWERED
need SQL or PS1 help to change a ticket owner
KACE Product Support
Scripting
K1000 Ticket Rules
Kace Ticket rule
K1000 SQL
Custom Ticket Rules
KACE SQL
email ticket generation
--------------------
By:
auntie4life
5 years ago
385 views
auntie4life commented 5 years ago
1
ANSWERED
Looking for help modifying current SQL rule
--------------------
By:
rbaranowicz
5 years ago
347 views
rbaranowicz commented 5 years ago
0
ANSWERS
KACE Report to find a machines dell update "Updated State"
Kace K1000 Management Appliance
KACE Product Support
Scripting
Systems Management
K1000 Reporting
Hardware
K1000 Scripting
K1000 Patching
Patch Management
KACE 1000
kace reporting
K1000 SQL
Patching
KACE Custom Report
KACE SQL
KACE Patching
Kace Scripting
Report
Dell
KACE Custom Reports
KACE Reports
customized report
Update Management
SQL
Reporting
Patching report
patch scheduling
K1000 Security Patching
Patch report
sql query tool
Patch Detection
KBOX 1000 Series Systems Management Appliance, KBOX 2000 Series Systems Deployment Appliance
--------------------
By:
wesellis23
5 years ago
838 views
1
ANSWERED
SQL Works in all Queues except one - Cannot identify the problem
Systems Management
K1000 SQL
Custom Ticket Rules
KACE SQL
K1000 Custom Ticket Rules
K1000 Custom Email Rules
--------------------
By:
jessburd
5 years ago
378 views
jessburd commented 5 years ago
1
ANSWERS
How to get Deploy Status Error Codes on Report?
Kace K1000 Management Appliance
KACE Product Support
Scripting
Kace
K1000 Reporting
KACE 1000
K1000 SQL
KACE Custom Report
KACE SQL
Report
SQL
--------------------
By:
joshkkoehler
5 years ago
1.5k views
RD94 answered 5 years ago
1
ANSWERS
Create custom report for service ticket using keywords located in the summary or comments sections
--------------------
By:
dhug
6 years ago
556 views
dhug commented 6 years ago
Showing 1 - 50 of 140 results