I want to be able to search for custom assets in a ticket field.  I just want to have the location search in a field, not all the assets in the database.  Im not sure of the SQl query

Need to create a SQL query to select only locations in a selectable field on a ticket

0 Comments   [ + ] Show Comments


Please log in to comment



Check page 84 of the Service Desk Admin Guide.  http://www.kace.com/support/resources/documentation

The syntax is "query:select * from table where ..."

Answered 08/19/2013 by: grayematter
Fourth Degree Black Belt

  • Thanks, how do i find the default table names?
    • The tables are listed in the Administrator Guide. The easiest thing to do is build the query with the reporting wizard, then copy the generated SQL. You can also tweak the query with an SQL tool like MySQL Workbench or TOAD.
  • Thanks again, ill try this afternoon
Please log in to comment
Answer this question or Comment on this question for clarity