Hi All,

what are the other ways to pull  user location into Kace help desk, Im using location details from Inventory.

For Example     one of our User is located in AUSTIN  but shows in Inventory as  America/Chicago .


CN=Alex JOSEPH ,OU=Buenos Aires,OU=Latin America,O=GLOBAL


I have tried the below Query  but couldn't trim the location into helpdesk  page, Im trying to pull only city details

,but this query only pulls    North/Latin  America
SELECT  SUBSTRING_INDEX(SUBSTRING_INDEX(custom_2,',OU=',-2),',OU=',1), custom_2 FROM ORG1.USER where custom_2 <> ''
0 Comments   [ + ] Show Comments


Please log in to comment


Have you tried reversing your substring_index functions:
substring_index(custom_2, ',OU=', 1) should return Austin,OU=North America,O=GLOBAL
and then
substring_index(substring_index(custom_2, ',OU=', 1), ',OU=', -1) should return just Austin.

Answered 05/10/2016 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity