1
ANSWERS
SMA SQL: Subcategory question
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 months ago 0 views
jct134 commented 3 months 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
4 months ago 0 views
jct134 answered 4 months 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
4 months ago 0 views
jct134 commented 4 months ago
1
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
4 months ago 0 views
Hobbsy answered 4 months ago
1
ANSWERED
My Update SQL has an issue...
KACE Product Support
Scripting
Miscellaneous
K1000 SQL
Custom Ticket Rules
KACE SQL
SQL
K1000 Custom Email Rules
K1000 Custom Ticket Rules
Custom Ticket Rule
By:
jct134
4 months ago 0 views
IgorAngelini commented 4 months 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 Email Rules
K1000 Custom Ticket Rules
Custom Ticket Rule
By:
jct134
4 months ago 0 views
IgorAngelini commented 4 months 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
5 months ago 0 views
IgorAngelini answered 5 months ago
2
ANSWERED
Help with SQL code
KACE Product Support
Scripting
Miscellaneous
K1000 Ticket Rules
Kace Ticket rule
K1000 SQL
KACE K1000 Service Desk
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
6 months ago 0 views
jct134 answered 6 months 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
7 months ago 0 views
jct134 answered 6 months 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
7 months ago 0 views
BNewland answered 6 months 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
7 months ago 0 views
jct134 answered 7 months 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
7 months ago 0 views
jct134 answered 7 months ago
1
ANSWERS
Kace report to list versions of one software on all machines that have a different software installed.
1
ANSWERS
Auditing Kace assets through the API/Database
3
ANSWERS
Help with Custom SQL for ticket rule
1
ANSWERS
Stage Windows Feature Report
2
ANSWERS
Live Feed to PowerBI
Kace K1000 Management Appliance
KACE Product Support
Kace Service Desk
SQL
Microsoft PowerBI Desktop (x64)
By:
rruhl
1 year ago 102 views
kiwiblue answered 1 year 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
Managing tablets
sql server tool
Oracle sql devloper
sql code formatter
By:
duncant-wssu
1 year ago 268 views
duncant-wssu answered 4 months ago
1
ANSWERS
Inventory Device Query
1
ANSWERED
Report to show computers that do not have certain software installed
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
2 years ago 270 views
CSelles commented 2 years ago
2
ANSWERS
How do I limit this SQL Query to either a single or multiple Smart Labels?
KACE Product Support
Systems Management
Patch Management
K1000 Patching
KACE SQL
SQL
Patching report
Patch report
By:
poisedforflight
2 years ago 419 views
poisedforflight commented 2 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
Patch Management
K1000 Patching
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
K1000 Security Patching
patch scheduling
sql query tool
Patch report
Patch Detection
KBOX 1000 Series Systems Management Appliance, KBOX 2000 Series Systems Deployment Appliance
By:
wesellis23
3 years ago 838 views
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
3 years ago 1.5k views
RD94 answered 2 years ago
1
ANSWERS
Kace K1000 SQL query for the 'missing' flag on a patch
1
ANSWERED
Kace SQL query with Installed Software and Discovered Software
1
ANSWERS
2
ANSWERED
Run a report with Ship date by Label
Miscellaneous
K1000 Reporting
kace reporting
K1000 SQL
KACE Custom Report
KACE SQL
KACE Custom Reports
KACE Reports
customized report
SQL
By:
billyITguy
4 years ago 1.2k views
billyITguy answered 4 years ago
1
ANSWERED
In the following SQL statement, what does the < > operators do?
1
ANSWERS
SQL Reporting
1
ANSWERS
K1000 SQL Report Help Request
Kace K1000 Management Appliance
Software
Systems Management
K1000 Reporting
kace reporting
K1000 SQL
Report
SQL
By:
tramiksim
4 years ago 1.3k views
JasonEgg answered 4 years ago
2
ANSWERED
Creating (<TICKET_IDS>) variable array - Correct Syntax
2
ANSWERED
SQL to update asset table from the Inventory - placed in Helpdesk rules?
1
ANSWERS
SQL Help - Aging of Machines
0
ANSWERS
0
ANSWERS
1
ANSWERS
Trouble connecting the SQL dots
1
ANSWERS
SQL help please
KACE Product Support
Systems Management
Best Practices
Miscellaneous
K1000 SQL
KACE SQL
SQL
Help Desk
Sql Server
By:
tramiksim
4 years ago 816 views
chucksteel answered 4 years ago
1
ANSWERED
Having SQL trouble efficiently connecting asset table fields.
1
ANSWERS
K1000-Reports - How do I show the managers name in a report instead of the users ID.
Kace K1000 Management Appliance
KACE Product Support
Scripting
K1000 Reporting
K1000 SQL
KACE SQL
SQL
By:
aniles
4 years ago 834 views
aniles answered 4 years ago
1
ANSWERS
KACE - SQL Query Assistance Needed
Kace K1000 Management Appliance
KACE Product Support
Scripting
Software
Kace
kace reporting
K1000 SQL
K1000 Inventory
KACE SQL
KACE Reports
SQL
KACE Software Library
By:
carlosmen93
4 years ago 1.3k views
Hobbsy answered 4 years ago
1
ANSWERED
SQL smart label doesn't apply to any machine
2
ANSWERS
SCCM\SQL Query for specific software company not in Add\Remove Programs
Software
Miscellaneous
Microsoft System Center Configuration Manager (SCCM)
SCCM 2012
Report
SQL
Reporting
SCCM Reporting
SCCM Client Center
By:
DaBXRoMeO
5 years ago 11k views
MikhailCompo answered 5 years ago
2
ANSWERS
Stuck with SQL query - How do I exclude a group of machines by machine.name
2
ANSWERS
K1000 7.0 Upgrade SQL Populate Department Field No Longer Works
Kace K1000 Management Appliance
KACE Product Support
K1000 Reporting
K1000 SQL
KACE SQL
SQL
Ticket Fields
Upgrade
By:
agahlbeck
5 years ago 1.6k views
JasonEgg commented 5 years ago
Showing 1 - 50 of 100 results