K1000: How can I search for custom assets in a ticket field?
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
Answers (1)
Please log in to answer
Posted by:
grayematter
10 years ago
Check page 84 of the Service Desk Admin Guide. http://www.kace.com/support/resources/documentation
The syntax is "query:select * from table where ..."
Comments:
-
Thanks, how do i find the default table names? - agrossman 10 years ago
-
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. - grayematter 10 years ago
-
Thanks again, ill try this afternoon - agrossman 10 years ago
