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