/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Custom Field in Queue Customization

10/04/2018 327 views
I'm trying to Custom Field as Manager to pull the manager from User. According to Kace, I can pull location "query: select distinct(LOCATION) from USER". Can I pull Manager using this query? I tried changing LOCATION with MANAGER and that did nothing. It just shows up as a drop down menu with the actual "query: select distinct(LOCATION) from USER"
M7czQJ.jpeg
0 Comments   [ + ] Show comments

Comments


All Answers

2
Two things.  
First, remove the quotes from what you put in Select Values, and the query will run.

Second, the USER table only has MANAGER_ID, so you'll need a different query.  Try this:

query: select distinct(M.FULL_NAME) from USER join USER M ON M.ID=USER.MANAGER_ID

That will return the name of any users who are set as managers of other users.
Answered 10/05/2018 by: ondrar
Black Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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