We noticed that Custom fields such as Owner, Assets, and Machine has filters to them. So I'm trying to find out if there is a query that would let me create a filter for a custom field.

 

Thanks

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

If I am reading the question correctly, you would like to use a custom asset within the service desk, but only show some entries of that custom asset within the service desk field.  

 

If that is correct, you can write a simple query of that custom asset using the reporting module and then insert the mysql into the values for the custom field.  

Step 1 - jump into reporting and create a single select report with your appropriate filter in place.  

Step 2 - go into that report and edit the SQL

Step 3 - copy the SQL and jump over to your service desk queue and click on Customize These Values within the queue you want to edit.  

Step 4. Create a custom field as signal select or whatever is appropriate 

Step 5. Paste in the mysql for the select Values

 

That should be it.  Let me know if you have any trouble.  

Answered 02/10/2014 by: Jbr32
Tenth Degree Black Belt

  • Can you indicate what DATA_17 and FIELD_107 is? If DATA_17 is the asset number, where would I look to find out which one I need?
    • That information was provided to me from Kace within the reporting module. If you jump over to the reporting module and create a custom report with only one column being returned (including the filter) the reporting module will spit out the mysql.
      • You then take the mysql over to the service desk and it should work within a custom field. Make sure to preface the mysql with query=

        Forgot to mention that
      • Here's what the report comes up with:

        SELECT ASSET.NAME AS ASSET_NAME FROM ASSET_DATA_1 LEFT JOIN ASSET ON ASSET_DATA_1.ID = ASSET.ASSET_DATA_ID AND ASSET.ASSET_TYPE_ID=1 ORDER BY ASSET_NAME

        Now I tried what you indicated, but getting error message.
Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share