KACE Product Support : Pulling User location details into helpdesk page

Pulling User location details into helpdesk page

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

Posted by: chucksteel 7 years ago

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.

Answer this question

question