Pulling User location details into helpdesk page
,but this query only pulls North/Latin America
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.|
I have tried the below Query but couldn't trim the location into helpdesk page, Im trying to pull only city details
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(custom_2,',OU=',-2),',OU=',1), custom_2 FROM ORG1.USER where custom_2 <> ''