/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Pulling User location details into helpdesk page

05/10/2016 341 views
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=JOHN FELIX ,OU=AUSTIN,OU=North America,O=GLOBAL.


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

Comments


All Answers

0
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

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