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 !
[SOLVED] Where are the customer data ?
Moderator: crythias
-
- 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 ?
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
-
- 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 ?
I can see all these customer users without company by this SQL query:
How can I associate these customer users to customer company ?
Code: Select all
SELECT TN, CUSTOMER_ID, CUSTOMER_USER_ID FROM ticket WHERE CUSTOMER_ID = CUSTOMER_USER_ID
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
-
- 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 ?
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
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
-
- 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 ?
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.
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