Hi dears,
I would like to print out a list of all customers, is it possible? if yes how? because i want to give my boss a list of all customers and writing all customers seems to be a big problem. plz if possible i need your help!
Kind Regards,
Print all user
Moderator: crythias
-
- Znuny newbie
- Posts: 37
- Joined: 19 Sep 2011, 10:09
- Znuny Version: 3.0
- Real Name: Kwizera Jean Florent
- Company: MINECOFIN
Re: Print all user
use the SQL Box
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 37
- Joined: 19 Sep 2011, 10:09
- Znuny Version: 3.0
- Real Name: Kwizera Jean Florent
- Company: MINECOFIN
Re: Print all user
Please Jojo can u help me more? i know it is mysql query but, i still ignore the name of table and fields, could you plz suggest me a querry i can use?jojo wrote:use the SQL Box
Thx a lot for ur help!
regards,
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Print all user
Try removing the limit entry in SQL Box, then
show tables
hmm... there's a table called users and a table called customer_user
we can
describe customer_user
or
describe users
ah... fields!
Select this_field, that_field from the_table
use csv instead of html...
show tables
hmm... there's a table called users and a table called customer_user
we can
describe customer_user
or
describe users
ah... fields!
Select this_field, that_field from the_table
use csv instead of html...
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: 37
- Joined: 19 Sep 2011, 10:09
- Znuny Version: 3.0
- Real Name: Kwizera Jean Florent
- Company: MINECOFIN
Re: Print all user
crythias wrote:Try removing the limit entry in SQL Box, then
show tables
hmm... there's a table called users and a table called customer_user
we can
describe customer_user
or
describe users
ah... fields!
Select this_field, that_field from the_table
use csv instead of html...
Hahaha Crythias,
Thx a lot for ur guidance but i'm trying and i can't find the result, have you tried and see if it works? for me i'm stuck it doesn't i don't know why! could you plz tell me more if possible? some query give " no result found " others give error messages, plz give me the one u tried and see if i can get them.
I appreciate ur work, and the way u're always there for us, thx a lot!
Regards,
-
- Znuny newbie
- Posts: 37
- Joined: 19 Sep 2011, 10:09
- Znuny Version: 3.0
- Real Name: Kwizera Jean Florent
- Company: MINECOFIN
Re: Print all user
Wow thx a lot, i've found it!

