10/04/2018 200 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"
0 Comments   [ + ] Show comments


All Answers

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
Second Degree Brown 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