[otrs] database question

2010-06-28 Thread Peter Leggett

Hi,

I am looking at setting up a helpdesk system based on OTRS for our dept.
I would authenticate agents and customers against our main University LDAP 
service.
But for the customer (and agent) data, our set up is such that the customer,
e.g staff, student, is held in a number of databases.
For example our LDAP service hold uid and email but another database
holds room number, telephone number.

My initial questions are :-

1. Is it possible to somehow obtain the selection of user data, e.g. name, 
telephone,
email, room number from a variety of database sources at the same time ?
I can see one can have multiple database sources from the admin manual
but it is unclear if for a individual user can have data sourced from different
databases at the same time ?

2. Would I need to have a OTRS database pulling this data from the different 
sources
when the user first logs in ? or can it be done on the fly each time a user's 
info
is reqiured ?

3. If the data needs to be pulled into a OTRS database using say the 
AuthSyncModule
can this data be updated periodically some how from the master source databases?
Is there already a mechanisum to do this or would I have to write something ?

Many thanks for any help on this,

Pete

--
Peter F. Leggett
Computing Development Officer
Engineering, Mathematics and Physical Sciences
University of Exeter
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/


[otrs] Database question

2007-03-08 Thread Bas Rijniersce
Hello,
 
I'm afraid there will be more of these questions coming..
 
In table ticket it seems there is no link to the user table, there is
only customer_user and customer_user_id. Both of the field are varchar's
and don't link to user.id.
 
That surprised me, what happens if I rename the account. Are the tickets
that where created under the old name lo longer linked, or are they
updated by otrs if I rename the account?
 
Why not link to the user.id?
 
Bas
___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support orr consulting for your OTRS system?
=> http://www.otrs.com/