/build/static/layout/Breadcrumb_cap_w.png

Getting Locations in a ServiceDesk Dropdown

AB9BVSUHWWS0AAAAAElFTkSuQmCC

A common question we get asked is how to get a dropdown in the ServiceDesk that contains the locations of users.

In the Queue setup area, if you scroll down to the CUSTOM FIELDS area and click on the little Question mark a grey help panel is revealed.

Whilst this is really helpful as it shows you how to embed an SQL Query into a single select field, the data in the grey box as an example

"For example, to display a list of employee locations based on data stored in user records, use "query: select distinct(LOCATION) from USER"

Is so out of date and unhelpful it is laughable!!!

Here is the query we use occasionally, which basically looks at the imported user records and compiles a list of locations found, from the main Asset Location table

query: SELECT DISTINCT(ASSET.NAME) FROM USER USER INNER JOIN ASSET ASSET ON (USER.LOCATION_ID = ASSET.ID) WHERE ASSET.ID = USER.LOCATION_ID

We hope you find this useful.

Other Indigo Mountain Products and Services


BarKode for KACE - Enabling effective Asset Management Best Practice

For more information about BarKode click here or download a demo appliance here


Comments

  • It is half helpful, because adding that custom field generates a drop down list of all possible locations. Is it possible to select from that list just the location belonging to the submitter? I imagine there should a variable holding the current ticket id? - Empousa 1 day ago
This post is locked
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ