Sorting tickets by customer agency?

Moderator: crythias

Locked
knischan
Znuny newbie
Posts: 65
Joined: 29 Sep 2011, 05:18
Znuny Version: 3.0.11
Real Name: Ken
Company: Baltimore City Mayor's Office

Sorting tickets by customer agency?

Post by knischan »

Yet another question :) I'm using OTRS in a municipal environment. The customers are being pulled from our Active Directory. Is there some way to let OTRS know which agency they work for? We currently know john.doe is a Health Department child vaccination worker because he's in the Child Services OU which is a child of the Department of Public Health OU. Our "department" field in the AD is all over the place - john.doe's department field may be HD, Health, Health Dept, Health Department, etc. So for now my priority is to run a script to reset department based on OU then map department in OTRS - then figure out someway to run reports based on the department of the customer (if that's even possible).

Is that the best way to do it? Is there some alternative? Thanks!
OTRS 3.0.11 / IIS7 / MSSQL 2005 / VMware ESX
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Sorting tickets by customer agency?

Post by crythias »

I'd almost suggest department being your CustomerID field. It could help, perhaps.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Locked