[SOLVED] Where are the customer data ?

Moderator: crythias

Post Reply
elitt
Znuny newbie
Posts: 70
Joined: 08 Jan 2015, 17:01
Znuny Version: 5.0.10
Real Name: Egareg JAOUEN
Company: Elitt

[SOLVED] Where are the customer data ?

Post by elitt »

When a new customer sends an email to open a new ticket or to add informations about an already opened one, I can add this customer user to a customer (company).

But I can't see if some of them remain unassociated to a customer company. Where can I find the list of all these customer users without company ?

I tried querying on SQL tables such as users, customer_user, customer_company... But I can't see the customers unassociated to company.

Thanks for your help !
Last edited by elitt on 19 Mar 2015, 10:51, edited 1 time in total.
OTRS v5.0.10 on Fedora25 with posgreSQL 9.4.9 database
elitt
Znuny newbie
Posts: 70
Joined: 08 Jan 2015, 17:01
Znuny Version: 5.0.10
Real Name: Egareg JAOUEN
Company: Elitt

Re: Where are the customer data ?

Post by elitt »

I can see all these customer users without company by this SQL query:

Code: Select all

SELECT TN, CUSTOMER_ID, CUSTOMER_USER_ID FROM ticket WHERE CUSTOMER_ID = CUSTOMER_USER_ID
How can I associate these customer users to customer company ?
Last edited by elitt on 19 Mar 2015, 10:51, edited 1 time in total.
OTRS v5.0.10 on Fedora25 with posgreSQL 9.4.9 database
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Where are the customer data ?

Post by crythias »

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
elitt
Znuny newbie
Posts: 70
Joined: 08 Jan 2015, 17:01
Znuny Version: 5.0.10
Real Name: Egareg JAOUEN
Company: Elitt

Re: Where are the customer data ?

Post by elitt »

Thanks.

Your answer confirms what I thought : no automated task available or no proper feature in OTRS.

My SQL query lets me see all the tickets with these unassociated customer users.
Because I don't have so much tickets affected, I will correct these one by one.
OTRS v5.0.10 on Fedora25 with posgreSQL 9.4.9 database
Post Reply